C#使用Microsoft.Office.Interop.Excel操作EXCEL

上传者: a915381965 | 上传时间: 2021-05-11 18:13:31 | 文件大小: 88.54MB | 文件类型: ZIP
C#使用Microsoft.Office.Interop.Excel操作EXCEL,读取EXCEL到内存中,处理完存到新的EXCEL中。程序逻辑是根据工程内“初始文件”文件夹编写的,所以请使用初始文件里的文件操作。处理完例子文件可能需十来分钟。当然,可以只看代码里面是怎么使用Microsoft.Office.Interop.Excel的。另,编码水平有限,慎下载。

文件下载

资源详情

[{"title":"( 82 个子文件 88.54MB ) C#使用Microsoft.Office.Interop.Excel操作EXCEL","children":[{"title":"ExcelProcess","children":[{"title":"ExcelProcess","children":[{"title":"旧的写死代码","children":[{"title":"ReadData.cs <span style='color:#111;'> 9.61KB </span>","children":null,"spread":false},{"title":"Format.cs <span style='color:#111;'> 462B </span>","children":null,"spread":false}],"spread":true},{"title":"Form1.Designer.cs <span style='color:#111;'> 7.35KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 493B </span>","children":null,"spread":false},{"title":"ExcelProcess.csproj <span style='color:#111;'> 4.74KB </span>","children":null,"spread":false},{"title":"新的代码","children":[{"title":"FormatNew.cs <span style='color:#111;'> 509B </span>","children":null,"spread":false},{"title":"ProcessDataNew.cs <span style='color:#111;'> 10.81KB </span>","children":null,"spread":false}],"spread":true},{"title":"packages.config <span style='color:#111;'> 166B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"ExcelProcess.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExcelProcess.csprojAssemblyReference.cache <span style='color:#111;'> 105.45KB </span>","children":null,"spread":false},{"title":"ExcelProcess.csproj.FileListAbsolute.txt <span style='color:#111;'> 4.79KB </span>","children":null,"spread":false},{"title":"ExcelProcess.csproj.GenerateResource.cache <span style='color:#111;'> 1012B </span>","children":null,"spread":false},{"title":"ExcelProcess.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExcelProcess.exe <span style='color:#111;'> 27.00KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 7.77KB </span>","children":null,"spread":false},{"title":"ExcelProcess.csproj.CoreCompileInputs.cache <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"excelprocess.exe.licenses <span style='color:#111;'> 436B </span>","children":null,"spread":false},{"title":"ExcelProcess.csproj.CopyComplete <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExcelProcess.pdb <span style='color:#111;'> 53.50KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 51.92KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"bin","children":[{"title":"Release","children":null,"spread":false},{"title":"Debug.zip <span style='color:#111;'> 6.77MB </span>","children":null,"spread":false},{"title":"Debug","children":[{"title":"de","children":[{"title":"DevExpress.Printing.v13.2.Core.resources.dll <span style='color:#111;'> 12.49KB </span>","children":null,"spread":false},{"title":"DevExpress.XtraEditors.v13.2.resources.dll <span style='color:#111;'> 55.99KB </span>","children":null,"spread":false},{"title":"DevExpress.Data.v13.2.resources.dll <span style='color:#111;'> 161.49KB </span>","children":null,"spread":false},{"title":"DevExpress.Utils.v13.2.resources.dll <span style='color:#111;'> 24.99KB </span>","children":null,"spread":false},{"title":"DevExpress.Sparkline.v13.2.Core.resources.dll <span style='color:#111;'> 10.99KB </span>","children":null,"spread":false}],"spread":true},{"title":"DevExpress.Data.v13.2.xml <span style='color:#111;'> 1010.15KB </span>","children":null,"spread":false},{"title":"DevExpress.Printing.v13.2.Core.dll <span style='color:#111;'> 2.33MB </span>","children":null,"spread":false},{"title":"ru","children":[{"title":"DevExpress.Printing.v13.2.Core.resources.dll <span style='color:#111;'> 13.49KB </span>","children":null,"spread":false},{"title":"DevExpress.XtraEditors.v13.2.resources.dll <span style='color:#111;'> 74.99KB </span>","children":null,"spread":false},{"title":"DevExpress.Data.v13.2.resources.dll <span style='color:#111;'> 180.99KB </span>","children":null,"spread":false},{"title":"DevExpress.Utils.v13.2.resources.dll <span style='color:#111;'> 27.99KB </span>","children":null,"spread":false},{"title":"DevExpress.Sparkline.v13.2.Core.resources.dll <span style='color:#111;'> 10.49KB </span>","children":null,"spread":false}],"spread":false},{"title":"ExcelProcess.exe <span style='color:#111;'> 27.00KB </span>","children":null,"spread":false},{"title":"DevExpress.Utils.v13.2.xml <span style='color:#111;'> 500.04KB </span>","children":null,"spread":false},{"title":"DevExpress.XtraEditors.v13.2.xml <span style='color:#111;'> 1.36MB </span>","children":null,"spread":false},{"title":"ExcelProcess.pdb <span style='color:#111;'> 53.50KB </span>","children":null,"spread":false},{"title":"DevExpress.Printing.v13.2.Core.xml <span style='color:#111;'> 845.25KB </span>","children":null,"spread":false},{"title":"DevExpress.XtraEditors.v13.2.dll <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"ja","children":[{"title":"DevExpress.Printing.v13.2.Core.resources.dll <span style='color:#111;'> 11.99KB </span>","children":null,"spread":false},{"title":"DevExpress.XtraEditors.v13.2.resources.dll <span style='color:#111;'> 78.49KB </span>","children":null,"spread":false},{"title":"DevExpress.Data.v13.2.resources.dll <span style='color:#111;'> 171.49KB </span>","children":null,"spread":false},{"title":"DevExpress.Utils.v13.2.resources.dll <span style='color:#111;'> 31.49KB </span>","children":null,"spread":false}],"spread":false},{"title":"DevExpress.Sparkline.v13.2.Core.xml <span style='color:#111;'> 20.40KB </span>","children":null,"spread":false},{"title":"es","children":[{"title":"DevExpress.Printing.v13.2.Core.resources.dll <span style='color:#111;'> 12.99KB </span>","children":null,"spread":false},{"title":"DevExpress.XtraEditors.v13.2.resources.dll <span style='color:#111;'> 67.99KB </span>","children":null,"spread":false},{"title":"DevExpress.Data.v13.2.resources.dll <span style='color:#111;'> 169.49KB </span>","children":null,"spread":false},{"title":"DevExpress.Utils.v13.2.resources.dll <span style='color:#111;'> 25.99KB </span>","children":null,"spread":false}],"spread":false},{"title":"DevExpress.Data.v13.2.dll <span style='color:#111;'> 3.09MB </span>","children":null,"spread":false},{"title":"DevExpress.Utils.v13.2.dll <span style='color:#111;'> 4.64MB </span>","children":null,"spread":false},{"title":"DevExpress.Sparkline.v13.2.Core.dll <span style='color:#111;'> 42.49KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"Form1.cs <span style='color:#111;'> 2.74KB </span>","children":null,"spread":false},{"title":"结果文件","children":[{"title":"7-21-C.xlsx <span style='color:#111;'> 645.32KB </span>","children":null,"spread":false},{"title":"Finally.xlsx <span style='color:#111;'> 15.11MB </span>","children":null,"spread":false},{"title":"Finally - 副本 (2).xlsx <span style='color:#111;'> 15.12MB </span>","children":null,"spread":false},{"title":"7-21-A.xlsx <span style='color:#111;'> 647.25KB </span>","children":null,"spread":false},{"title":"Finally - 副本.xlsx <span style='color:#111;'> 15.07MB </span>","children":null,"spread":false},{"title":"7-19-A.xlsx <span style='color:#111;'> 6.09MB </span>","children":null,"spread":false},{"title":"7-21-B.xlsx <span style='color:#111;'> 643.94KB </span>","children":null,"spread":false},{"title":"7-28-A.xlsx <span style='color:#111;'> 252.83KB </span>","children":null,"spread":false},{"title":"7-21-D.xlsx <span style='color:#111;'> 642.32KB </span>","children":null,"spread":false},{"title":"新建文件夹","children":null,"spread":false}],"spread":true},{"title":"Form1.resx <span style='color:#111;'> 5.68KB </span>","children":null,"spread":false},{"title":"初始文件","children":[{"title":"合市值+收益率+账面市值比-月度-2002-2015-2.xlsx <span style='color:#111;'> 1.00MB </span>","children":null,"spread":false},{"title":"合市值+收益率+账面市值比-月度-2002-2015-2.csv <span style='color:#111;'> 969.26KB </span>","children":null,"spread":false},{"title":"data.xlsx <span style='color:#111;'> 13.48MB </span>","children":null,"spread":false},{"title":"data.csv <span style='color:#111;'> 12.84MB </span>","children":null,"spread":false}],"spread":true},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.29KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"Resources.resx <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false},{"title":"licenses.licx <span style='color:#111;'> 255B </span>","children":null,"spread":false},{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.77KB </span>","children":null,"spread":false}],"spread":false},{"title":"ExcelProcess.csproj.user <span style='color:#111;'> 228B </span>","children":null,"spread":false}],"spread":false},{"title":".vs","children":[{"title":"ExcelProcess","children":[{"title":"v15","children":[{"title":".suo <span style='color:#111;'> 217.50KB </span>","children":null,"spread":false},{"title":"Server","children":[{"title":"sqlite3","children":[{"title":"storage.ide-wal <span style='color:#111;'> 3.94MB </span>","children":null,"spread":false},{"title":"storage.ide-shm <span style='color:#111;'> 32.00KB </span>","children":null,"spread":false},{"title":"storage.ide <span style='color:#111;'> 1.27MB </span>","children":null,"spread":false},{"title":"db.lock <span style='color:#111;'> 0B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"packages","children":[{"title":"Microsoft.Office.Interop.Excel.15.0.4795.1000","children":[{"title":"Microsoft.Office.Interop.Excel.15.0.4795.1000.nupkg <span style='color:#111;'> 438.88KB </span>","children":null,"spread":false},{"title":".signature.p7s <span style='color:#111;'> 9.25KB </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"net20","children":[{"title":"Microsoft.Office.Interop.Excel.dll <span style='color:#111;'> 1.56MB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"ExcelProcess.sln <span style='color:#111;'> 1.11KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • 四次元口袋 :
    不错的,很实用,值得参考学习
    2020-04-30

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明