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

HYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"C#中数据库数据如何导出至Excel表格
有时候需要将数据库的数据导出至Excel表格表格，以便进行查看和分析，那么如何导出呢？下面用代码来实现。首先，新建一个工程，需要添加引用Microsoft.Office.Interop.Excel.dll，以Oracle数据库为例（只要读出DataTable或DataSet就行了，哪种数据库没关系）。
1、创建一个表格，并插入如下数据。
[sql]HYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"viewplain"viewplainHYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"copy"copyHYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"print"printHYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"?"?
droptableTABLETESTEXCEL;
createtableTABLETESTEXCEL
(
col_idNUMBERnotnull,
col_nameVARCHAR2(32),
col_ageNUMBER,
col_sexVARCHAR2(4),
col_workVARCHAR2(32),
col_monyFLOAT
);
droptableTABLETESTEXCEL;
createtableTABLETESTEXCEL
(
col_idNUMBERnotnull,
col_nameVARCHAR2(32),
col_ageNUMBER,
col_sexVARCHAR2(4),
col_workVARCHAR2(32),
col_monyFLOAT
);
数据：
[sql]HYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"viewplain"viewplainHYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"copy"copyHYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"print"printHYPERLINK"http://blog.csdn.net/yysyangyangyangshan/article/details/7067370"\o"?"?
insertintoTABLETESTEXCEL(col_id,col_name,col_age,col_sex,col_work,col_mony)
values(1,'吴一',25,'男','.NET',5000);

insertintoTABLETESTEXCEL(col_id,col_name,col_age,col_sex,col_work,col_mony)
values(2,'孙二',24,'男','JAVA',4999);

insertintoTABLETESTEXCEL(col_id,col_name,col_age,col_sex,col_work,col_mony)
values(3,'张三',25,'男','PHP',5001);

insertintoTABLETESTEXCEL(col_id,col_name,col_age,col_sex,col_work,col_mony)
values(4,'李四',26,'男','DELPHI',5002);

insertintoTABLETESTEXCEL(col_id,col_name,col_age,col_sex,col_work,col_mony)
values(5,'王五',27,'男','C++',5003);

insertintoTABLETESTEXCEL(col_id,col_name,col_age,col_sex,col_work,col_mony)
values(