C# 操作 Excel 表 和 Access数据库 的范例(用 VS2010 写的)

上传者: tuobaxiao2008 | 上传时间: 2021-06-17 15:48:34 | 文件大小: 2MB | 文件类型: ZIP
此资源是用 VS2010 (C#)写的。 具体是:用 C# 操作 Excel 表 和 Access数据库,含批量导出、批量导入、批量合并excel、批量打印等功能,范例代码,绝对基础。 共 6 个基础的范例(绝对基础的代码): ① 一键合并多个Excel表; ② 把excel表快速插入access数据库(整个表插入,而不是一行一行插入,速度超快); ③ Datatable 快速导出 规范的 excel表; ④ 纯代码生成一个不规则的 excel表(合并列、字体加颜色等); ⑤ 复制模版,嵌入数据,批量生成新的 excel表; ⑥ 批量打印文件(点一下按钮,自动打印)。

文件下载

资源详情

[{"title":"( 74 个子文件 2MB ) C# 操作 Excel 表 和 Access数据库 的范例(用 VS2010 写的)","children":[{"title":"C Sharp 操作 Excel 表范例","children":[{"title":"C Sharp 操作 Excel 表范例.sln <span style='color:#111;'> 932B </span>","children":null,"spread":false},{"title":"C Sharp 操作 Excel 表范例.suo <span style='color:#111;'> 20.50KB </span>","children":null,"spread":false},{"title":"C Sharp 操作 Excel 表范例","children":[{"title":"DbHelperSQL.cs <span style='color:#111;'> 13.11KB </span>","children":null,"spread":false},{"title":"我的类.cs <span style='color:#111;'> 40.39KB </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"Release","children":null,"spread":false},{"title":"Debug","children":[{"title":"C Sharp 操作 Excel 表范例.vshost.exe <span style='color:#111;'> 11.34KB </span>","children":null,"spread":false},{"title":"C Sharp 操作 Excel 表范例.exe <span style='color:#111;'> 34.00KB </span>","children":null,"spread":false},{"title":"照片","children":[{"title":"070501012.jpg <span style='color:#111;'> 7.81KB </span>","children":null,"spread":false},{"title":"070501013.jpg <span style='color:#111;'> 7.99KB </span>","children":null,"spread":false},{"title":"070501028.jpg <span style='color:#111;'> 7.73KB </span>","children":null,"spread":false},{"title":"070501034.jpg <span style='color:#111;'> 7.75KB </span>","children":null,"spread":false},{"title":"070501035.jpg <span style='color:#111;'> 7.92KB </span>","children":null,"spread":false},{"title":"070501040.jpg <span style='color:#111;'> 8.27KB </span>","children":null,"spread":false},{"title":"070501004.jpg <span style='color:#111;'> 7.52KB </span>","children":null,"spread":false},{"title":"070501039.jpg <span style='color:#111;'> 8.52KB </span>","children":null,"spread":false},{"title":"070501008.jpg <span style='color:#111;'> 7.00KB </span>","children":null,"spread":false},{"title":"070501002.jpg <span style='color:#111;'> 7.33KB </span>","children":null,"spread":false},{"title":"070501005.jpg <span style='color:#111;'> 7.68KB </span>","children":null,"spread":false},{"title":"070501017.jpg <span style='color:#111;'> 7.64KB </span>","children":null,"spread":false},{"title":"070501015.jpg <span style='color:#111;'> 7.30KB </span>","children":null,"spread":false},{"title":"070501037.jpg <span style='color:#111;'> 8.25KB </span>","children":null,"spread":false},{"title":"070501031.jpg <span style='color:#111;'> 8.62KB </span>","children":null,"spread":false},{"title":"070501010.jpg <span style='color:#111;'> 7.55KB </span>","children":null,"spread":false},{"title":"070501036.jpg <span style='color:#111;'> 8.18KB </span>","children":null,"spread":false},{"title":"070501026.jpg <span style='color:#111;'> 7.70KB </span>","children":null,"spread":false},{"title":"070501025.jpg <span style='color:#111;'> 8.18KB </span>","children":null,"spread":false},{"title":"070501003.jpg <span style='color:#111;'> 7.42KB </span>","children":null,"spread":false},{"title":"070501033.jpg <span style='color:#111;'> 7.85KB </span>","children":null,"spread":false},{"title":"070501014.jpg <span style='color:#111;'> 8.06KB </span>","children":null,"spread":false},{"title":"070501009.jpg <span style='color:#111;'> 8.04KB </span>","children":null,"spread":false},{"title":"070501016.jpg <span style='color:#111;'> 7.50KB </span>","children":null,"spread":false},{"title":"070501001.jpg <span style='color:#111;'> 7.70KB </span>","children":null,"spread":false},{"title":"070501019.jpg <span style='color:#111;'> 7.21KB </span>","children":null,"spread":false},{"title":"070501029.jpg <span style='color:#111;'> 8.49KB </span>","children":null,"spread":false},{"title":"070501020.jpg <span style='color:#111;'> 7.78KB </span>","children":null,"spread":false},{"title":"070501023.jpg <span style='color:#111;'> 8.09KB </span>","children":null,"spread":false},{"title":"070501038.jpg <span style='color:#111;'> 7.91KB </span>","children":null,"spread":false},{"title":"070501007.jpg <span style='color:#111;'> 8.07KB </span>","children":null,"spread":false},{"title":"070501022.jpg <span style='color:#111;'> 7.70KB </span>","children":null,"spread":false},{"title":"070501030.jpg <span style='color:#111;'> 7.73KB </span>","children":null,"spread":false},{"title":"070501027.jpg <span style='color:#111;'> 7.70KB </span>","children":null,"spread":false},{"title":"070501011.jpg <span style='color:#111;'> 7.82KB </span>","children":null,"spread":false},{"title":"070501032.jpg <span style='color:#111;'> 8.68KB </span>","children":null,"spread":false},{"title":"070501018.jpg <span style='color:#111;'> 7.51KB </span>","children":null,"spread":false},{"title":"070501006.jpg <span style='color:#111;'> 7.79KB </span>","children":null,"spread":false},{"title":"070501024.jpg <span style='color:#111;'> 8.08KB </span>","children":null,"spread":false},{"title":"070501021.jpg <span style='color:#111;'> 7.93KB </span>","children":null,"spread":false}],"spread":false},{"title":"C Sharp 操作 Excel 表范例.pdb <span style='color:#111;'> 65.50KB </span>","children":null,"spread":false},{"title":"请把准备合并的Excel表放此文件夹","children":[{"title":"表格1.xls <span style='color:#111;'> 19.00KB </span>","children":null,"spread":false},{"title":"表格2.xls <span style='color:#111;'> 19.00KB </span>","children":null,"spread":false},{"title":"表格3.xls <span style='color:#111;'> 19.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"Aspose.Cells","children":[{"title":"Aspose.Cells.dll <span style='color:#111;'> 4.12MB </span>","children":null,"spread":false},{"title":"License.lic <span style='color:#111;'> 426B </span>","children":null,"spread":false}],"spread":true},{"title":"DataBase","children":[{"title":"DataBase.mdb <span style='color:#111;'> 348.00KB </span>","children":null,"spread":false},{"title":"模版.xls <span style='color:#111;'> 18.50KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":"Form1.Designer.cs <span style='color:#111;'> 9.98KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 491B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"x86","children":[{"title":"Debug","children":[{"title":"C Sharp 操作 Excel 表范例.exe <span style='color:#111;'> 34.00KB </span>","children":null,"spread":false},{"title":"GenerateResource-ResGen.write.1.tlog <span style='color:#111;'> 910B </span>","children":null,"spread":false},{"title":"C Sharp 操作 Excel 表范例.pdb <span style='color:#111;'> 65.50KB </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 5.64KB </span>","children":null,"spread":false},{"title":"ResolveAssemblyReference.cache <span style='color:#111;'> 6.61KB </span>","children":null,"spread":false},{"title":"TempPE","children":[{"title":"Properties.Resources.Designer.cs.dll <span style='color:#111;'> 4.50KB </span>","children":null,"spread":false}],"spread":false},{"title":"GenerateResource-ResGen.read.1.tlog <span style='color:#111;'> 758B </span>","children":null,"spread":false},{"title":"C_Sharp_操作_Excel_表范例.Properties.Resources.resources <span style='color:#111;'> 638B </span>","children":null,"spread":false},{"title":"C Sharp 操作 Excel 表范例.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.35KB </span>","children":null,"spread":false},{"title":"C_Sharp_操作_Excel_表范例.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"Form1.cs <span style='color:#111;'> 8.05KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 5.68KB </span>","children":null,"spread":false},{"title":"C Sharp 操作 Excel 表范例.csproj <span style='color:#111;'> 3.71KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"Resources.resx <span style='color:#111;'> 6.05KB </span>","children":null,"spread":false},{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.09KB </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 3.05KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}]

评论信息

  • wxfsnow :
    正是我需要的资源,感谢分享。
    2018-04-25
  • baidu_36538285 :
    很实用的工具
    2017-12-29
  • u010971368 :
    OK,有参考价值
    2017-11-16
  • yuerlove :
    还可以。但我没用上。谢谢
    2017-03-07
  • wishfish76 :
    可以使用,有效的代码
    2017-02-11

免责申明

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