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
Yes - here is a perl module meant to read xls files:
- G�bor Szab� / Spreadsheet-ParseExcel - search.cpan.org
Can we do this same using korn script....??? any ideas
Thanks!
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
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!