C#中DataTable导出XLS

        private void DataTableToExcel( DataTable table , string file )
        {
            string title = "";
           
            using ( FileStream  fs = new FileStream(file,FileMode.OpenOrCreate))
            {
                using ( BufferedStream bs = new BufferedStream( fs ) )
                {
                    using ( StreamWriter sw = new StreamWriter(bs,Encoding.Default) )
                    {
                        for ( int i = 0 ; i < table.Columns.Count ; i++ )
                        {
                            title += table.Columns[ i ].ColumnName + "\t";
                        }
                        //形成表格第一行的文本内容（每个字段的名称）
                        title = title.Substring( 0 , title.Length - 1 ) + "\n";
                        sw.WriteLine( title );

                        foreach ( DataRow row in table.Rows )
                        {
                            string line = "";
                            for ( int i = 0 ; i < table.Columns.Count ; i++ )
                            {
                                line += row[ i ].ToString( ) + "\t";
                            }
                            line += "\n";
                            sw.WriteLine( line );
                        }
                        sw.Close( );
                        fs.Close( );
                    }
                }
            }
        }

 

        //导出到Excel
        private void button1_Click( object sender , EventArgs e )
        {
            string filePath = @"c:\employee.xls";
            string sql = "select * from employee";
            DataTable dt = DBHelper.Query( sql , null , false );
            this.DataTableToExcel( dt , filePath );
            MessageBox.Show( "导出成功！" );
        }