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

 HYPERLINK /yysyangyangyangshan/article/details/7067370 C#中数据库数据如何导出至Excel表格  有时候需要将数据库的数据导出至Excel表格表格，以便进行查看和分析，那么如何导出呢？下面用代码来实现。??? 首先，新建一个工程，需要添加引用Microsoft.Office.Interop.Excel.dll，以Oracle数据库为例（只要读出DataTable或DataSet就行了，哪种数据库没关系）。 1、创建一个表格，并插入如下数据。 [sql]  HYPERLINK /yysyangyangyangshan/article/details/7067370 \o view plain view plain HYPERLINK /yysyangyangyangshan/article/details/7067370 \o copy copy HYPERLINK /yysyangyangyangshan/article/details/7067370 \o print print HYPERLINK /yysyangyangyangshan/article/details/7067370 \o ? ? drop?table?TABLETESTEXCEL;?? create?table?TABLETESTEXCEL?? (?? ??col_id???NUMBER?not?null,?? ??col_name?VARCHAR2(32),?? ??col_age??NUMBER,?? ??col_sex??VARCHAR2(4),?? ??col_work?VARCHAR2(32),?? ??col_mony?FLOAT?? );?? drop table TABLETESTEXCEL; create table TABLETESTEXCEL ( col_id NUMBER not null, col_name VARCHAR2(32), col_age NUMBER, col_sex VARCHAR2(4), col_work VARCHAR2(32), col_mony FLOAT ); 数据： [sql]  HYPERLINK /yysyangyangyangshan/article/details/7067370 \o view plain view plain HYPERLINK /yysyangyangyangshan/article/details/7067370 \o copy copy HYPERLINK /yysyangyangyangshan/article/details/7067370 \o print print HYPERLINK /yysyangyangyangshan/article/details/7067370 \o ? ? insert?into?TABLETESTEXCEL?(col_id,?col_name,?col_age,?col_sex,?col_work,?col_mony)?? values?(1,?吴一,?25,?男,?.NET,?5000);?? ?? insert?into?TABLETESTEXCEL?(col_id,?col_name,?col_age,?col_sex,?col_work,?col_mony)?? values?(2,?孙二,?24,?男,?JAVA,?4999);?? ?? insert?into?TABLETESTEXCEL?(col_id,?col_name,?col_age,?col_sex,?col_work,?col_mony)?? values?(3,?张三,?25,?男,?PHP,?5001);?? ?? insert?into?TABLETESTEXCEL?(col_id,?col_name,?col_age,?col_sex,?col_work,?col_mony)?? values?(4,?李四,?26,?男,?DELPHI,?5002);?? ?? insert?into?TABLETESTEXCEL?(col_id,?col_name,?col_age,?col_sex,?col_work,?col_mony)?? values?(5,?王五,?27,?男,?C++,?5003);?? ?? insert?into?TABLETESTEXCEL?(col_id,?col_name,?col_age,?col_sex,?col_work,?col_mony)?? values?(6,