string path = Server.MapPath("~/myfolder/myfile.xlsx"); string connExcel= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=NO;IMEX=1\";"; connExcel.Open(); DataTable dtExcelSchema; dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString(); connExcel.Close(); sting query ="Select * From [" + SheetName + "]";
sting query ="Select * From [" + SheetName + "]";
sting query =@"Select * From [" + SheetName + "$]";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)