Shell Programming and Scripting

Hi Folks,

I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx.

I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly.

Is there any module to convert the .xlsx files to .xls file instead of chaning the functionality in my program ? Its not just to change the extension but after converting I should be in the position to read the .xlsx file programaticlly .

Any assistance on this will be highly appreciated .....

Thanks in advance ........

---------- Post updated at 09:17 PM ---------- Previous update was at 07:51 AM ----------

Is there any perl module to convert the .xlsx files to .xls file instead of chaning the functionality in my program ? Its not just to change the extension but after converting I should be in the position to read the .xlsx file programaticlly .

Any assistance on this will be highly appreciated .....

Thanks in advance ........

Here's a suggestion - Since you've already gone through Spreadsheet::XLSX; as you read each cell, write them to an xls file using Spreadsheet::WriteExcel module. So, read each cell from .xlsx file using Spreadsheet::XLSX and write to .xls file using Spreadsheet::WriteExcel module. Remember, unlike .xlsx files, .xls have a limit on the number of rows (65536). If that be the case, you may want to split a single .xlsx files to different worksheets while writing to an .xls file.

You could actually stitch together the sample codes provided in CPAN for aforementioned modules, with minor adjustments of course.