Can ExcelWriter use template spreadsheets?
Yes. See Using Template Spreadsheets. Note: An ExcelWriter template is a file created in Microsoft Excel that contains data markers and can be opened with the ExcelTemplate object. In the ExcelWriter documentation, the term “template” refers to an ExcelWriter template, not a Microsoft Excel template (.xlt). However, ExcelWriter can open and generate both .xls and .xlt files. Use an .xlt file the same way you would an .xls file. • Can I generate a chart using ExcelWriter? Yes. Use the method Charts.Add to generate a chart. ExcelWriter offers over forty chart styles (see Chart Codes). ExcelWriter’s numerous charting properties allow you to customize every detail of your chart. • What versions of Microsoft Excel does ExcelWriter support? ExcelWriter can produce either Excel 97/2000/XP (BIFF8) format files or Excel 95 (BIFF7) format files. Not all features are supported by Excel 95. Note: The ExcelTemplate object supports Excel’s BIFF8 (Excel 97/2000/XP) format only; ExcelTemplate does not