一般来说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(" ");
writer2.WriteLine(" ");
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);
}
这只是主要的代码，使用前需要此入using相应的命名空间，如果不知道需要哪个命名空间，可在编译时根据提示逐个添加。