Create an xls from a xlt
Ok I have a excel template file which contains various headers, images etc.
I need to populate a number of excel files based on this template file using Microsoft.Office.Interop.Excel
I have seen plenty of examples online how to create and modify existing excel files (both xlt and xls) however none show how to create the xls from an xlt.
The only way I can see round the problem is to open the xlt, populate the data on the workbook then save the file as an xls....
Is this the only way that this can be done?
开发者_如何学JAVAThanks
Instead of using xlt and xls files you can create a standard xlsx file and use unique tokens for the content you want to replace. Then you can create a new xlsx file based on your "template".
Open XML SDK 2.0 for Microsoft Office
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&displaylang=en
精彩评论