C# 结合Microsoft.Office.Interop.Excel写入Excel

最新推荐文章于 2025-07-12 10:01:46 发布

原创

最新推荐文章于 2025-07-12 10:01:46 发布 · 9.6k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#c# #application #excel #object #c

这篇博客介绍了如何利用C#结合Microsoft.Office.Interop.Excel库来读写Excel文件，详细讲解了创建工作簿、设置单元格值、保存文件等关键步骤，适合C#开发者进行Excel自动化处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System.Reflection;
using Microsoft.Office.Interop.Excel;

protected void Page_Load(object sender, EventArgs e)
{
    Application app = new Application();
    //加载模板
    Workbook workbook = app.Workbooks.Open(Server.MapPath("~/Template.xlt"), 
        Missing.Value, Missing.Value,Missing.Value, Missing.Value,
        Missing.Value, Missing.Value, Missing.Value, Missing.Value,
        Missing.Value, Missing.Value, Missing.Value, 
        Missing.Value, Missing.Value, Missing.Value);
         
    try
    {
       //获取模板中第一个sheet页
        Worksheet worksheet = workbook.Sheets.get_Item(1) as Worksheet;

       //向Excel单元格填充数据
        worksheet.Cells[2, 1] = "66";
       worksheet.Cells[2, 2] = "24";
       worksheet.Cells[2, 3] = "女";
       worksheet.Cells[3, 1] = "lulu";
       worksheet.Cells[3, 2] = "20";
       worksheet.Cells[3, 3] = "男";

       //利用公式计算满足某条街的总和，单独分出3是为了可以在程序中替换该值
        worksheet.Cells[2, 4] = "=C