public void BindData(string excelDocumentPath) { MSExcel excel = new MSExcel(false); DataTable dt = new DataTable(); dt.EnsureColumns<string>("Id", "Name"); //foreach (Excel.Worksheet ws in excel.Worksheets) //{ // //dt.Rows.Add(ws.s //} excel.CloseFile(); }
public System.Data.DataTable GetWorksheets() { System.Data.DataTable dt = new System.Data.DataTable("Worksheets"); dt.EnsureColumns<string>("Id", "Name"); if (WorksheetCount > 0) { foreach (Excel.Worksheet ws in Worksheets) { DataRow dr = dt.NewRow(); dr["Id"] = ws.Name; dr["Name"] = ws.Name; dt.Rows.Add(dr); } } return dt; }