Backend Development
C#.Net Tutorial
Detailed explanation of the method summary of opening Excel documents in C# winform
Detailed explanation of the method summary of opening Excel documents in C# winform
下面小编就为大家带来一篇C# winform打开Excel文档的方法总结(必看篇)。小编觉得挺不错的，现在就分享给大家，也给大家做个参考。一起跟随小编过来看看吧
C#打开Excel文档方法一：调用Excel的COM组件
在项目中打开Add Reference对话框，选择COM栏，之后在COM列表中找到"Microsoft Excel 11.0 Object Library"（Office 2003），然后将其加入到项目的References中即可。Visual C#.NET会自动产生相应的.NET组件文件，以后即可正常使用。
按钮的点击事件如下：
privatevoid button1_Click(object sender, EventArgs e)
{
Excel.Application excel =
new Excel.Application(); //引用Excel对象
Excel.Workbook book =
excel.Application.Workbooks.Add("c:\\test.xls");
//引用Excel工作簿
excel.Visible = true; //使Excel可视
}C#打开Excel文档方法二：利用命令行
我们在开始→运行里输入c:\\test.xls，后如果电脑安装有Excel的话他也会自动的打开这个文件，代码如下：
privatevoid button1_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.Start("c:\\test.xls");
}C#打开Excel文档的具体方法的介绍就向你介绍到这里，希望对你了解和学习C#打开Excel文档有所帮助。
我的一点看法：
private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Workbook wkb = app.Workbooks.Add(@"E:\Work\DemoBase_091111\CSharpOpenExcel\cshapropenexcel.xlsx");
//打开已经存在的excel,
//而通过gdal打开已经存在的shp,方法为
// OSGeo.GDAL.Gdal.AllRegister();
// OSGeo.GDAL.Dataset dataSet = OSGeo.GDAL.Gdal.Open(@"E:\Work\DemoBase_091111\GDALTEST\testshapefile\point_out.shp", Access.GA_ReadOnly);
//二者是差不多的，一个用add方法，一个用open方法，都得到了可以进行下一步操作的文件，技术具有相同性
app.Visible = true;
}The above is the detailed content of Detailed explanation of the method summary of opening Excel documents in C# winform. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1664
14
1423
52
1318
25
1269
29
1248
24
Active Directory with C#
Sep 03, 2024 pm 03:33 PM
Guide to Active Directory with C#. Here we discuss the introduction and how Active Directory works in C# along with the syntax and example.
Random Number Generator in C#
Sep 03, 2024 pm 03:34 PM
Guide to Random Number Generator in C#. Here we discuss how Random Number Generator work, concept of pseudo-random and secure numbers.
C# Data Grid View
Sep 03, 2024 pm 03:32 PM
Guide to C# Data Grid View. Here we discuss the examples of how a data grid view can be loaded and exported from the SQL database or an excel file.
Factorial in C#
Sep 03, 2024 pm 03:34 PM
Guide to Factorial in C#. Here we discuss the introduction to factorial in c# along with different examples and code implementation.
The difference between multithreading and asynchronous c#
Apr 03, 2025 pm 02:57 PM
The difference between multithreading and asynchronous is that multithreading executes multiple threads at the same time, while asynchronously performs operations without blocking the current thread. Multithreading is used for compute-intensive tasks, while asynchronously is used for user interaction. The advantage of multi-threading is to improve computing performance, while the advantage of asynchronous is to not block UI threads. Choosing multithreading or asynchronous depends on the nature of the task: Computation-intensive tasks use multithreading, tasks that interact with external resources and need to keep UI responsiveness use asynchronous.
Patterns in C#
Sep 03, 2024 pm 03:33 PM
Guide to Patterns in C#. Here we discuss the introduction and top 3 types of Patterns in C# along with its examples and code implementation.
Prime Numbers in C#
Sep 03, 2024 pm 03:35 PM
Guide to Prime Numbers in C#. Here we discuss the introduction and examples of prime numbers in c# along with code implementation.
C# vs. C : History, Evolution, and Future Prospects
Apr 19, 2025 am 12:07 AM
The history and evolution of C# and C are unique, and the future prospects are also different. 1.C was invented by BjarneStroustrup in 1983 to introduce object-oriented programming into the C language. Its evolution process includes multiple standardizations, such as C 11 introducing auto keywords and lambda expressions, C 20 introducing concepts and coroutines, and will focus on performance and system-level programming in the future. 2.C# was released by Microsoft in 2000. Combining the advantages of C and Java, its evolution focuses on simplicity and productivity. For example, C#2.0 introduced generics and C#5.0 introduced asynchronous programming, which will focus on developers' productivity and cloud computing in the future.
