Re: [gentoo-user] M$ Excel document converter
Not sure about command line, but how about web based converters? (like docs.google.com ). It can open and save both MS office and OpenOffice formats. On 6/13/07, Aleksey Kunitskiy [EMAIL PROTECTED] wrote: Hi, Is there any command line converters from M$ Excel to any *nix readable format(i.e. for reading in KSpread)? Excel document contains only text and pictures - no formulas thanks -- best regards, Aleksey V. Kunitskiy -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
Am Mittwoch 13 Juni 2007 11:21 schrieb Aleksey Kunitskiy: Hi, Is there any command line converters from M$ Excel to any *nix readable format(i.e. for reading in KSpread)? Excel document contains only text and pictures - no formulas thanks -- best regards, Aleksey V. Kunitskiy You can open Excel files with KSpread and Openoffice without an external converter. Then you can save them in open document format. But keep in mind that documents produced by Openoffice are not 100% compatible with Koffice documents because they have a different implementation for some features. pgpBiaagy1Snc.pgp Description: PGP signature
Re: [gentoo-user] M$ Excel document converter
On Wednesday 13 June 2007 12:40, Florian Philipp wrote: You can open Excel files with KSpread and Openoffice without an external converter. Then you can save them in open document format. But keep in mind that documents produced by Openoffice are not 100% compatible with Koffice documents because they have a different implementation for some features. The problem is that KSpread doesn't read this Excel doc,i.e. the doc is unreadable in KSpread. OO is too big for reading one Excel doc once a week : (, imho -- best regards, Aleksey V. Kunitskiy -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
Aleksey Kunitskiy escribió: On Wednesday 13 June 2007 12:40, Florian Philipp wrote: You can open Excel files with KSpread and Openoffice without an external converter. Then you can save them in open document format. But keep in mind that documents produced by Openoffice are not 100% compatible with Koffice documents because they have a different implementation for some features. The problem is that KSpread doesn't read this Excel doc,i.e. the doc is unreadable in KSpread. OO is too big for reading one Excel doc once a week : (, imho Have you checked that document's Excel format? Maybe KSpread can't read it because of a too new Excel format, try re-saving it in an older one. HTH, Abraham -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
Am Mittwoch 13 Juni 2007 11:49 schrieb Aleksey Kunitskiy: On Wednesday 13 June 2007 12:40, Florian Philipp wrote: You can open Excel files with KSpread and Openoffice without an external converter. Then you can save them in open document format. But keep in mind that documents produced by Openoffice are not 100% compatible with Koffice documents because they have a different implementation for some features. The problem is that KSpread doesn't read this Excel doc,i.e. the doc is unreadable in KSpread. OO is too big for reading one Excel doc once a week : (, imho -- best regards, Aleksey V. Kunitskiy There is a portable version of OO for Win. It's around 124MB big and might be usable with Wine. pgpvu7kBiN8js.pgp Description: PGP signature
Re: [gentoo-user] M$ Excel document converter
On Wednesday 13 June 2007 13:10, Peter Ruskin wrote: OpenOffice reads (and saves) in M$ Excel format As I mentioned above - OO is very big tool for my needs -- best regards, Aleksey V. Kunitskiy -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
On Wednesday 13 June 2007 13:13, Abraham Marín Pérez wrote: Have you checked that document's Excel format? Maybe KSpread can't read it because of a too new Excel format, try re-saving it in an older one. HTH, Abraham I don't know what version it is - I get it from internet, and I can't open it in M$ Office because I don't have it ;). But I know that OO opens it very good -- best regards, Aleksey V. Kunitskiy -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
Hi, Am Mittwoch, 13. Jun 2007, 13:26:03 +0300 schrieb Aleksey Kunitskiy: On Wednesday 13 June 2007 13:10, Peter Ruskin wrote: OpenOffice reads (and saves) in M$ Excel format As I mentioned above - OO is very big tool for my needs There's a Ruby package `parseexcel' which seems to work as far as I can test here. http://raa.ruby-lang.org/project/parseexcel/ Bertram -- Bertram Scharpf Stuttgart, Deutschland/Germany http://www.bertram-scharpf.de -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
On Wednesday 13 June 2007 14:02, Bertram Scharpf wrote: There's a Ruby package `parseexcel' which seems to work as far as I can test here. http://raa.ruby-lang.org/project/parseexcel/ I'm not a ruby programmer :( -- best regards, Aleksey V. Kunitskiy -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
Hi Aleksey, Am Mittwoch, 13. Jun 2007, 14:28:31 +0300 schrieb Aleksey Kunitskiy: On Wednesday 13 June 2007 14:02, Bertram Scharpf wrote: http://raa.ruby-lang.org/project/parseexcel/ I'm not a ruby programmer :( Maybe a good opportunity to become one ... But seriously: Excel documents can contain much more than a plain CVS-style table, for example multiple sheets. I would not know how to design a simple command line tool to export nearly the half of the features MS-Office professionals occur to detect. Sorry. Bertram -- Bertram Scharpf Stuttgart, Deutschland/Germany http://www.bertram-scharpf.de -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
On Wednesday 13 June 2007, Aleksey Kunitskiy [EMAIL PROTECTED] wrote
about 'Re: [gentoo-user] M$ Excel document converter':
On Wednesday 13 June 2007 14:02, Bertram Scharpf wrote:
There's a Ruby package `parseexcel' which seems to work as
far as I can test here.
http://raa.ruby-lang.org/project/parseexcel/
I'm not a ruby programmer :(
I am.
Here's a script that will dump a worksheet as a csv. Save, chmod a+x, and
invoke like name_of_script name_of_excel_file worksheet_number csv_file
(e.g. ./convertxls price_list.xls 0 price_list.csv):
#! /usr/bin/ruby
require 'parseexcel'
wb = Spreadsheet::ParseExcel.parse(ARGV.shift)
ws = workbook.worksheet(ARGV.shift.to_i)
ws.each { |row|
puts row.collect { |cell|
'' + cell.to_s.gsub(//, '') + ''
}.join(',')
}
Clearly, all the heavy lifting is done by that library, which you will need
to run this script.
--
Boyd Stephen Smith Jr. ,= ,-_-. =.
[EMAIL PROTECTED] ((_/)o o(\_))
ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-'
http://iguanasuicide.org/ \_/
signature.asc
Description: This is a digitally signed message part.
Re: [gentoo-user] M$ Excel document converter
On 6/13/07, Abraham Marín Pérez [EMAIL PROTECTED] wrote:
Have you checked that document's Excel format? Maybe KSpread can't read
it because of a too new Excel format, try re-saving it in an older one.
If anybody finds something that will read the new OpenXML document
that the new $MS's is churning out it would be helpful, theres a tool
on sourceforge to convert to openoffice format... but its a windows
only app...so whats the point! :[
OO doesn't do it either last i checked.
I find it ironic that microsoft release their first 'non-proprietary'
format and its suddenly the only thing around that can process that
non-proprietary data. At least with their old proprietary formats we
could _read_ that
Now its a zip file with a whole lot of bogus rubbish that makes less
sense than a 90's+ swingers club.
( and yes, equally horrifying/disturbing ;) )
--
Kent
ruby -e '[1, 2, 4, 7, 0, 9, 5, 8, 3, 10, 11, 6, 12, 13].each{|x|
print enNOSPicAMreil [EMAIL PROTECTED][(2*x)..(2*x+1)]}'
--
[EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
Hi Stephen, Am Mittwoch, 13. Jun 2007, 07:04:25 -0500 schrieb Boyd Stephen Smith Jr.: On Wednesday 13 June 2007, Aleksey Kunitskiy [EMAIL PROTECTED] wrote about 'Re: [gentoo-user] M$ Excel document converter': On Wednesday 13 June 2007 14:02, Bertram Scharpf wrote: http://raa.ruby-lang.org/project/parseexcel/ I'm not a ruby programmer :( I am. Here's a script that will dump a worksheet as a csv. [...] Thanks from me, too! I surely will need this at some time in near future. Bertram -- Bertram Scharpf Stuttgart, Deutschland/Germany http://www.bertram-scharpf.de -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
On Wednesday 13 June 2007 15:04, Boyd Stephen Smith Jr. wrote:
I am.
Here's a script that will dump a worksheet as a csv. Save, chmod a+x, and
invoke like name_of_script name_of_excel_file worksheet_number csv_file
(e.g. ./convertxls price_list.xls 0 price_list.csv):
#! /usr/bin/ruby
require 'parseexcel'
wb = Spreadsheet::ParseExcel.parse(ARGV.shift)
ws = workbook.worksheet(ARGV.shift.to_i)
ws.each { |row|
puts row.collect { |cell|
'' + cell.to_s.gsub(//, '') + ''
}.join(',')
}
Clearly, all the heavy lifting is done by that library, which you will need
to run this script.
This script doesn't work for me :(
I have ruby parseexcel installed...
$ ./excel2cvs.rb complect.xls 0 complect.cvs
./excel2cvs.rb:5: undefined local variable or method `workbook' for
main:Object (NameError)
--
best regards,
Aleksey V. Kunitskiy
--
[EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
Hi, Am Mittwoch, 13. Jun 2007, 19:00:44 +0300 schrieb Aleksey Kunitskiy: On Wednesday 13 June 2007 15:04, Boyd Stephen Smith Jr. wrote: This script doesn't work for me :( $ ./excel2cvs.rb complect.xls 0 complect.cvs ./excel2cvs.rb:5: undefined local variable or method `workbook' for main:Object (NameError) Replace workbook by wb. (Not tested.) Bertram -- Bertram Scharpf Stuttgart, Deutschland/Germany http://www.bertram-scharpf.de -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] M$ Excel document converter
On Wednesday 13 June 2007, Aleksey Kunitskiy [EMAIL PROTECTED] wrote about 'Re: [gentoo-user] M$ Excel document converter': On Wednesday 13 June 2007 15:04, Boyd Stephen Smith Jr. wrote: I am. Here's a script that will dump a worksheet as a csv: #! /usr/bin/ruby This script doesn't work for me :( Bogus. :( Well, try Bertram's suggestion. I just wrote the script on the fly without testing it. I'll install parseexcel and see what I did wrong and post a script that works for me later. -- Boyd Stephen Smith Jr. ,= ,-_-. =. [EMAIL PROTECTED] ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.org/ \_/ signature.asc Description: This is a digitally signed message part.
