Use ADO. Net to transfer data to a worksheet

Use ADO. Net to transfer data to a worksheet

You can use Microsoft jet ole db to provideProgramAdd records to tables in an existing Excel Workbook. In ExcelTableIt is only a region composed of cells. The region may have a specified name. Generally, the first line of a region contains the title (or field name), and all subsequent rows in the region contain records.

The followingCodeTwo new records are added to the table in book7.xls. In this case, the table is sheet1:

// Establish a connection to the data source. system. data. oledb. oledbconnection objconn = new system. data. oledb. oledbconnection ("provider = Microsoft. jet. oledb.4.0; Data Source = "+ m_strsamplefolder +" book7.xls; extended properties = Excel 8.0; "); objconn. open (); // Add two records to the table named 'mytable '. system. data. oledb. oledbcommand objcmd = new system. data. oledb. oledbcommand (); objcmd. connection = objconn; objcmd. commandtext = "insert into mytable (firstname, lastname)" + "values ('bill ', 'Brown')"; objcmd. executenonquery (); objcmd. commandtext = "insert into mytable (firstname, lastname)" + "values ('Joe ', 'Thomas')"; objcmd. executenonquery (); // close the connection. objconn. close ();