Shell convert xls to csv


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell convert xls to csv
# 1  
Old 09-11-2008
Shell convert xls to csv

Hi does anybody know how to convert xls to csv undex linux.
I need only data (that is log from test, dont need any macro and so on) from xls.
Any idea how to do that? Perl? shell? Could you give me any example?

Thanks in advance for answer.

Gracjan
# 2  
Old 09-11-2008
Yes - here is a perl module meant to read xls files:
גאבור סבו - Gábor Szabó / Spreadsheet-ParseExcel - search.cpan.org
# 3  
Old 01-09-2009
Can we do this same using korn script....??? any ideas

Thanks!
# 4  
Old 01-09-2009
If the Excel spreadsheet is exported as a CSV file, you certainly could use ksh to parse the file. Otherwise I recommend that you use either Perl, Python or Ruby to do the conversion.

Python has the SourceForge.net: pyExcelerator package
Ruby has the roo gem
# 5  
Old 01-09-2009
Right now i am using a macro to comver .xls file into .csv file. This is done manually and stored on windows server. An unix script users this generated .csv file by FTPing it to Unix server. Now i want to automate this whole process... I want the unix script to convert .xls file into .cvs file. or i can also do this way--- i am not sure it right-- i want to call this conversion VBA macro uisng unix script that will convert and get the .cvs file ready before the unix script that uses .cvs file starts... is this possible if so how...

the .xls file is on remote windows server and the generated .cvs file is also on windows server. which is futher ftp to unix box...

Any suggestions... please help

Thanks!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl script to Convert XLSX or XLS files to CSV file

Hi All, I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file. I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box. Perl code should have 2 params while running. i.e perl... (1 Reply)
Discussion started by: manab86
1 Replies

2. UNIX for Advanced & Expert Users

Mail csv as xls in shell

Hello, I have one csv file(";" separated). I would like to mail it as an attachment in xls format. I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";". unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid... (3 Replies)
Discussion started by: skhichi
3 Replies

3. Shell Programming and Scripting

Mail csv to xls in Shell Script

Hello, I have one csv file(";" separated). I would like to mail it as an attachment in xls format. I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";". unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid... (1 Reply)
Discussion started by: skhichi
1 Replies

4. Shell Programming and Scripting

How to convert a xls file to csv?

Hi, My requirement is to convert the xls to csv file with utf-8 conversion. Is there any way please suggest me. Thanks, Raja (4 Replies)
Discussion started by: cnraja
4 Replies

5. UNIX and Linux Applications

Tool for Convert XLS into CSV in UNIX

Hi I wanted to convert some XLS files into CSV format in my UNIX box. Unix box is handling very important data which are related to data warehouse.It is fully optimized by installing minimum packages since server need more resources to handle reports generating. Just for convert XLS files... (6 Replies)
Discussion started by: luke_devon
6 Replies

6. AIX

How to convert csv file to xls file

Hi All, I have a java program running in AIX machine which gives me the output in form of .CSV but my clients wants output in the form of .xls When I gave the command mv <filename.csv> <filename.xls> The contents of this .xls file is not exactly in seprate columns as in CSV, the contents... (1 Reply)
Discussion started by: chetu777
1 Replies

7. Shell Programming and Scripting

how to convert .xls to .csv

Hi, I have problem..How to convert .xls file to .csv.. Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies

8. Shell Programming and Scripting

how to convert XLS to CSV and DOC/RTF to TXT

Hi, i don't know anything about PERL. Can anyone help me providing PERL scripts for 1. converting XLS to CSV (and vice-versa) 2. converting DOC/RTF to TXT Thanks much Prvn (1 Reply)
Discussion started by: prvnrk
1 Replies

9. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies

10. Shell Programming and Scripting

Convert a csv file to an xls format

Hi, I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this? I'm struggling on this. Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies
Login or Register to Ask a Question

Featured Tech Videos