需要下载NPOI.dll
下载地址:点击打开链接
public void Batch_Update()
{
HSSFWorkbook hwb = new HSSFWorkbook();
MemoryStream ms = new MemoryStream();
Sheet sheet = hwb.CreateSheet();//默认是sheet0
Row row1 = sheet.CreateRow(0);
Cell cell = row1.CreateCell(0);
cell.SetCellValue("上海XXXX发展有限公司");
sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, 21));//合并列 该方法的参数次序是:开始行号,结束行号,开始列号,结束列号。
row1.Height = 30 * 30; //行高
cell.CellStyle = HeadStyle(hwb);
Row row2 = sheet.CreateRow(1);
Cell cell2 = row2.CreateCell(0);
cell2.SetCellValue("XX市XX区XX路XX号XX楼X-XX \r\n TEL:9876543210 FAX:123456");
sheet.AddMergedRegion(new CellRangeAddress(1, 1, 0, 21));
row2.Height = 30 * 30;
cell2.CellStyle = Sub_HeadStyle(hwb);
sheet.SetColumnWidth(0, 16 * 256);
hwb.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment; filename=导出.xls"));
Response.BinaryWrite(ms.ToArray());
hwb = null;
ms.Close(); ms.Dispose();
}
/// <summary>
/// 大标题
/// </summary>
/// <param name="hwb"></param>
/// <returns></returns>
public CellStyle HeadStyle(HSSFWorkbook hwb)
{
CellStyle tstyle = hwb.CreateCellStyle();
tstyle.Alignment = HorizontalAlignment.CENTER;
tstyle.VerticalAlignment = VerticalAlignment.CENTER;
Font tfont = hwb.CreateFont();
tfont.FontHeight = 22 * 22;
tfont.FontName = "华文行楷";
tfont.Color = HSSFColor.RED.index;
tfont.Boldweight = short.MaxValue;
tstyle.SetFont(tfont);
return tstyle;
}
/// <summary>
/// 副标题
/// </summary>
/// <param name="hwb"></param>
/// <returns></returns>
public CellStyle Sub_HeadStyle(HSSFWorkbook hwb)
{
CellStyle cstyle = hwb.CreateCellStyle();
cstyle.Alignment = HorizontalAlignment.CENTER;
cstyle.VerticalAlignment = VerticalAlignment.CENTER;
Font cfont = hwb.CreateFont();
cstyle.WrapText = true; // 换行 要配合\n使用
cfont.FontHeight = 15 * 15;
cfont.FontName = "微软雅黑";
cfont.Boldweight = short.MaxValue;
cstyle.SetFont(cfont);
return cstyle;
}