/// <summary>
/// Reads all sheets in the excel workbook and returns as a ordered collection of data tables.
/// </summary>
/// <param name="builder">placeholder</param>
/// <param name="filename">excel file to load</param>
/// <returns>Ordered collection of tables corresponding to non-empty sheets. Table name corresponds to sheet name.</returns>
public static IList <MutableDataTable> ReadExcelAllSheets(this DataTableBuilder builder, string filename)
{
using (Stream input = new FileStream(filename, FileMode.Open, FileAccess.Read))
{
return(builder.ReadExcelAllSheets(input));
}
}
public static DataSet ToDataSet(string path, string sheetName)
{
var builder = new DataTableBuilder();
var list = builder.ReadExcelAllSheets(path);
//foreach(var mt in list)
//{
// mt.
//}
return(null);
}
