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;
}
