private void footerPrint(ExcelXmlParser parser) { cols = parser.getColumnsInfo("foot"); ExcelBorder border = getBorder(); if (parser.getWithoutHeader() == false) { ExcelFont font = wb.CreateFont(FontFamily, FooterFontSize); font.Bold = true; if (HeaderTextColor != "FF000000") { font.Color = HeaderTextColor; } for (uint row = 1; row <= cols.Length; row++) { uint rowInd = (uint)(row + headerOffset); sheet.Rows[rowInd].Height = RowHeight; for (uint col = 1; col <= cols[row - 1].Length; col++) { if (BGColor != "FFFFFFFF") { sheet.Cells[rowInd, col].Style.Fill.ForegroundColor = BGColor; } sheet.Cells[rowInd, col].Style.Font = font; //TODO add text color, vertical alignment, horizontal alignment sheet.Cells[rowInd, col].Style.Border = border; sheet.Cells[rowInd, col].Value = cols[row - 1][col - 1].GetName(); } } } headerOffset += cols.Length; }
private void headerPrint(ExcelXmlParser parser) { cols = parser.getColumnsInfo("head"); //Widths int[] widths = parser.getWidths(); if (this.Widths != null) { foreach (var index in this.Widths.Keys) { if (index >= 0 && index < widths.Length) { widths[index] = Widths[index]; } } } this.cols_stat = widths.Length; int sumWidth = 0; for (int i = 0; i < widths.Length; i++) { sumWidth += widths[i]; } if (parser.getWithoutHeader() == false) { ExcelFont font = wb.CreateFont(FontFamily, HeaderFontSize); font.Bold = true; if (HeaderTextColor != "FF000000") { font.Color = HeaderTextColor; } ExcelBorder border = getBorder(); for (uint row = 1; row <= cols.Length; row++) { sheet.Rows[row].Height = RowHeight; for (uint col = 1; col <= cols[row - 1].Length; col++) { sheet.Cells[row, col].Style.Font = font;//if bold font assigned after border - all table will be bold, weird, find out later sheet.Cells[row, col].Style.Border = border; sheet.Columns[col].Width = widths[col - 1] / scale; String name = cols[row - 1][col - 1].GetName(); if (BGColor != "FFFFFFFF") { sheet.Cells[row, col].Style.Fill.ForegroundColor = BGColor; } ///TODO: ///font color, merge cells, alignment sheet.Cells[row, col].Value = name; colsNumber = (int)col; } } headerOffset = cols.Length; } }