把数据写成xml,可以使用DataTable.WriteXml()
那么写成EXCEL呢？没有DataTable.WriteExcel()方法呢。
------解决方案--------------------
想法是的，可惜没有WriteExcel方法。你可以使用StreamWriter来导出。比如：
- C# code
using System.IO;public void ExportExcel2(DataTable dt, string fileName) { string FileName = fileName; FileStream objFileStream; StreamWriter objStreamWriter; string strLine = ""; objFileStream = new FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write); objStreamWriter = new StreamWriter(objFileStream, System.Text.Encoding.Unicode); for (int i = 0; i < dt.Columns.Count; i++) { strLine = strLine + dt.Columns[i].ColumnName.ToString() + Convert.ToChar(9); } objStreamWriter.WriteLine(strLine); strLine = ""; for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { strLine = strLine + dt.Rows[i][j].ToString() + Convert.ToChar(9); } objStreamWriter.WriteLine(strLine); strLine = ""; } objStreamWriter.Close(); objFileStream.Close(); }
------解决方案--------------------
学习学习