如何在C#windows应用程序中编写和更新普通的Excel文件 [英] How to write and update a normal excel file in C# windows application
本文介绍了如何在C#windows应用程序中编写和更新普通的Excel文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我希望在打开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屋!
查看全文