Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does ExcelWriter read existing spreadsheets?

April 26, 2017excelwriter existing read Spreadsheets

0

Posted

Does ExcelWriter read existing spreadsheets?

1 Answer

0

Posted

Yes. To read data from an existing spreadsheet, use the method GetDataFromExcelSheet, or open the file using ExcelApplication.Open. • Can ExcelWriter modify an existing spreadsheet? Yes. See Modifying an Existing Spreadsheet. • Can I generate a chart using ExcelWriter? Yes. Use the method Charts.Add to generate a chart. ExcelWriter can generate 15 chart types and over 70 sub-types (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/2002/2003 (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/2002/2003) format only; ExcelTemplate does not support BIFF7 (Excel 95) format templates, and will not generate BIFF7 format files. • Which Microsoft Excel features are not available in ExcelWriter? We are constantly ad