资源描述:
《c#中数据库数据如何导出至excel表格》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、C#中数据库数据如何导出至Excel表格有时候需要将数据库的数据导出至Excel表格表格,以便进行查看和分析,那么如何导出呢?下面用代码来实现。 首先,新建一个工程,需要添加引用Microsoft.Office.Interop.Excel.dll,以Oracle数据库为例(只要读出DataTable或DataSet就行了,哪种数据库没关系)。1、创建一个表格,并插入如下数据。[sql]viewplaincopyprint?1.drop table TABLETESTEXCEL; 2.create table TA
2、BLETESTEXCEL 3.( 4. col_id NUMBER not null, 5. col_name VARCHAR2(32), 6. col_age NUMBER, 7. col_sex VARCHAR2(4), 8. col_work VARCHAR2(32), 9. col_mony FLOAT 10.); droptableTABLETESTEXCEL;createtableTABLETESTEXCEL(col_idNUMBERnotnull,col_nameVA
3、RCHAR2(32),col_ageNUMBER,col_sexVARCHAR2(4),col_workVARCHAR2(32),col_monyFLOAT);数据:[sql]viewplaincopyprint?1.insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 2.values (1, '吴一', 25, '男', '.NET', 5000); 3. 4.insert into TABLET
4、ESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 5.values (2, '孙二', 24, '男', 'JAVA', 4999); 6. 7.insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 8.values (3, '张三', 25, '男', 'PHP', 5001); 1. 2.insert into
5、 TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 3.values (4, '李四', 26, '男', 'DELPHI', 5002); 4. 5.insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 6.values (5, '王五', 27, '男', 'C++', 5003); 7. 8.in
6、sert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 9.values (6, '赵六', 25, '男', 'C', 4008); 10. 11.insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 12.values (7, '燕七', 25, '男', '数据库', 4007); 1
7、3. 14.insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 15.values (8, '胡八', 25, '男', 'JSP', 5005); 16. 17.insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 18.values (9, '钱九', 25, '男', 'ASP
8、.NET', 4005); 19. 20.insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 21.values (10, '沈十', 25, '男', 'VB', 4000); 22.commit; in