c# winform DataSet 導出 Excel

public void Export(DataSet ds, string path)

        {

            try

            {

                string data = "";

                foreach (DataTable tb in ds.Tables)

                {

                    foreach (DataColumn column in tb.Columns)

                    {

                        data += column.ColumnName + "\t";

                    }

                    data += "\n";

                    foreach (DataRow row in tb.Rows)

                        foreach (DataColumn column in tb.Columns)

                        {

                            data += row[column].ToString() + "\t";

                        }

                        data += "\n";

                }

                FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write, FileShare.Write);

                byte[] b = Encoding.Default.GetBytes(data);

                fs.Write(b, 0, b.Length);

                fs.Flush();

                fs.Close();

                fs.Dispose();

            }

            catch

            { }

        }

本文轉自94cool部落格園部落格，原文連結：http://www.cnblogs.com/94cool/archive/2011/03/11/1980460.html，如需轉載請自行聯系原作者