导出Excel 常用属性（2）

 

//设置行高

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.youkuaiyun.com/t/20060503/14/4728846.html

 

另外，下载这个http://download.youkuaiyun.com/source/168787 基本上导出Excel的问题就解决了~~