/// <summary>
/// create an Excel file from the given Datatable
/// </summary>
/// <param name="ns"></param>
/// <param name="table"></param>
/// <param name="title"></param>
/// <returns></returns>
public string GenerateExcelFile(string ns, DataTable table, string title, long dsId)
{
ExcelWriter writer = new ExcelWriter();
string path = generateDownloadFile(ns, dsId, title, ".xlsm", writer);
writer.AddDataTuplesToFile(table, path, dsId);
return(path);
}
/// <summary>
/// create an Excel file from the given Datatable
/// </summary>
/// <param name="ns"></param>
/// <param name="table"></param>
/// <param name="title"></param>
/// <returns></returns>
public string GenerateExcelFile(string ns, DataTable table, string title, long dsId, string ext = ".xlsm", bool withUnits = false)
{
ExcelWriter writer = new ExcelWriter();
string path = createDownloadFile(ns, dsId, title, ext, writer);
string[] units = null;
string[] columns = getColumnNames(table);
if (withUnits)
{
units = getUnits(dsId, columns);
}
writer.AddDataTuplesToFile(table, path, dsId, units);
return(path);
}
