Excel的设置 .net

using Microsoft.Office.Interop.Owc11;

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[2, 1], Sheet.Cells[dt.Rows.Count + 2, 1]).set_ColumnWidth(5);//单元格的列宽



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