C#导出Excel源码和c#中openfiledialog的使用
3星 · 超过75%的资源 需积分: 49 151 浏览量
2012-06-20
09:43:23
上传
评论
收藏 27KB DOCX 举报 
1. namespaceExportToExcel
2. {
3. usingSystem;
4. usingSystem.Data;
5. usingSystem.Data.SqlClient;
6. usingSystem.Windows.Forms;
7. usingSystem.Runtime.InteropServices;
8.
9.
10. publicclassExcelManager:IDisposable
11. {
12. Excel.Rangem_objRange=null;
13. Excel.Applicationm_objExcel=null;
14. Excel.Workbooksm_objBooks=null;
15. Excel._Workbookm_objBook=null;
16. Excel.Sheetsm_objSheets=null;
17. Excel._Worksheetm_objSheet=null;
18. Excel.QueryTablem_objQryTable=null;
19. objectm_objOpt=System.Reflection.Missing.Value;
20. //DataBase-usedvariable
21. privateSystem.Data.SqlClient.SqlConnectionsqlConn=null;
22. privatestringstrConnect=string.Empty;
23. privateSystem.Data.SqlClient.SqlCommandsqlCmd=null;
24.
25. //Sheetsvariable
26. privatedoubledbSheetSize=65535;//thehightlimitnumber
inonesheet
27. privateintintSheetTotalSize=0;//totalrecordcandivied
sheetnumber
28. privatedoubledbTotalSize=0;//recordtotalnumber
29.
30.
31. ///<summary>
32. ///建构函数
33. ///</summary>
34. publicExcelManager(){}
35.
36. ///<summary>
37. ///建构函数
38. ///</summary>
39. ///<paramname="dbHL">一个 Excel 表格的最大记录数</param>
40. ///<paramname="dbTotal">该数据库表共查询出多少条记录</param>
剩余10页未读，继续阅读
资源评论
qq936825192013-08-15写的很完善，自己稍加修改即可
bing_luo_182012-11-01运行出错，运行不了
