LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   xls2csv -- how (https://www.linuxquestions.org/questions/linux-newbie-8/xls2csv-how-657893/)

chobo 07-24-2008 03:50 AM

xls2csv -- how
 
dear all

i need to cenvert *.xls files to csv but i tried

[root@devel ~]# xls2csv -x "myfiles.xls" -w "Timeline-full.xls" -c "users.csv"
xls2csv: invalid option -- w
Usage:
xls2csv [-xlV] [-g number] [-f date-format] [-b string] [-s charset] [-d charset] [-c char] [ -q number] files

and i have installed catdoc , xls2csv , and i think it run well
[root@devel ~]# xls2csv
Usage:
xls2csv [-xlV] [-g number] [-f date-format] [-b string] [-s charset] [-d charset] [-c char] [ -q number] files

BUT i still cant to convert it .

1. do xls2csv need modules below

Locale::Recode
Unicode::Map
Spreadsheet::ParseExcel
Spreadsheet::ParseExcel::FmtUnicode (should be included with Spreadsheet::ParseExcel)
Text::CSV_XS

2. how to cenvert *xls files using xls2csv tool

dont give me links below

http://search.cpan.org/~ken/xls2csv/...QUIRED_MODULES
http://www.topology.org/linux/xls.html#convert


thanks so much

XavierP 07-24-2008 04:25 AM

What is it that you think "-w" does? Clearly, from your error message, it's not an accepted switch for the program.

JimRobinson 07-24-2008 12:09 PM

John Mcnamera has a site in PerlOrg that works very well. I used this in the past.

chobo 07-25-2008 03:08 AM

not it that i mean
 
Quote:

Originally Posted by XavierP (Post 3224681)
What is it that you think "-w" does? Clearly, from your error message, it's not an accepted switch for the program.


yup .. it one of the error message but not it that i mean . ha ha ha

i have already get the solution it just need 4 modules mentioned above .

but i stiil cant to convert if the content file *xls are number ( not character ).

xls2csv said file is converted to *csv but the *csv converted no content.


any suggestions



thanks guys..

chobo 07-25-2008 03:11 AM

Quote:

Originally Posted by JimRobinson (Post 3225138)
John Mcnamera has a site in PerlOrg that works very well. I used this in the past.


would you mind to give me more than PerlOrg's word


thanks guys ..


All times are GMT -5. The time now is 02:14 AM.