5

perl module to convert xlsx format to xls format

view full story
linux-howto

http://www.unix.com – 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 ..... (HowTos)

Shoutmeloud's picture
Submitted by Shoutmeloud on 08/04/2012 – Made popular on 08/04/2012

Stories similar to perl module to convert xlsx format to xls format

I am trying to convert xlsx sheet to a csv file. In .xlsx file there a cell with date

Code: Mon 08/27/12 while reading this cell using Spreadsheet::XLSX, the output is display with numeric value i.e., 41148.

from Spreadsheet::XLSX module :

Code: use Text::Iconv;  my $converter = Text::Iconv -> new ("utf-8", "windows-1251");    # Text::Iconv

I have an Excel 2007 excel sheet on windows machine and using Spreadsheet::XLSX I had written a script to read the excel sheet and was successful.

My requirement is I need to generate another excel sheet from the old excel 2007 sheet on unix machine.

Now is it possible to read the excel 2007 sheet on unix machine using Spreadsheet::XLSX module.

Experts, Could you please share your views on

Is there any perl module to convert .xlsx file(excel sheet 2007) to a csv file.

perl modules installation 34 weeks 3 hours ago

I have installed perl in windows.

Now I would like to install spreadsheet::xlsx & DateTime::Format::Excel modules(also few more) at a time instead of installing them seperately.

Could you please let me know how to install more than 1 module as a batch file in windows OS ?

Thanks in advance...

Regards, GS

Hi guys,

My SAMBA File server is running fine but i noticed that when i open a file with an extension of .xlsx and .docx, it says that "Read only",, but no one is opening that file except me.. most of the post are outdated and not in Ubuntu Distro so im doubting to try...

regards..

The Document Foundation has announced that the final version for LibreOffice 3.6.6 is now available for the Linux platform, bringing a lot of bug fixes and improvements.

The new LibreOffice 3.6.6 has arrived just a week later after another stable, and more advanced version, 4.0.2, was released.

Highlights of LibreOffice 3.6.6:

• Shapes are no longer missing when importing xlsx file format;

I have a situation where I am using the command prompt to run a perl script.

The perl script is in a batch file and is executed by an action command.

So I was wondering how would you differentiate ppt, xls and doc files from each other in linux regardless of extensions. I tried 'file' but from the looks of it, all of MSOffice files are categorized under the same file type.

So I was wondering how would you differentiate ppt, xls and doc files from each other in linux regardless of extensions. I tried 'file' but from the looks of it, all of MSOffice files are categorized under the same file type. Similarly I'm having trouble with docx, xlsx and pptx files, since they're essentially all zip files containing a bunch of xml.

Thank you for your help! P.S.