LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-24-2008, 03:50 AM   #1
chobo
LQ Newbie
 
Registered: Nov 2007
Posts: 21

Rep: Reputation: 15
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
 
Old 07-24-2008, 04:25 AM   #2
XavierP
Moderator
 
Registered: Nov 2002
Location: Kent, England
Distribution: Debian Testing
Posts: 19,192
Blog Entries: 4

Rep: Reputation: 470Reputation: 470Reputation: 470Reputation: 470Reputation: 470
What is it that you think "-w" does? Clearly, from your error message, it's not an accepted switch for the program.
 
Old 07-24-2008, 12:09 PM   #3
JimRobinson
LQ Newbie
 
Registered: Jul 2008
Posts: 5
Blog Entries: 1

Rep: Reputation: 0
John Mcnamera has a site in PerlOrg that works very well. I used this in the past.
 
Old 07-25-2008, 03:08 AM   #4
chobo
LQ Newbie
 
Registered: Nov 2007
Posts: 21

Original Poster
Rep: Reputation: 15
Thumbs up not it that i mean

Quote:
Originally Posted by XavierP View Post
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..
 
Old 07-25-2008, 03:11 AM   #5
chobo
LQ Newbie
 
Registered: Nov 2007
Posts: 21

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by JimRobinson View Post
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 ..
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
xls2csv delimiter waelaltaqi Linux - Newbie 7 08-05-2017 10:48 PM
Got "Cannot load target charset koi8-r" with xls2csv on on Linux RHEL 5 zebela Linux - Newbie 1 07-08-2008 10:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:36 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration