ASP.NET將DataSet匯出Excel

  public class ExcelExporter        {            private DataSet _dataSet = null;            /// <summary>            /// 要匯出的DataSet            /// </summary>            public DataSet DataSet            {                get { return _dataSet; }            }            /// <summary>            /// 構造一個ExcelExporter            /// </summary>            public ExcelExporter()            {                _dataSet = new DataSet();            }            /// <summary>            /// 構造一個ExcelExporter            /// </summary>            /// <param name="dataSet">要匯出的DataSet</param>            public ExcelExporter(DataSet dataSet)            {                _dataSet = dataSet;            }            /// <summary>            /// 產生Excel檔案            /// </summary>            /// <param name="fileName">檔案名稱</param>            public void Export(string fileName)            {                if (fileName == null)                {                    throw new NullReferenceException("fileName");                }                string excelXML = CreateExcelXML(_dataSet);                StreamWriter streamWriter = new StreamWriter(fileName, false, Encoding.Unicode);                streamWriter.Write(excelXML.ToString());                streamWriter.Close();            }            /// <summary>            /// 產生Excel檔案            /// </summary>            /// <param name="stream">流</param>            public void Export(Stream stream)            {                if (stream == null)                {                    throw new NullReferenceException("stream");                }                string excelXML = CreateExcelXML(_dataSet);                StreamWriter streamWriter = new StreamWriter(stream, Encoding.Unicode);                streamWriter.Write(excelXML.ToString());                streamWriter.Close();            }            private string CreateExcelXML(DataSet dataSet)            {                if (dataSet == null)                {                    throw new NullReferenceException("dataSet");                }                if (dataSet.Tables.Count == 0)                {                    throw new InvalidOperationException("DataSet中至少要包含一個DataTable。");                }                StringBuilder excelXML = new StringBuilder();                // XML頭                excelXML.AppendLine("<?xml version=\"1.0\"?>");                // 活頁簿                excelXML.AppendLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:html=\"http://www.w3.org/TR/REC-html40\">");                // 工作表                foreach (DataTable dataTable in dataSet.Tables)                {                    excelXML.Append("\t");                    excelXML.AppendLine("<Worksheet ss:Name=\"" + TextToXML(dataTable.TableName) + "\">");                    excelXML.Append("\t\t");                    excelXML.AppendLine("<Table>");                    // 表頭                    excelXML.Append("\t\t\t");                    excelXML.AppendLine("<Row>");                    foreach (DataColumn dataColumn in dataTable.Columns)                    {                        excelXML.Append("\t\t\t\t");                        excelXML.AppendLine("<Cell>");                        excelXML.Append("\t\t\t\t\t");                        excelXML.AppendLine("<Data ss:Type=\"String\">" + TextToXML(dataColumn.ColumnName) + "</Data>");                        excelXML.Append("\t\t\t\t");                        excelXML.AppendLine("</Cell>");                    }                    excelXML.Append("\t\t\t");                    excelXML.AppendLine("</Row>");                    // 表體                    foreach (DataRow dataRow in dataTable.Rows)                    {                        excelXML.Append("\t\t\t");                        excelXML.AppendLine("<Row>");                        // 儲存格                        foreach (DataColumn dataColumn in dataTable.Columns)                        {                            excelXML.Append("\t\t\t\t");                            excelXML.AppendLine("<Cell>");                            excelXML.Append("\t\t\t\t\t");                            excelXML.AppendLine("<Data ss:Type=\"String\">" + TextToXML(dataRow[dataColumn].ToString()) + "</Data>");                            excelXML.Append("\t\t\t\t");                            excelXML.AppendLine("</Cell>");                        }                        excelXML.Append("\t\t\t");                        excelXML.AppendLine("</Row>");                    }                    excelXML.Append("\t\t");                    excelXML.AppendLine("</Table>");                    excelXML.Append("\t");                    excelXML.AppendLine("</Worksheet>");                }                excelXML.Append("</Workbook>");                return excelXML.ToString();            }            private string TextToXML(string value)            {                value = value.Replace("&", "&");                value = value.Replace("\"", """);                value = value.Replace("<", "<");                value = value.Replace(">", ">");                return value;            }        }  protected void btnDC_Click(object sender, EventArgs e)        {            DataSet ds = BLL.ExamResult.SelectExamResult();            new ExcelExporter(ds).Export(@"C:\Users\Administrator\Desktop\mly.xls");        }