private static void ToEXecl(DataTable tblDatas)
{
String strFileName = "F:/excel/BBS.xls";
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet("new sheet");
// 设置列宽
sheet.SetColumnWidth(0,1500);
sheet.SetColumnWidth(1, 8000);
sheet.SetColumnWidth(2, 4000);
sheet.SetColumnWidth(3, 5000);
sheet.SetColumnWidth(4, 5000);
sheet.SetColumnWidth(5, 16000);
sheet.SetColumnWidth(6, 3000);
sheet.SetColumnWidth(7, 6000);
sheet.SetColumnWidth(8, 12000);
HSSFFont font1 = workbook.CreateFont();
font1.FontName="宋体";
font1.FontHeightInPoints=16;
//表头样式
HSSFCellStyle style1 = workbook.CreateCellStyle();
//颜色要两行
style1.FillForegroundColor = HSSFColor.YELLOW.index;
style1.FillPattern = CellF
转播
