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) _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
