C#下使用Excel 2007 COM接口将数据保存为Excel文件

首先需引用COM，Microsoft Excel 12.0 Object Library
visual studio 会自动添加using Microsoft.Office.Interop.Excel;

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Office.Interop.Excel;

namespace Excel输出DLL
{
    public class ExcelOutput
    {
        public void ExcelTest()
        {
            //创建Excel应用程序
            ApplicationClass excalApp = new ApplicationClass();  
            Workbook wb = excalApp.Workbooks.Add(Type.Missing);
            Worksheet ws = (Worksheet)wb.ActiveSheet;
            ws.Name = "第一个测试";
            string item = "我是一个测试字";
            ws.Cells[1, 1] = (object)item;
            // 按格式保存工作簿
            //XlFileFormat是一个枚举，提供很多存储格式，其中xlExcel8是Excel97-2003格式，xlExcel12是Excel2007格式
            excalApp.ActiveWorkbook.SaveAs("f:\\test22", XlFileFormat.xlExcel8, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);  
            // 关闭Excel应用程序
            excalApp.Quit();

         }
    }
}