public MarketReport GetReport(string[] mass, ParserSettings Settings) { MarketReport report = new MarketReport(); report.series = new string[Settings.CountLine, Settings.CountColumns]; report.number = new string[Settings.CountLine, Settings.CountColumns]; string[,] masstemp = new string[Settings.CountLine, Settings.CountColumns]; report.title = mass[0]; for (int i = 1; i < Settings.CountLine + 1; i++) { string[] temp = mass[i].Split(' ').ToArray(); temp = temp.Where(x => x != "" && x != " ").ToArray(); int flag = 0; int longlinr = temp.Length / Settings.CountColumns; for (int j = 0; j < Settings.CountColumns; j++) { if (temp.Length <= flag) { break; } report.series[i - 1, j] = temp[flag]; report.number[i - 1, j] = temp[flag + 1]; flag += longlinr + 1; } } return(report); }
public void Bildblok(MarketReport report, ParserSettings Settings, int title) { var sheet = package.Workbook.Worksheets.Add("Лист печати " + title); int columsexcel = 2; int lineexcel = 2; for (int i = 0; i < Settings.CountLine; i++) { for (int j = 0; j < Settings.CountColumns; j++) { sheet.Row(lineexcel).Height = 100; sheet.Cells[lineexcel + 1, columsexcel].Value = report.series[i, j]; sheet.Cells[lineexcel + 2, columsexcel].Value = report.number[i, j]; lineexcel += 3; } lineexcel = 2; columsexcel++; } sheet.Cells[lineexcel + (3 * Settings.CountColumns) + 1, 2].Value = report.title; }