摘要:C#：Create Excel File
1 
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\temp\\test.xls;Extended Properties='Excel 8.0;HDR=Yes'"))
2{
3
conn.Open();
4 OleDbCommand cmd = new OleDbCommand("CREATE TABLE [Sheet1] ([Column1] string, [Column2] string)", conn);
5 cmd.ExecuteNonQuery();
6}
7
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\temp\\test.xls;Extended Properties='Excel 8.0;HDR=Yes'"))
using 2
{3
conn.Open();4
OleDbCommand cmd = new OleDbCommand("CREATE TABLE [Sheet1] ([Column1] string, [Column2] string)", conn);5
cmd.ExecuteNonQuery();6
}7
參考來源：
stackoverflow.com/questions/151005/create-excel-xls-and-xlsx-file-from-c#151048
