使用ADO读写Excel文件.pdfVIP

使用ADO 读写Excel 文件 This article was previously published under Q278973 SUMMARY The ExcelADO.exe sample illustrates how you can use ActiveX Data Objects (ADO) with the Microsoft Jet OLE DB 4.0 Provider to read and write data in Microsoft Excel workbooks. Back to the top MORE INFORMATION The following file is available for download from the Microsoft Download Center: ExcelADO.exe Release Date: December 12, 2000 For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: 119591 How to Obtain Microsoft Support Files from Online Services Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. Why Use ADO? The use of ADO to transfer data to or retrieve data from an Excel workbook gives you, the developer, several advantages over Automation to Excel: • Performance. Microsoft Excel is an out-of-process ActiveX server. ADO runs in-process, and saves the overhead of costly out-of-process calls. • Scalability. For Web applications, it is not always desirable to automate Microsoft Excel. ADO presents you with a more scaleable solution to handle data in a workbook. ADO can be used strictly to transfer raw data to a workbook. You cannot use ADO to apply formats or formulas to cells. However, you can transfer data to a workbook that is pre-formatted and the format is maintained. If you require conditional formatting after the data is inserted, you can accomplish this formatting with Automation or with a macro in the workbook. Jet OLE DB Provider Specifics for Excel Workbooks The Microsoft Jet database engine can be used to access data in other database file formats, such as Excel workbooks, through