Re: convert Microsoft Excel xls To CSV
gnumeric in batch mode? (DISCLAIMER: I did not actually try it for this purpose or read its man file.) On Tue, 2006-07-04 at 16:16 +0300, yahav Biran wrote: It's nightmare to process an xls file. An external system is generating it and I need to process it. Is there any way to convert Microsoft Excel xls To CSV using a shell script. Is there any linux util that can help? thanks -- You haven't made an impact on the world before you caused a Debian release to be named after Snufkin. My own blog is at http://tddpirate.livejournal.com/ My opinions, as expressed in this E-mail message, are mine alone. They do not represent the official policy of any organization with which I may be affiliated in any way. WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
Re: convert Microsoft Excel xls To CSV
On 7/4/06, yahav Biran [EMAIL PROTECTED] wrote: It's nightmare to process an xls file. An external system is generating it and I need to process it. Is there any way to convert Microsoft Excel xls To CSV using a shell script. Is there any linux util that can help? I don't know about shell scripts but if you have Perl on the system you can have very simple interface to both read and write Excel files. See these modules http://search.cpan.org/dist/Spreadsheet-ParseExcel-Simple/ http://search.cpan.org/dist/Spreadsheet-ParseExcel/ Gabor = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
Re: convert Microsoft Excel xls To CSV
Load into Open Office. Save as CSV. You may have to split the xls file into separate sheets to make this work. Cheers. yahav Biran wrote: It's nightmare to process an xls file. An external system is generating it and I need to process it. Is there any way to convert Microsoft Excel xls To CSV using a shell script. Is there any linux util that can help? thanks = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED] begin:vcard fn:Daniel Feiglin n:Feiglin;Daniel email;internet:[EMAIL PROTECTED] tel;work:972 9 8616204 tel;fax:972 9 8621052 tel;cell:927 52 3869986 version:2.1 end:vcard
Re: convert Microsoft Excel xls To CSV
On Tue, 04 Jul 2006 16:16:06 yahav Biran wrote: It's nightmare to process an xls file. An external system is generating it and I need to process it. Is there any way to convert Microsoft Excel xls To CSV using a shell script. Is there any linux util that can help? There is the xlhtml package (sources at: http://chicago.sourceforge.net/xlhtml/ RPM package at Fedora extras). I use it for several years now. I have written a very simple wrapper script. It works quite well. Ehud. -- Ehud Karni Tel: +972-3-7966-561 /\ Mivtach - Simon Fax: +972-3-7966-667 \ / ASCII Ribbon Campaign Insurance agencies (USA) voice mail and X Against HTML Mail http://www.mvs.co.il FAX: 1-815-5509341 / \ GnuPG: 98EA398D http://www.keyserver.net/Better Safe Than Sorry = To unsubscribe, send mail to [EMAIL PROTECTED] with the word unsubscribe in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]