public void painItem(){
SpreadsheetClass Sheet = new SpreadsheetClass();
Sheet.get_Range(Sheet.Cells[1, 1], Sheet.Cells[2, column.Count + 1]).set_RowHeight(20);//设置第一行的高度
Sheet.Columns.AutoFit();//自动适应列
Sheet.get_Range(Sheet.Cells[1, 1], Sheet.Cells[2, column.Count + 1]).set_VerticalAlignment(XlVAlign.xlVAlignCenter);//上下居中
Sheet.get_Range(Sheet.Cells[1, 1], Sheet.Cells[2, column.Count + 1]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);//左右居中
Sheet.get_Range(Sheet.Cells[1, 1], Sheet.Cells[1, 1]).Font.set_Bold(true);//标题行加粗字体
Sheet.get_Range(Sheet.Cells[1, 1], Sheet.Cells[1, 1]).Font.set_Size(14);//设置字体大小
Sheet.get_Range(Sheet.Cells[2, 1], Sheet.Cells[2, column.Count + 1]).Interior.set_ColorIndex(43);//背景色
Sheet.ActiveCell[1, 1] = "数据一览统计表"; //第一行为报表的标题
Sheet.get_Range(Sheet.Cells[1, 1], Sheet.Cells[1, column.Count + 1]).set_MergeCells(true); //合并单元格
Sheet.get_Range(Sheet.Cells[1, 1], Sheet.Cells[dt.Rows.Count + 2, column.Count + 1]).Borders.set_LineStyle(XlLineStyle.xlContinuous);//画边线
string FileName = strAbsolutePath + "WebGraphReportB01.html";
if (File.Exists(FileName)){
File.Delete(FileName);
}
//将Sheet导出成html格式的数据,在前台页面显示用
Sheet.Export(FileName, SheetExportActionEnum.ssExportActionNone, SheetExportFormat.ssExportHTML);
}
转自:http://blog.youkuaiyun.com/kaifa123/article/details/7613661