public List <ParsedTables> ParseTablesFirstName() { List <ParsedTables> plist = new List <ParsedTables>(1); List <Table> tList = new List <Table>(Content); for (int i = 0; i < tList.Count; i++) { ParsedTables pt = new ParsedTables(tList[i].FirstName); pt.Add(tList[i]); for (int j = i + 1; j < tList.Count; j++) { if (tList[i].FirstName == tList[j].FirstName) { pt.Add(tList[j]); tList.RemoveAt(j); j--; } } plist.Add(pt); } return(plist); }
public List <ParsedTables> ParseTablesByDates() { List <Table> tList = new List <Table>(Content); List <ParsedTables> m_ParsedTables = new List <ParsedTables>(NumberOfIndividDates()); for (int i = 0; i < tList.Count; i++) { ParsedTables parsedTables = new ParsedTables(tList[i].FirstName); parsedTables.Add(tList[i]); for (int j = i + 1; j < tList.Count; j++) { if (tList[i].FirstName == tList[j].FirstName) { parsedTables.Add(tList[j]); tList.RemoveAt(j); j--; } } m_ParsedTables.Add(parsedTables); } return(m_ParsedTables); }
public void GenerateExcelDatePage(string date, ParsedTables list) { //Basic m_WorkSheetCollection[m_WSCollectionIndex] = m_WorkBook.Worksheets.Add(); m_WorkSheetCollection[m_WSCollectionIndex].Name = date; m_WorkSheetCollection[m_WSCollectionIndex].StandardWidth = 30; int RowToBegin = 2; int ColumnToBegin = 1; for (int i = 0, j = 0; j < list.Count; j++, i = i + 3) { //grid var cells = m_WorkSheetCollection[m_WSCollectionIndex] .get_Range($"{(char)('A' + RowToBegin - 2)}{1 + ColumnToBegin + i}", $"{(char)('B' + RowToBegin - 2)}{3 + ColumnToBegin + i}"); cells.Borders[Excel.XlBordersIndex.xlInsideVertical].LineStyle = Excel.XlLineStyle.xlContinuous; // внутренние вертикальные cells.Borders[Excel.XlBordersIndex.xlInsideHorizontal].LineStyle = Excel.XlLineStyle.xlContinuous; // внутренние горизонтальные cells.Borders[Excel.XlBordersIndex.xlEdgeTop].LineStyle = Excel.XlLineStyle.xlContinuous; // верхняя внешняя cells.Borders[Excel.XlBordersIndex.xlEdgeRight].LineStyle = Excel.XlLineStyle.xlContinuous; // правая внешняя cells.Borders[Excel.XlBordersIndex.xlEdgeLeft].LineStyle = Excel.XlLineStyle.xlContinuous; // левая внешняя cells.Borders[Excel.XlBordersIndex.xlEdgeBottom].LineStyle = Excel.XlLineStyle.xlContinuous; //individ m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + RowToBegin, ColumnToBegin] .Font.Bold = true; m_WorkSheetCollection[m_WSCollectionIndex].Range[ m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + RowToBegin, ColumnToBegin], m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + RowToBegin, ColumnToBegin + 1] ].Font.Size = 20; m_WorkSheetCollection[m_WSCollectionIndex].Range[ m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + RowToBegin, ColumnToBegin], m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + RowToBegin, ColumnToBegin + 1] ].Merge(); //Set Times New Roman to ALL m_WorkSheetCollection[m_WSCollectionIndex].Cells.HorizontalAlignment = Excel.Constants.xlCenter; m_WorkSheetCollection[m_WSCollectionIndex].Cells.Font.Name = "Times New Roman"; m_WorkSheetCollection[m_WSCollectionIndex].Range[ m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + 3, ColumnToBegin], m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + 4, ColumnToBegin + 1] ].Font.Size = 14; //Заголовок m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + RowToBegin, ColumnToBegin] = list[j].SecondName; //Параметры m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + 3, ColumnToBegin] = "кол-во"; m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + 3, ColumnToBegin + 1] = "стоимость"; //Значения m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + 4, ColumnToBegin] = list[j].Content.Count; m_WorkSheetCollection[m_WSCollectionIndex].Cells[i + 4, ColumnToBegin + 1] = list[j].GetSummary(); } m_WorkSheetCollection[m_WSCollectionIndex] = null; ++m_WSCollectionIndex; // Открываем созданный excel-файл m_ExcelApplication.Visible = true; m_ExcelApplication.UserControl = true; }