Why not just open the file in a spread sheet then save it as a text file then
open it in a word processor and then do a edit replacemrnt. Total estimated
time 5 minutes.
I just tried this by creating a spread sheet in Open offive then saving it as
a text file but when I attempted to open it as a word document in open office
it automatically converted to a spread sheet so I then opened it in Abbie
Word. To convert it to tab deliminated all I would then have to do was a
replacement of the "," characters with ^t and I would have what you
described.
Frank
On Monday 26 August 2002 21:54, Ranjan Sharma wrote:
> Hi,
>
> Thanks andrew.This really looks promising. I will
> be doing a proof of concept tomorrow. Whatever happens
> i will any way be geek of the day..) All thanks to you.
>
> Bye
> ranjan
>
> On Mon, Aug 26, 2002 at 09:05:01PM -0400, Andrew Wyatt wrote:
> > On Monday 26 August 2002 08:57 pm, Ranjan Sharma wrote:
> > > Hi guys,
> > >
> > > I am looking for some help on parsing an excel worksheet.
> > > I want to convert it into a tab seperated file. Is there any
> > > utility that exist that i can use. Openoffice can do that
> > > but it is a manual process. Has anyone come across any
> > > application or a library that can convert an excel file
> > > to ascii.
> >
> > Try this..
> >
> > http://www.cpan.org/authors/id/J/JM/JMCNAMARA/
> >
> > -Andrew
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 17:07:56 EDT