合并单元格
Excel.Range rHA = worksheet.get_Range(rowAFrom,rowATo);
rHA.Merge(0);
自动列宽
worksheet.Cells.EntireColumn.AutoFit();
设置字体
worksheet.Cells.Font.Name="Arial";
worksheet.Cells.Font.Size=10;
worksheet.Cells.Font.Size=10;
myExcel.Cells.Font.Bold = false;
对其方式
_excelRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;//水平居中
_excelRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;//垂直居中
_excelRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;//垂直居中
单元格边框
myExcel.Cells.Borders.LineStyle = 1;
保存和释放
//保存和退出
worksheet.SaveAs(strName,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
myExcel.Quit();
myExcel.Quit();
//释放
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
//杀死进程
System.Diagnostics.Process[] excelProc = System.Diagnostics.Process.GetProcessesByName("EXCEL");
//垃圾回收
GC.Collect ();
单元格的值可以通过代码加入公式
mySheet.Cells[1,4]= ”IF(ISERROR(SUM(F{0},K{0})/D{0}*100),\"\",SUM(F{0},K{0})/D{0}*100)“;
拷贝内容到剪贴板
_excelRange.Copy(Type.Missing);
_excelRange.CopyPicture(XlPictureAppearance.xlScreen, XlCopyPictureFormat.xlBitmap);