C#利用XML创建Excel文档的实现方法

这篇文章主要介绍了C#利用XML创建Excel文档的实现方法,需要的朋友可以参考下

一般来说C#在不安装Excel软件的情况下，可以通过XML来创建Excel文档。因此，运行本文所述代码您无需安装Excel程序。本文原例子是使用VB.Net写的，以下的用C#改写的代码，分享给大家，供大家参考。

具体代码如下：

 DataSet mDSData = new DataSet(); mDSData.Tables.Add("myTable"); mDSData.Tables["myTable"].Columns.Add("ID"); mDSData.Tables["myTable"].Columns.Add("Name"); mDSData.Tables["myTable"].Columns.Add("PassWord"); for (int i = 0; i <10; i++) { DataRow dr = mDSData.Tables["myTable"].NewRow(); dr["ID"] = i; dr["Name"] = i; dr["PassWord"] = i; mDSData.Tables["myTable"].Rows.Add(dr); } SaveFileDialog dialog1 = new SaveFileDialog(); dialog1.AddExtension = true; dialog1.CheckPathExists = true; dialog1.Filter = "Excel Workbooks (*.xls) | *.xls"; dialog1.OverwritePrompt = true; dialog1.Title = "Save Excel Formatted Report"; if (dialog1.ShowDialog() == DialogResult.OK) { int num2 = 0; int num3 = mDSData.Tables[0].Rows.Count + 1; int num1 = mDSData.Tables[0].Columns.Count; num2 = 0; string text1 = dialog1.FileName; if (File.Exists(text1)) { File.Delete(text1); } StreamWriter writer1 = new StreamWriter(text1, false); StreamWriter writer2 = writer1; writer2.WriteLine(""); writer2.WriteLine(""); writer2.WriteLine(""); writer2.WriteLine(" "); writer2.WriteLine(" Automated Report Generator Example"); writer2.WriteLine(string.Format(" {0}T{1}Z", DateTime.Now.ToString("yyyy-mm-dd"), DateTime.Now.ToString("HH:MM:SS"))); writer2.WriteLine(" Your Company Here"); writer2.WriteLine(" 11.6408"); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" 8955"); writer2.WriteLine(" 11355"); writer2.WriteLine(" 480"); writer2.WriteLine(" 15"); writer2.WriteLine(" False"); writer2.WriteLine(" False"); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(string.Format(" "); foreach (DataRow row1 in mDSData.Tables[0].Rows) { writer2.WriteLine(""); for (num2 = 0; num2 != num1; num2++) { writer2.Write(""); writer2.Write(row1[num2].ToString()); writer2.WriteLine(""); } writer2.WriteLine(""); } writer2.WriteLine(" 
"); writer2.WriteLine(" "); writer2.WriteLine("  "); writer2.WriteLine("  "); writer2.WriteLine("  "); writer2.WriteLine("   3"); writer2.WriteLine("   1"); writer2.WriteLine("  "); writer2.WriteLine("  "); writer2.WriteLine("  False"); writer2.WriteLine("  False"); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine("  False"); writer2.WriteLine("  False"); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine("  False"); writer2.WriteLine("  False"); writer2.WriteLine(" "); writer2.WriteLine(" "); writer2.WriteLine(""); writer2 = null; writer1.Close(); MessageBox.Show("Report Created", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); }