c#使用StreamWriter將DataTable儲存到Excel

廢話不多說，貼代碼：

public static void Export2Excel(DataTable dtTemp, string fileName, bool append = false, Encoding encoding = null)
        {
            if (encoding == null)
            {
                encoding = Encoding.Default;
            }
            using (var writer = new StreamWriter(fileName, append, encoding))
            {
                foreach (DataColumn dc in dtTemp.Columns)
                {
                    writer.Write(dc.ToString());
                    writer.Write('\t');
                }
                writer.Write("\r\n");
                var values = new object[dtTemp.Columns.Count];
                foreach (DataRow drTemp in dtTemp.Rows)
                {
                    values = drTemp.ItemArray;
                    foreach (var t in values)
                    {
                        writer.Write(t.ToString());
                        writer.Write('\t');
                    }
                    writer.Write("\r\n");
                }
                writer.Write("\r\n");
                writer.Close();
            }
        }
注意就是fileName需要使用xls副檔名，無它。這個方法的限制就是只能產生一個Tab的Excel檔案。