Taghow to update Excel

Code to update an Excel using DataSet and the OleDbDataAdapter in C#

C

using System; using System.Collections.Generic; using System.Text; using System.Data.OleDb; using System.Data; namespace ExcelDataAdapter { class Program {     static void Main(string[] args)     {         string xlsFile = @"C:\Temp\AdapterTest.xls";         string xlsSheet = @"Sheet1$";         // HDR=Yes means that the first row in the range is the header row (or field names) by default...

Category