On 31 Aug 2008 at 8:43, Jerry Feldman wrote:
> On 08/27/2008 07:19 AM, Peter Saffrey wrote:
> > I'd like to be able to convert a spreadsheet (probably in Excel
> > format) into a set of CSV files representing each tab. Can I do this
> > in a script?
> >
> > I'm running on Linux. This is part of a web based application where a
> > user submits a CSV file for processing. At the moment, my users have
> > to save each tab individually before submission, which is a bit tedious.
> You certainly can save a document in a tab-delimited format by save as,
> select file type text csv and edit filter settings, and pull down the
> Field delimiter to {tab}.
>
> Or, if you get a true comma delimited file, you could use a simple bash
> (using sed) or perl script to change the commas to tabs.
I think perhaps you've missed the OP's point? I understood him to
mean "given a set of Calc files, how do I convert automatically to
CSV?".
That I can't answer; however, I do have macros (largely cribbed from
the net; my knowledge of OOo macro processing is abysmal) that
convert Write documents to doc/pdf from within a non-interactive
shell/batch script (iirc I even posted them to the list a few months
back - try the archives perhaps?). I imagine this job wouldn't be so
very different, but would need the appropriate filter names (finding
which was possibly the hardest part :-) )
--
Permission for this mail to be processed by any third party in
connection
with marketing or advertising purposes is hereby explicitly denied.
http://www.scottsonline.org.uk lists incoming sites blocked because
of spam
[EMAIL PROTECTED] Mike Scott, Harlow, Essex, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
