如何在C＃windows应用程序中编写和更新普通的Excel文件 [英] How to write and update a normal excel file in C# windows application

问题描述

我希望在打开excel文件后对其进行更改。



我尝试了什么：

 private void openToolStripMenuItem_Click（object sender，EventArgs e）
 {
 string mySheet = @F：\Year 2019 \Daily Record \ StoreRecord.xlsx; 
 var ExcelApp = new ExcelApp.Application（）; 
 ExcelApp.Visible = true; 
 ExcelApp.Workbooks books = ExcelApp.Workbooks; 
 ExcelApp.Workbook sheet = books.Open（mySheet）; 
} 
 

解决方案

看一下 EPPlus 库： GitHub - JanKallman / EPPlus：使用.NET创建高级Excel电子表格 [ ^ ]

选中此项：如何从Microsoft Visual C＃.NET自动化Microsoft Excel [ ^

I want make changes to excel file after opening it.

What I have tried:

private void openToolStripMenuItem_Click(object sender, EventArgs e)
       {
           string mySheet = @"F:\Year 2019\Daily Record\StoreRecord.xlsx";
           var ExcelApp = new ExcelApp.Application();
           ExcelApp.Visible = true;
           ExcelApp.Workbooks books = ExcelApp.Workbooks;
           ExcelApp.Workbook sheet = books.Open(mySheet);
       }

解决方案

Take a look at the EPPlus library: GitHub - JanKallman/EPPlus: Create advanced Excel spreadsheets using .NET[^]

Check this: How to automate Microsoft Excel from Microsoft Visual C#.NET[^]

这篇关于如何在C＃windows应用程序中编写和更新普通的Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！