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