C#操作Excel总结

enjoyfate

于 2020-06-09 22:54:13 发布

阅读量189

点赞数

分类专栏： c#

本文链接：https://blog.csdn.net/u014683488/article/details/106652654

版权

c# 专栏收录该内容

77 篇文章 2 订阅

订阅专栏

public void WriteSample()
{
    Excel.Application excelApp = new Excel.Application();
    if (excelApp != null)
    {
        Excel.Workbook excelWorkbook = excelApp.Workbooks.Add();
        Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelWorkbook.Sheets.Add();
 
        excelWorksheet.Cells[1, 1] = "Value1";
        excelWorksheet.Cells[2, 1] = "Value2";
        excelWorksheet.Cells[3, 1] = "Value3";
        excelWorksheet.Cells[4, 1] = "Value4";
 
        excelApp.ActiveWorkbook.SaveAs(@"C:\abc.xls", Excel.XlFileFormat.xlWorkbookNormal);
 
        excelWorkbook.Close();
        excelApp.Quit();
 
        System.Runtime.InteropServices.Marshal.FinalReleaseComObject(excelWorksheet);
        System.Runtime.InteropServices.Marshal.FinalReleaseComObject(excelWorkbook);
        System.Runtime.InteropServices.Marshal.FinalReleaseComObject(excelApp);
        GC.Collect();
        GC.WaitForPendingFinalizers();
    }
}

https://www.codeproject.com/Questions/141434/How-to-save-excel-files-using-c

http://csharpexamples.com/c-write-data-excel-file/

https://www.cnblogs.com/wang_yb/archive/2010/06/03/1750419.html

https://www.twblogs.net/a/5c4afa13bd9eee6e7d81d4cb