I need to convert .xlsx to .xls from command line, can it be done?

thanks.

hi qrange, what are you trying to do? .xlsx is an office 2007 to 2010 file name extension and .xls is office 2003 and other previous versions.

if you rename it the file might be unusable, why not open it on excel or open office and specify the file extension that you want.

conversion is not possible using command line only, you can rename the file using mv command but the file maybe corrupted.

nah, I need to parse it with perl.
I've found out there is a Spreadsheet::XLSX for that, so will try without pre-converting.

I am trying to edit the xlsx files using perl in linux.

Is the Spreadsheet::XLSX works with linux in PERL ? If you have already used please suggest me the syntaxes and let me know if any packages has to be installed to use this.

I have used like below and ended up with errors.

Code:
/************************************/
#!/usr/bin/perl

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

# Text::Iconv is not really required.
# This can be any object with the convert method. Or nothing.

use Spreadsheet::XLSX;

/************************************/
Error:
Can't locate Spreadsheet/XLSX.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at sample.pl line 10.


Thanks for your help.

i think error "Can't locate Spreadsheet/XLSX.pm"

means you haven't installed it properly. start CPAN and use 'install Spreadsheet::XLSX'
or use your package manager.

1 members found this post helpful.

Thank You. I will ask my admin to install the Spreadsheet::XLSX module. Mean-time I will work with xlsparser.