![]() The following example illustrates how Excel automatically updated. To do this, follow these steps: On the Project menu, click Add. This is the entire range of all cells, B2 through B25, that we want to use as a range. Add a reference to the Microsoft Excel Object Library. Select Windows Application from the Visual C Project types. On the File menu, click New, and then click Project. OleDbDataReader dr = new OleDbCommand("SELECT * FROM ", objConn). Create an Automation Client for Microsoft Excel. OleDbConnection objConn = new OleDbConnection(sConnectionString) SConnectionString = "Provider=.12.0 " "Data Source=" tempFile " " "Extended Properties=\"" FileType "HDR=No IMEX=0 \"" Get the version for Office 2007 ( ) if you have 32bit System, or use Office 2010 BETA version (compatible with 2007) for 64bit - īelow is an extract from my project to help you: string sConnectionString = ""
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |