in reply to How Do I Write an Excel Spreadsheet using Spreadsheet::XLSX

As others have pointed out, the documentation for Spreadsheet::XLSX clearly states that it's for reading only. I believe that you'll need to use Spreadsheet::XLSX to read in the spreadsheet and then use Excel::Writer::XLSX to write back to a file.

Also, the "WRITING_EXCEL_FILES" section of Excel::Writer::XLSX's documentation lists some other alternatives "methods of getting data into Excel".

  • Comment on Re: How Do I Write an Excel Spreadsheet using Spreadsheet::XLSX

Replies are listed 'Best First'.
Re^2: How Do I Write an Excel Spreadsheet using Spreadsheet::XLSX
by trickyq (Acolyte) on Jun 05, 2012 at 16:25 UTC

    misunderstood and see the error in my ways

    I will look at and read the documentation for the modules you have pointed me to.

    Thank you

[reply]

In Section Seekers of Perl Wisdom