private static void WriteTableValues(StreamWriter sWriter, ExcelTableParameters p, DataTable table) { int rowsCount = 0; foreach (DataRow row in table.Rows) { //write in new row var highLight = p.RowsToHighlight.Contains(rowsCount); rowsCount++; bool lastRow = p.LastRowAsTotalRow && rowsCount == table.Rows.Count; sWriter.Write("<TR>"); for (int i = 0; i < table.Columns.Count; i++) { if (lastRow || highLight) { if (lastRow) { sWriter.Write(string.Format("<Td style=\"background:#E1E1E1;font-weight:bold;\">{0}</Td>", row[i].ToString())); } else { sWriter.Write(string.Format("<Td style=\"background:#262626;font-weight:bold; color:white;\">{0}</Td>", row[i].ToString())); } } else { sWriter.Write(string.Format("<Td>{0}</Td>", row[i].ToString())); } } sWriter.Write("</TR>"); } }
public ExcelTableParameters GetNewtableParameter() { var t = new ExcelTableParameters(); TablesParameters.Add(t); return(t); }
private static void WriteBottomTitles(StreamWriter sWriter, ExcelTableParameters p) { if (p.BottomTitles != null && p.BottomTitles.Keys.Count > 0) { foreach (var titleRow in p.BottomTitles) { if (!titleRow.Value) { sWriter.Write(string.Format("<TR border='1'><Td colspan=\"{1}\" style=\"font-size:18px;\">{0}</Td></TR>", titleRow.Key, p.ColumnsCount)); } else { sWriter.Write(string.Format("<TR border='1'><Td colspan=\"{1}\" style=\"font-size:18px;\"><center>{0}</center></Td></TR>", titleRow.Key, p.ColumnsCount)); } } } }
private static void WriteTopTitles(StreamWriter sWriter, ExcelTableParameters p) { sWriter.Write("<Table dir=\"rtl\" bgColor='#ffffff' borderColor='#000000' cellSpacing='0' cellPadding='0' style='font-size:14px; font-family:Calibri; background:#ffffff;'>"); // header rows if (p.TopTitles != null && p.TopTitles.Keys.Count > 0) { foreach (var titleRow in p.TopTitles) { if (!titleRow.Value) { sWriter.Write(string.Format("<TR border='1'><Td colspan=\"{1}\" style=\"font-size:18px;background:#458AC9;font-weight:bold; color:white;\">{0}</Td></TR>", titleRow.Key, p.ColumnsCount)); } else { sWriter.Write(string.Format("<TR border='1'><Td colspan=\"{1}\" style=\"font-size:18px;background:#458AC9;font-weight:bold; color:white;\"><center>{0}</center></Td></TR>", titleRow.Key, p.ColumnsCount)); } } } }