public ExcelDataPage2(ExcelWorksheet sheet)
{
settings = new StatPageSettings(sheet);
var excelTable = sheet.Tables.Where(x => x.Address.Start.Row >= 3).FirstOrDefault();
table = new RowDataTable(excelTable);
}
public StatPageSettings(ExcelWorksheet sheet)
{
settings = null;
var table = sheet.Tables.Where(x => x.Address.Start.Row == 1).FirstOrDefault();
if (table != null)
{
settings = new RowDataTable(table);
}
}
public string GetSubTableJS(DataFilters filters, DataFields columns)
{
RowDataTable table = tables.Where(x => x.name == filters.tableName).FirstOrDefault();
if (table == null)
{
return(null);
}
else
{
return(table.GetSubTableJS(filters, columns));
}
}
internal string GetSearchTableResult(DataFilters filters, DataFields columns)
{
var page = GetPageByName(filters.tableName);
if (page == null)
{
return(null);
}
RowDataTable table = page.table;
if (table == null)
{
return(null);
}
else
{
return(table.GetSubTableJS(filters, columns));
}
}
public string GetSubTableJS(DataFilters filters, DataFields columns)
{
var page = GetPageByName(filters.tableName);
if (page == null)
{
return(null);
}
RowDataTable table = page.table;
if (table == null)
{
return(null);
}
else
{
string json = table.GetSubTableJS(filters, columns);
return(json);
}
}
public ExcelMenuPage(ExcelWorkbook workbook)
{
var sheet = workbook.Worksheets[menuSheetName];
if (sheet == null)
{
return;
}
var table = sheet.Tables.First();
if (table == null)
{
return;
}
menu = new RowDataTable(table);
DeleteRowsWithoutLevels();
AddCorrectLevelColumn();
AddFullPathColumn();
}