Aspose,如何用一个模板来导出到Excel
http://www.cnblogs.com/MyFlora/archive/2012/04/13/2445285.html
The process of adding worksheets to a designer spreadsheet is entirely same as that of the above approach except that the Excel file is already created and we need to open that Excel file first before adding worksheet to it. A designer spreadsheet can be opened by the Workbook class.
Example:
[C#]
//Creating a file stream containing the Excel file to be opened FileStream fstream = new FileStream("C:\\book1.xls", FileMode.Open); //Instantiating a Workbook object //Opening the Excel file through the file stream Workbook workbook = new Workbook(fstream); //Adding a new worksheet to the Workbook object int i = workbook.Worksheets.Add(); //Obtaining the reference of the newly added worksheet by passing its sheet index Worksheet worksheet = workbook.Worksheets[i]; //Setting the name of the newly added worksheet worksheet.Name = "My Worksheet"; //Saving the Excel file workbook.Save(saveFileDialog1.FileName); //Closing the file stream to free all resources fstream.Close();