//设置行高
xWs.get_Range(xWs.Cells[2, 1], xWs.Cells[rowPosition - 1, 13]).RowHeight = 24.75;
//设置列宽
xWs.get_Range(xWs.Cells[1, 1], xWs.Cells[rowPosition - 1, 1]).ColumnWidth = 3.75;
//设置背景色
xWs.get_Range(xWs.Cells[1, 1], xWs.Cells[contractRowPostion - 1, 13]).Cells.Interior.Color = System.Drawing.ColorTranslator.ToOle(Color.FromArgb(153, 204, 255)); //加粗部分一定需要,否则会报错“不能通过 IDispatch 调用带有 System.Color 参数或返回类型的方法。”
//设置字体
xWs.get_Range(xWs.Cells[1, 1], xWs.Cells[rowPosition - 1, 13]).Cells.Font.Size = 10;
//加粗
xWs.get_Range(xWs.Cells[1, 1], xWs.Cells[rowPosition - 1, 13]).Cells.Font.Bold = true;
//保存
xWs.SaveAs(this.Request.PhysicalApplicationPath + "TxznInvoiceTest//" + "Test.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
excel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject((object)excel);
GC.Collect(); //回收
自己编写的描述的太少,看看这个挺详细的http://topic.csdn.net/t/20060503/14/4728846.html
另外,下载这个http://download.csdn.net/source/168787 基本上导出Excel的问题就解决了~~