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