首页 C# 采用OleDB读取EXCEL文件并导出

C# 采用OleDB读取EXCEL文件并导出

上传者： power_wyh | 上传时间： 2021-06-23 22:18:28 | 文件大小： 4.79MB | 文件类型： RAR
C#
功能描述： 1、选择当前路径下的所有xls文件（xls文件必须是统一格式）； 2、选取Excel中某个sheet中的某几列读入到Dataset里面； 3、从Dataset导出到Excel表格 注：此代码运行是需有office组建作为支持，即运行该程序的电脑上必须安装office软件；程序由VS2012开发。

文件下载

资源详情

[{"title":"（ 90 个子文件 4.79MB ） C# 采用OleDB读取EXCEL文件并导出","children":[{"title":"ExportExcel","children":[{"title":"ExportExcel","children":[{"title":"Form2.resx <span style='color:#111;'> 5.68KB </span>","children":null,"spread":false},{"title":"Form1.cs <span style='color:#111;'> 11.59KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 523B </span>","children":null,"spread":false},{"title":"ExportExcel.csproj <span style='color:#111;'> 5.79KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.68KB </span>","children":null,"spread":false},{"title":"Form2.Designer.cs <span style='color:#111;'> 2.03KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.81KB </span>","children":null,"spread":false},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.32KB </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}],"spread":true},{"title":"AppLibrary.cs <span style='color:#111;'> 3B </span>","children":null,"spread":false},{"title":"Form1.Designer.cs <span style='color:#111;'> 3.08KB </span>","children":null,"spread":false},{"title":"App.config <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"Debug","children":[{"title":"ExportExcel.csproj.GenerateResource.Cache <span style='color:#111;'> 975B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExportExcel.csprojResolveAssemblyReference.cache <span style='color:#111;'> 2.09KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 7.40KB </span>","children":null,"spread":false},{"title":"ExportExcel.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"Interop.AppComlib.dll <span style='color:#111;'> 4.50KB </span>","children":null,"spread":false},{"title":"Interop.WebLib.dll <span style='color:#111;'> 4.00KB </span>","children":null,"spread":false},{"title":"ExportExcel.csproj.ResolveComReference.cache <span style='color:#111;'> 1.00KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 1.25KB </span>","children":null,"spread":false},{"title":"ExportExcel.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"ExportExcel.exe <span style='color:#111;'> 13.50KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"ExportExcel.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExportExcel.pdb <span style='color:#111;'> 27.50KB </span>","children":null,"spread":false}],"spread":false},{"title":"Release","children":[{"title":"ExportExcel.csproj.GenerateResource.Cache <span style='color:#111;'> 1.01KB </span>","children":null,"spread":false},{"title":"ExportExcel.Form2.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TempPE","children":null,"spread":false},{"title":"ExportExcel.csprojResolveAssemblyReference.cache <span style='color:#111;'> 2.09KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 7.40KB </span>","children":null,"spread":false},{"title":"ExportExcel.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.51KB </span>","children":null,"spread":false},{"title":"Interop.AppComlib.dll <span style='color:#111;'> 4.50KB </span>","children":null,"spread":false},{"title":"Interop.WebLib.dll <span style='color:#111;'> 4.00KB </span>","children":null,"spread":false},{"title":"ExportExcel.csproj.ResolveComReference.cache <span style='color:#111;'> 1.00KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 1.25KB </span>","children":null,"spread":false},{"title":"ExportExcel.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"ExportExcel.exe <span style='color:#111;'> 14.00KB </span>","children":null,"spread":false},{"title":"TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"ExportExcel.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"ExportExcel.pdb <span style='color:#111;'> 31.50KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"bin","children":[{"title":"Debug","children":[{"title":"ExportExcel.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"ExportExcel.vshost.exe.config <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"ExportExcel.exe.config <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"ExportExcel.vshost.exe <span style='color:#111;'> 22.45KB </span>","children":null,"spread":false},{"title":"ExportExcel.exe <span style='color:#111;'> 13.50KB </span>","children":null,"spread":false},{"title":"ExportExcel.pdb <span style='color:#111;'> 27.50KB </span>","children":null,"spread":false}],"spread":false},{"title":"Release","children":[{"title":"P83M3.xls <span style='color:#111;'> 1.97MB </span>","children":null,"spread":false},{"title":"P20M5.xls <span style='color:#111;'> 1.22MB </span>","children":null,"spread":false},{"title":"P44M3.xls <span style='color:#111;'> 360.50KB </span>","children":null,"spread":false},{"title":"P26M5.xls <span style='color:#111;'> 1.51MB </span>","children":null,"spread":false},{"title":"P41M4.xls <span style='color:#111;'> 416.50KB </span>","children":null,"spread":false},{"title":"ExportExcel.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"P17M3.xls <span style='color:#111;'> 1.28MB </span>","children":null,"spread":false},{"title":"P36M3.xls <span style='color:#111;'> 1.71MB </span>","children":null,"spread":false},{"title":"111.xls <span style='color:#111;'> 407.47KB </span>","children":null,"spread":false},{"title":"P23M5.xls <span style='color:#111;'> 2.82MB </span>","children":null,"spread":false},{"title":"P5M5.xls <span style='color:#111;'> 1.20MB </span>","children":null,"spread":false},{"title":"P26M3.xls <span style='color:#111;'> 1.31MB </span>","children":null,"spread":false},{"title":"P5M3.xls <span style='color:#111;'> 1.21MB </span>","children":null,"spread":false},{"title":"P81M3.xls <span style='color:#111;'> 1.79MB </span>","children":null,"spread":false},{"title":"P14M3.xls <span style='color:#111;'> 1.54MB </span>","children":null,"spread":false},{"title":"P46M3.xls <span style='color:#111;'> 364.00KB </span>","children":null,"spread":false},{"title":"ExportExcel.vshost.exe.config <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"ExportExcel.exe.config <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"ExportExcel.vshost.exe <span style='color:#111;'> 22.45KB </span>","children":null,"spread":false},{"title":"P29M3.xls <span style='color:#111;'> 1.44MB </span>","children":null,"spread":false},{"title":"P11M5.xls <span style='color:#111;'> 1.21MB </span>","children":null,"spread":false},{"title":"P29M5.xls <span style='color:#111;'> 1.28MB </span>","children":null,"spread":false},{"title":"P17M5.xls <span style='color:#111;'> 1.29MB </span>","children":null,"spread":false},{"title":"P32M3.xls <span style='color:#111;'> 1.15MB </span>","children":null,"spread":false},{"title":"P32M5.xls <span style='color:#111;'> 1.13MB </span>","children":null,"spread":false},{"title":"P8M5.xls <span style='color:#111;'> 1.20MB </span>","children":null,"spread":false},{"title":"P2M3.xls <span style='color:#111;'> 852.50KB </span>","children":null,"spread":false},{"title":"P44M5.xls <span style='color:#111;'> 360.50KB </span>","children":null,"spread":false},{"title":"P20M3.xls <span style='color:#111;'> 1.29MB </span>","children":null,"spread":false},{"title":"ExportExcel.exe <span style='color:#111;'> 14.00KB </span>","children":null,"spread":false},{"title":"P41M2.xls <span style='color:#111;'> 966.50KB </span>","children":null,"spread":false},{"title":"ExportExcel.pdb <span style='color:#111;'> 31.50KB </span>","children":null,"spread":false},{"title":"P23M3.xls <span style='color:#111;'> 1.56MB </span>","children":null,"spread":false},{"title":"P8M3.xls <span style='color:#111;'> 1.21MB </span>","children":null,"spread":false},{"title":"P14M5.xls <span style='color:#111;'> 994.50KB </span>","children":null,"spread":false},{"title":"P11M3.xls <span style='color:#111;'> 1.21MB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"Form2.cs <span style='color:#111;'> 476B </span>","children":null,"spread":false}],"spread":false},{"title":"ExportExcel.sln <span style='color:#111;'> 923B </span>","children":null,"spread":false},{"title":"ExportExcel.v11.suo <span style='color:#111;'> 41.00KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • woniu199166 :
    垃圾 不能用
    2021-11-29

其他资源

免责申明

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

个人信息

下载历史

热门下载

最新下载