用c#实现把数据库表内容导出来生成“.xls”文件
用c#实现把数据库表内容导出来生成“.xls”文件
------解决方案--------------------
http://www.cnblogs.com/top5/archive/2010/02/16/1668801.html
------解决方案--------------------
用Aspose导出
------解决方案--------------------
也可以试试 NPOI.DLL
------解决方案--------------------
http://www.2cto.com/kf/201205/131076.html
------解决方案--------------------

private void btnExcel_Click(object sender, EventArgs e)

        {

            DataTable dt = new DataTable();

            dt = DBHelper.GetData("SELECT * FROM TBNAME");//此处获取你数据库中数据

            if (dt.Rows.Count > 0)

            {

                SaveFileDialog sd = new SaveFileDialog();

                sd.Filter = "(*.xls)
------解决方案--------------------
*.xls";

                sd.FilterIndex = 0;

                sd.FileName = "filename.xls";

                sd.RestoreDirectory = true;

                sd.Title = "导出Excel";

                if (sd.ShowDialog() == DialogResult.OK)

                {

                    Stream sm;

                    sm = sd.OpenFile();

                    StreamWriter sw = new StreamWriter(sm, System.Text.Encoding.GetEncoding(-0));

                    string columnTitle = "";

                    try

                    {

                        for (int i = 0; i < dt.Columns.Count; i++)

                        {

                            if (i > 0)