C# Winform里面输出数据到Excel的问题

最新推荐文章于 2025-08-15 11:48:31 发布

shixinbao

最新推荐文章于 2025-08-15 11:48:31 发布

阅读量723

点赞数

CC 4.0 BY-SA版权

文章标签： excel winform c# interop microsoft office

本文链接：https://blog.youkuaiyun.com/shixinbao/article/details/1685372

本文介绍如何使用C#和Microsoft Office Interop Excel库来创建Excel工作表，并演示了如何填充特定范围内的单元格。

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

using System;

using System.Reflection;

using Microsoft.Office.Interop.Excel;

public class CreateExcelWorksheet

{

    static void Main()

    {

        Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

        if (xlApp == null)

        {

            Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct.");

            return;

        }

        xlApp.Visible = true;

        Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);

        Worksheet ws = (Worksheet)wb.Worksheets[1];

        if (ws == null)

        {

            Console.WriteLine("Worksheet could not be created. Check that your office installation and project references are correct.");

        }

        // Select the Excel cells, in the range c1 to c7 in the worksheet.

        Range aRange = ws.get_Range("C1", "C7");

        if (aRange == null)

        {

            Console.WriteLine("Could not get a range. Check to be sure you have the correct versions of the office DLLs.");

        }

        // Fill the cells in the C1 to C7 range of the worksheet with the number 6.

        Object[] args = new Object[1];

        args[0] = 6;

        aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args);



        // Change the cells in the C1 to C7 range of the worksheet to the number 8.

        aRange.Value2 = 8;

    }

}