static void Main(string[] args) { List <ExcelTable> l = new List <ExcelTable>(); for (int k = 0; k < 4; k++) { ExcelTable table = new ExcelTable(); table.Landscape = true; //table.Title = "疑似黑广播信号出现情况" + (k + 1); table.ColumnCount = 10; int[] columnswidth = new int[table.ColumnCount]; ExcelTitle title = new ExcelTitle(); title.TableTitle = "疑似黑广播信号出现情况" + (k + 1); table.Title = title; ExcelHeader header = new ExcelHeader(); ExcelRow headerrow = (ExcelRow)table.CreateRow(); headerrow.Height = 20; ExcelCell headercell = (ExcelCell)headerrow.CreateCell(); headercell.Value = "表格描述信息"; headercell.Colspan = table.ColumnCount; headerrow.AddCell(headercell); List <Row> rows = new List <Row>(); rows.Add(new ExcelRow()); rows.Add(headerrow); header.Rows = rows; table.Header = header; ExcelFooter footer = new ExcelFooter(); //ExcelRow footerrow = (ExcelRow)table.CreateRow(); //footerrow.Height = 200; //ExcelCell footercell = (ExcelCell)footerrow.CreateCell(); //byte[] b = System.IO.File.ReadAllBytes(@"C:\Users\HRDS-ZENGPEIFENG\Pictures\th2X7ZWG1D.jpg"); //footercell.Value = Convert.ToBase64String(b); //footercell.Colspan = table.ColumnCount; //footercell.CellType = NPOIHelper.NPOI.Common.CellTypes.Image; //footerrow.AddCell(footercell); ExcelRow footerrow2 = (ExcelRow)table.CreateRow(); ExcelCell footercell2 = (ExcelCell)footerrow2.CreateCell(); footercell2.Colspan = table.ColumnCount; footercell2.CellType = NPOIHelper.NPOI.Common.CellTypes.String; footercell2.Value = "表格描述信息"; footerrow2.AddCell(footercell2); //footercell2 = (ExcelCell)footerrow2.CreateCell(); //footercell2.CellType = NPOIHelper.NPOI.Common.CellTypes.String; //footercell2.Value = "表格描述信息2"; //footerrow2.AddCell(footercell2); footerrow2.HaveRowBreak = true; List <Row> footerrows = new List <Row>(); footerrows.Add(new ExcelRow()); //footerrows.Add(footerrow); footerrows.Add(footerrow2); footer.Rows = footerrows; table.Footer = footer; ExcelTableHeader tableheader = new ExcelTableHeader(); ExcelTableBody tablebody = new ExcelTableBody(); //throws.Add(new ) for (int r = 0; r < table.ColumnCount; r++) { ExcelRow row; if (r == 0 || r == 1) { row = (ExcelRow)table.CreateRow(); row.Height = 28; } else { row = (ExcelRow)table.CreateRow(); } for (int i = 0; i < table.ColumnCount; i++) { ExcelCell cell = (ExcelCell)row.CreateCell(); if (r == 4 && i == 5) { cell.IsBasedOnDefaultStyle = true; cell.Style = "font-color:#03A8F4;border-color:#03A8F4;font-size:50;"; } //if (i == 1) //{ // cell.CellType = NPOIHelper.NPOI.Common.CellTypes.Numeric; // cell.Value = r * i; // cell.Style = "border:thin;font-color:red;font-weight:normal;text-align:left;"; //} //else //{ cell.CellType = NPOIHelper.NPOI.Common.CellTypes.String; if (r == 0 || r == 1) { cell.Value = "标题" + i + "\r\n(单位)"; columnswidth[i] = 12; } else { cell.Value = "行:" + r + " 列:" + i; } //} //cell.FontColor = HSSFColor.BlueGrey.Index; row.AddCell(cell); } if (r == 0 || r == 1) { tableheader.AddRow(row); } else { tablebody.AddRow(row); } } table.TableHeader = tableheader; table.TableBody = tablebody; table.ColumnWidths = columnswidth; l.Add(table); } ExcelHelper excelhelper = new ExcelHelper(l); MemoryStream s = excelhelper.RenderToXls(); bool issaved = excelhelper.SaveToFile(s, "d:/test.xls"); //issaved = false; if (issaved) { IPrint proxy = null; RemotingConfiguration.Configure(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile, false); proxy = (IPrint)Activator.GetObject(typeof(IPrint), "tcp://172.39.8.173:1235/Print/PrintURL"); proxy.ExcelPrint("d:/test.xls", "疑似黑广播信号出现情况1", new PrintCallBackHandler()); //excelhelper.ExcelPrint("d:/test.xls", "疑似黑广播信号出现情况1"); } }