public static TableModel CogeFetcher(MemoryStream memoryStream) { ExcelSupport excelSupport = new ExcelSupport(); TableModel CogeTable = new TableModel(); TableModel CogeOut = new TableModel(); TableModel CogeDisplayTable = new TableModel(); RowsModel rowsModel = new RowsModel(); try { CogeTable = excelSupport.ExcelTableLoader(memoryStream, "REV_CUST"); Console.WriteLine("Coge File Loaded"); CogeDisplayTable = BuildCoge(CogeTable); Console.WriteLine("File Decoded"); CogeOut = SortTable(CogeDisplayTable); CogeOut.Header = CogeDisplayTable.Header; CogeOut.Other = CogeDisplayTable.Other; CogeOut.Footer = CogeDisplayTable.Footer; return(CogeOut); } catch (Exception ex) { Console.WriteLine(ex); return(null); } }
public RowsModel ExcelTableLoader(string ExcelPath, string TableName, bool RowModelFlag) { RowsModel LoadedRowTable = new RowsModel(); MemoryStream inMemoryCopy = new MemoryStream(); try { using (FileStream fs = File.OpenRead(ExcelPath)) { fs.CopyTo(inMemoryCopy); } TablesModel Tables = new TablesModel(); ExcelPackage excelPackage = new ExcelPackage(inMemoryCopy); var package = excelPackage; Tables = Parse(package, false); var Result = FetchTableByName(Tables, TableName); RowsModel rowsModel = new RowsModel(); foreach (var row in Result.Body) { RowsModel.RowModel row2 = new RowsModel.RowModel(); int cell2 = 0; foreach (var cell in row.Cells) { row2.Cells[cell2].Value = cell.Value; cell2 += 1; } rowsModel.Rows.Add(row2); } LoadedRowTable = rowsModel; var count = LoadedRowTable.Rows.Count; Debug.WriteLine("Row Count: " + count); } catch (Exception ex) { Debug.WriteLine(ex.Message); return(null); } return(LoadedRowTable); }
public static TableModel GecoFetcher(string path) { ExcelSupport excelSupport = new ExcelSupport(); TableModel GecoTable = new TableModel(); TableModel GecoDisplayTable = new TableModel(); RowsModel rowsModel = new RowsModel(); try { GecoTable = excelSupport.ExcelTableLoader(path, "Profit & Loss"); rowsModel = excelSupport.ExcelTableLoader(path, "Profit & Loss", true); Console.WriteLine("Geco File Loaded"); GecoDisplayTable = BuildGeco(GecoTable); Console.WriteLine("File Decoded"); return(GecoDisplayTable); } catch (Exception ex) { Console.WriteLine(ex); return(null); } }
public static TableModel GecoFetcher(MemoryStream memoryStream) { RowsModel RowsSorted = new RowsModel(); RowModel rowModel = new RowModel(); ExcelSupport excelSupport = new ExcelSupport(); TableModel GecoTable = new TableModel(); TableModel GecoDisplayTable = new TableModel(); //IList<RowModel> rowsModel; try { GecoTable = excelSupport.ExcelTableLoader(memoryStream, "Profit & Loss"); Console.WriteLine("Geco File Loaded"); GecoDisplayTable = BuildGeco(GecoTable); Console.WriteLine("File Decoded"); return(GecoDisplayTable); } catch (Exception ex) { Console.WriteLine(ex); return(null); } }
private static TableModel GecoGather(List <GecoPosition> gecoPositions, TableModel table) { RowsModel Rows = new RowsModel(); TableModel displayTable = new TableModel(); RowModel headerRow = GetHeaderRow(table); //displayTable.Body.Add(headerRow); displayTable.Header = headerRow; int entityCount = gecoPositions.Count - 1; var gecoRow = new RowModel(); for (int i = 0; i < entityCount; i++) { var GecoRow = new RowModel(); GecoRow = ParseGecoRow(table, gecoPositions[i].CustomerName, gecoPositions[i].TotalRow); displayTable.Body.Add(GecoRow); } gecoRow = ParseGecoRow(table, gecoPositions[entityCount].CustomerName, gecoPositions[entityCount].CustomerRow); displayTable.Footer = gecoRow; return(displayTable); }