C# 使用微软OFFICE库操作excel写入数据
using System;
using Excel = Microsoft.Office.Interop.Excel;namespace ExcelExample
{class Program{static void Main(string[] args){// 创建Excel应用程序实例Excel.Application excelApp = new Excel.Application();// 让Excel应用程序可见(可选)excelApp.Visible = true;// 添加一个新的工作簿Excel.Workbook workbook = excelApp.Workbooks.Add(Type.Missing);// 获取第一个工作表Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];// 选中A1单元格Excel.Range range = worksheet.Range["A1"];// 写入数据到单元格range.Value2 = "Hello, World!";// 保存工作簿(可选)// workbook.SaveAs(@"C:\path\to\your\excel.xlsx");// 关闭Excel应用程序(可选)// excelApp.Quit();// 释放对象,避免内存泄露(可选)System.Runtime.InteropServices.Marshal.ReleaseComObject(range);System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);Console.WriteLine("数据已写入Excel单元格");}}
}