C# Excel操作问题

ExcelHelper excel = new ExcelHelper("E:\\test.xlsx"); //excel模板    protected void Page_Load(object sender, EventArgs e)
    {
        CreateExcel("e:\\btest.xlsx"); //最终生成的excel    }
    public void CreateExcel(string fileName)
    {
        object missing = Missing.Value;
        Application App = new Application();
        Workbooks books = App.Workbooks;
        Workbook book = books.Add(true);
        Sheets sheets = book.Sheets;
        Worksheet worksheet = excel.GetWorksheetByName("Sheet1"); //GetWorksheetByName返回模板的worksheet(确保其中有数据).
book.SaveAs(fileName, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
        book.Close(false, missing, missing);
        App.Quit();
        excel.Close();
    }

问题:最终生成的excel(btest.xlsx)文件是空的. --------------------编程问答-------------------- 参考
http://nonocast.cn/?p=2376 --------------------编程问答--------------------

引用 1 楼 nonocast 的回复:

参考
http://nonocast.cn/?p=2376

我要做的效果是
模板:
   A1     B1     C1     D1
1 name:
2 age:
3 gander:
  <Sheet1>
生成的结果是:
   A1     B1     C1     D1...
1 name:   peter
2 age:    22
3 gander: nan
  <Sheet1>
--------------------编程问答-------------------- 那就直接oledb就行了
http://nonocast.cn/?p=756

补充：.NET技术 ,  C#

C# Excel操作 问题

C# Excel操作问题