C#输出数据到Excel

来源：互联网发布：数据割接方案编辑：程序博客网时间：2024/05/22 15:52

（1）在项目的添加引用“Microsoft Access 12.0 Object Library”

（2）引用相应的命名空间

using Microsoft.Office.Interop.Excel;
using System.Reflection; // For Missing.Value and BindingFlags
using System.Runtime.InteropServices; // For COMException

（3）添加代码至相应的位置

Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
            if (app == null)
            {
                Console.WriteLine("ERROR: EXCEL couldn't be started!");

            }

app.Visible = true;

Workbooks workbooks = app.Workbooks;

_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);

Sheets sheets = workbook.Worksheets;

            _Worksheet worksheet = (_Worksheet)sheets.get_Item(1);

            Range range = worksheet.get_Range(worksheet.Cells[1,1], worksheet.Cells[3, 3]);
            //Range range = worksheet.get_Range("A1", "C2");

//如果需要将所选区域设置为文本型
range.NumberFormatLocal="@";

Object[,] array = new Object[3, 3];

            for (int i = 0; i < 3; i++)
            {
                for (int j = 0; j < 3; j++)
                {
                    array[i,j] = i + j * 0.2;
                }
            }
                range.Value2 = array;