puresourcecode.com
Reading multiple excel sheets with different worksheet names
I would like to know how I can read multiple excel worksheet with different worksheet name in c# and with the used of oledb. I have this existing way to read multiple sheets (but with fixed worksheet name): DataSet ds = new DataSet(); var excelConnectionString = string.Format(“Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0”, path); OleDbConnection connection =...
Enrico