C#中数据库数据如何导出至Excel表格.docx

文档介绍：C# 中数据库数据如何导出至 Excel 表格有时候需要将数据库的数据导出至 Excel 表格表格,以便进行查看和分析,那么如何导出呢?下面用代码来实现。首先,新建一个工程,需要添加引用 ,以 Oracle 数据库为例(只要读出 DataTable 或 DataSet 就行了,哪种数据库没关系)。 1 、创建一个表格,并插入如下数据。[sql] view plain copy print ? 1. drop table TABLETESTEXCEL; 2. create table TABLETESTEXCEL 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. ); 数据: [sql] view plain copy print ? 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 TABLETESTEXCEL (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); 9. 10. insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 11. values (4, '李四', 26, '男', 'DELPHI' , 5002); 12. 13. insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 14. values (5, '王五', 27, '男', 'C++' , 5003); 15. 16. insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 17. values (6, '赵六', 25, '男', 'C' , 4008); 18. 19. insert into TABLETESTEXCEL (col_id, col_name, col_age, col_sex, col_work, col_mony) 20. values (7, '