Re: HOWTO: Python Programming in Gnumeric
- From: "Charles R. Twardy" <charles twardy infotech monash edu au>
- To: peter kostov <peter light-bg com>, Gnumeric Dev List <gnumeric-list gnome org>
- Cc:
- Subject: Re: HOWTO: Python Programming in Gnumeric
- Date: Mon, 07 Mar 2005 09:09:06 +1100 (EST)
Dear Peter,
There may be an easier way. Gnumeric comes with "ssconvert", a utility to
convert spreadsheet formats.
Try:
ssconvert --export-file-per-sheet --export-type=Gnumeric_stf:stf_csv yourdata.xls newdata.txt
In my copy, "export-file-per-sheet" does not work, but perhaps someone on
the list (cc:) can tell you of progress there.
Clearly ssconvert is the tool you want. From file-per-sheet you could just
join all the files with your "!" separator as necessary.
No worries about your English.
-Charles
pk>Hi mr. Twardy,
pk>
pk>my name is Peter Kostov.
pk>
pk>I have read your "HOWTO: Python Programming in Gnumeric" and have and
pk>need help!
pk>
pk>I have build an informational site about the time-tables of the
pk>interurban buses in Bulgaria. Noone pays me for that, but I think it is
pk>worth doing it. With regard to this I have to export many MS Exel files
pk>in plain text format, every sheet as a separate file, with a separator
pk>`!'.
pk>It is of the first importance to me to find a way to do that
pk>automatically for all the .xls files in a given directory or I will have
pk>to close the site :(
pk>The problem is that I am not familiar with Python and have no time to
pk>learn it now in depth.
pk>
pk>I will be thankfull for your help!
pk>
pk>With kindest regards: Peter
pk>
pk>P.S. Excuse me for my bad english, please!
pk>
pk>
--
Charles R. Twardy www.csse.monash.edu.au/~ctwardy
Monash University sarbayes.org
Computer Sci. & Software Eng. +61(3) 9905 5823 (w) 5146 (fax)
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]