LorDong's Blog

1. 首先添加Excel的Reference到项目中
右击项目的References，选“Add Reference...”菜单，在COM组里选择“Microsoft Excel 11.0 Object Labrary”（安装的Excel版本不一样这里的版本可能会有变化，我这里是Excel 2003）

2. 新建excel文件实例代码
Microsoft.Office.Interop.Excel.Application app = null;
Microsoft.Office.Interop.Excel.Workbook workbook = null;
Microsoft.Office.Interop.Excel.Worksheet sheet = null;
object missing = System.Reflection.Missing.Value;
try
{
app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = false;        // 不显示，仅后台生成
workbook = app.Workbooks.Add(true); // 如果打开已存在文件，这里用Open，保存使用Save
// 添加sheet的方法
workbook.Worksheets.Add(missing, missing, missing, missing);
// 修改sheet名的方法，注意sheet的下标从1开始
sheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
sheet.Name = "new sheet name";
// 这里给sheet填充内容部分略
// 如果文件已经存在又不想让“是否替换”的提示窗体显示出来，需要先调用File.Delete来删除文件
workbook.SaveAs(filename, missing, missing, missing, missing, missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, missing, missing,
missing, missing, missing);
workbook.Close(false, missing, missing);
app.Quit();
workbook = null;
app = null;
GC.Collect();
}
catch (Exception ex)
{
if (app != null)
{
app.Quit();
app = null;
GC.Collect();
}
}

3. 设置单个单元格的内容和属性
Microsoft.Office.Interop.Excel.Range range;
range = sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[1, 1]);        // 注意cell的下标从1开始
range.Value2 = "value";        // 设置内容
range.Font.Bold = true;        // 粗体
range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignRight;  // 对齐方式

4. 一个个单元格的填充内容很费时间，解决办法是先填充一个内存Array，然后把Array赋给sheet的对应区域

Tags: C#/.NET

This entry was posted on 星期三, 4月 22nd, 2009 at 15:58 and is filed under 东东博客. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.