winform操作excel.zip资源-CSDN文库

共47个文件

cs：11个

resources：9个

cache：5个

winform

excel

4星 · 超过85%的资源需积分: 50 154 浏览量 2019-06-17 10:07:53 上传评论 3 收藏 1.95MB ZIP 举报

在本文中，我们将深入探讨如何使用C#和WinForm来操作Excel文件，将Excel视为一个简单的数据库进行增、删、改、查的操作。WinForm是.NET Framework中的一个用户界面库，而C#是一种广泛用于开发Windows应用程序的强大编程语言。Excel由于其易用性和灵活性，常被用作临时或小型数据库，尤其是在数据处理和报告生成方面。要操作Excel，我们需要引用Microsoft.Office.Interop.Excel库。这是.NET Framework提供的一个接口，允许我们通过C#与Excel应用程序交互。在你的项目中，右键点击“引用”>“添加引用”>“COM”，然后选择“Microsoft Excel XX.0 Object Library”（XX代表你的Excel版本号）。一旦引用添加成功，你可以创建一个Excel应用实例，打开Excel文件，以及操作工作簿和工作表： ```csharp using Excel = Microsoft.Office.Interop.Excel; // 创建Excel应用实例 Excel.Application excelApp = new Excel.Application(); excelApp.Visible = true; // 设置为可见 // 打开Excel文件 Workbook workbook = excelApp.Workbooks.Open("path_to_your_excel_file.xlsx"); // 选择工作表 Worksheet worksheet = workbook.Worksheets[1]; ``` 对于“增”，即添加新数据，可以使用`Range`对象来定位单元格并输入值： ```csharp // 定位到要插入数据的行和列 Range cell = worksheet.Cells[rowIndex, columnIndex]; // 写入数据 cell.Value2 = "Your data"; ``` “删”，删除数据，可能涉及到清除单元格内容或者删除整行/整列： ```csharp // 清除单元格 cell.ClearContents(); // 删除整行 worksheet.Rows[rowIndex].Delete(); ``` “改”，修改现有数据，同样定位到目标单元格并设置新的值： ```csharp // 修改已有数据 cell.Value2 = "Updated data"; ``` “查”，查询数据，可以通过循环遍历单元格或使用Excel的查找函数实现。例如，遍历特定列查找值： ```csharp for (int i = 1; i <= worksheet.UsedRange.Rows.Count; i++) { if (worksheet.Cells[i, columnIndex].Value2 == "Search value") { Console.WriteLine("Found at row " + i); } } ``` 在实际开发中，为了提高性能和避免内存泄漏，使用完Excel对象后应正确释放它们： ```csharp // 保存更改并关闭工作簿 workbook.Save(); workbook.Close(false); // 关闭Excel应用 excelApp.Quit(); // 释放对象 System.Runtime.InteropServices.Marshal.ReleaseComObject(cell); System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet); System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); ``` 在WinForm中，你可以创建各种控件如文本框、按钮等，让用户输入数据并触发上述操作。例如，使用按钮的Click事件来执行增、删、改、查操作，并在操作完成后更新UI展示结果。 C#和WinForm结合使用可以方便地实现对Excel文件的交互，提供一个用户友好的界面来进行数据管理。这种方法适用于小规模的数据操作，但如果涉及大量数据或复杂查询，建议使用真正的数据库系统，如SQL Server或SQLite，它们能提供更好的性能和稳定性。

展开

资源推荐

资源详情

资源评论

收起资源包目录

winform操作excel.zip （47个子文件）

WindowsFormsApplication3

.vs

WindowsFormsApplication1

v15

.suo 97KB

Server

sqlite3

storage.ide 668KB

v16

.suo 98KB

Server

sqlite3

storage.ide 564KB

db.lock 0B

WindowsFormsApplication1

ExcelFile

MainFm.Designer.cs 7KB

ExcelHelper.cs 5KB

frmAddStu.cs 834B

Resources

IMG_2546.GIF 390KB

Program.cs 506B

WindowsFormsApplication1.csproj 4KB

Properties

Settings.settings 249B

Resources.Designer.cs 3KB

AssemblyInfo.cs 1KB

Settings.Designer.cs 1KB

Resources.resx 6KB

frmAddStu.resx 6KB

MainFm.resx 6KB

frmUpdateStu.resx 6KB

frmUpdateStu.cs 2KB

MainFm.cs 3KB

frmAddStu.Designer.cs 7KB

frmUpdateStu.Designer.cs 7KB

obj

x86

Debug

WindowsFormsApplication1.frmAddStu.resources 180B

WindowsFormsApplication1.csproj.FileListAbsolute.txt 8KB

TempPE

Properties.Resources.Designer.cs.dll 5KB

WindowsFormsApplication1.csprojResolveAssemblyReference.cache 9KB

WindowsFormsApplication1.Form6.resources 180B

WindowsFormsApplication1.csproj.GenerateResource.cache 1KB

WindowsFormsApplication1.csproj.CoreCompileInputs.cache 42B

DesignTimeResolveAssemblyReferencesInput.cache 7KB

WindowsFormsApplication1.frmMaintance.resources 180B

WindowsFormsApplication1.Form2.resources 180B

WindowsFormsApplication1.exe 410KB

DesignTimeResolveAssemblyReferences.cache 2KB

WindowsFormsApplication1.pdb 40KB

WindowsFormsApplication1.Form1.resources 180B

WindowsFormsApplication1.MainFm.resources 180B

WindowsFormsApplication1.frmOutput.resources 180B

WindowsFormsApplication1.Properties.Resources.resources 390KB

WindowsFormsApplication1.frmUpdateStu.resources 180B

bin

Debug

ExcelFile

ExcelDB.xlsx 9KB

WindowsFormsApplication1.exe 410KB

WindowsFormsApplication1.pdb 40KB

WindowsFormsApplication1.vshost.exe 11KB

Release

WindowsFormsApplication1.sln 914B

WindowsFormsApplication1.suo 41KB

F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.pdb F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form1.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Properties.Resources.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.GenerateResource.Cache F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.exe F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.pdb F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csprojResolveAssemblyReference.cache F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form2.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form3.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmMaintance.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmOutput.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form6.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmAddStu.resources F:\课程材料\面向对象程序设计\test\WindowsFormsApplication1\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmUpdateStu.resources E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.pdb E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csprojResolveAssemblyReference.cache E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form3.resources E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form6.resources E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmAddStu.resources E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Properties.Resources.resources E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmUpdateStu.resources E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.GenerateResource.Cache E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.CoreCompileInputs.cache E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.exe E:\KeHu\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.pdb E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.pdb E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csprojResolveAssemblyReference.cache E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form3.resources E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form6.resources E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmAddStu.resources E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Properties.Resources.resources E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmUpdateStu.resources E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.GenerateResource.Cache E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.CoreCompileInputs.cache E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.exe E:\KeHu\C#\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.pdb F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.pdb F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Form6.resources F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmAddStu.resources F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Properties.Resources.resources F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmUpdateStu.resources F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.GenerateResource.cache F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.CoreCompileInputs.cache F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.exe F:\KeHu\C#\C#\CS\WindowsFormsApplication3\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.pdb D:\DevTool\2019New\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.MainFm.resources D:\DevTool\2019New\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmAddStu.resources D:\DevTool\2019New\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.Properties.Resources.resources D:\DevTool\2019New\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.frmUpdateStu.resources D:\DevTool\2019New\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.GenerateResource.cache D:\DevTool\2019New\WindowsFormsApplication3\WindowsFormsApplication1\obj\x86\Debug\WindowsFormsApplication1.csproj.CoreCompileInputs.cache D:\DevTo

评论收藏

内容反馈