[vox-tech] Exporting multiple sheets to CSV?

[Drew Arnett]

Hi Bill,

Saw some of the other responses.  I have been using an .xls reader
library recently to be able to read them as easily as CSV files for
various things at work.  With that lib, it would be pretty trivial to
write a small script to do your export function.  But that's xls to
csv.  Without googling, I'd be pretty sure a similar read lib is
available for .ods, too.  But, those built in macros are sure a nice
way to go, especially if the one suggested does exactly what you need
anyway.

Best regards,

Drew


On Wed, Jan 27, 2010 at 12:16 PM, Bill Kendrick <nbs at sonic.net> wrote:
>
> I've got an ODS spreadsheet file that I'm maintaining with OpenOffice.org Calc.
> It contains multiple sheets, which I'd like to export each as separate CSV
> text files (tab-delimited text, in my case).
>
> Unfortunately, the "Save As..." option, when I choose CSV as the output type,
> only saves the current sheet.  (And brings up that: "Warning: only saved the
> current sheet" (paraphrased) dialog.)
>
> _Is_ there a way to dump every sheet in an ODS file into individual CSVs,
> without going doing a bunch of manual labor?  (Switch to first sheet, save as;
> switch to second sheet, save as; switch to third sheet, save as; ad infinitum.)
>
> Aside from it being easier to manage all the sheets at once (rather than
> managing them all as separate files), they also do a lot of cross-referencing
> of each other.  So splitting the ODS up into individual files is something
> I'd like to avoid.
>
> Thanks in advance,
>
> --
> -bill!
> Sent from my computer
> _______________________________________________
> vox-tech mailing list
> vox-tech at lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech
>