C# 操作Excel

来源：互联网发布：餐饮管理系统数据库编辑：程序博客网时间：2024/06/06 02:40

合并单元格

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;

myExcel.Cells.Font.Bold = false;

对其方式

_excelRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;//水平居中
_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();

//释放

System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
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);