Is there any perl module to convert .xlsx file(excel sheet 2007) to a csv file.
I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module.
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
Experts, Could you please share your views on
I am trying to convert xlsx sheet to a csv file.
In .xlsx file there a cell with date
while reading this cell using Spreadsheet::XLSX, the output is display with numeric value i.e., 41148.
from Spreadsheet::XLSX module :
my $converter = Text::Iconv -> new ("utf-8", "windows-1251");
I am trying one perl script to convert xlsx to xls file but could not able to get all the rows and columns in the xls file . This scriptFILE is basically to convert XLSX to CSV ..
At the command line I'm converting csv files to xlsx files using:
soffice --headless --convert-to xlsx:"Calc MS Excel 2007 XML" thefile.csv
That works great. What I'd like to get a column in the spreadsheet in date format.
Is it possible?
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...
I need to convert the following formula to one that uses SUM(IF), as I am given a #value error when the external data source is closed.
Is this an appropriate place to ask? Would appreciate some help.
Since you guys really helped me with my last issue:
I have this 300+ txt files (containing character-delimited data) that i would like to convert to xlsx. The manual way would include opening the file with LibraOffice, and save it as xlsx.
However, i feel there must be a batch mode?!
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.