l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2010 Jan 28 07:45

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Exporting multiple sheets to CSV?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] Exporting multiple sheets to CSV?

Yes there is - but it looks nasty ...

original post is old (2004) but latest is Dec 2009




On Wed, Jan 27, 2010 at 14:16, Bill Kendrick <nbs@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@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.