Why not just save it as a comma seperated value file .csv which is nothing
more then a comma delemeted ascii file?
Again In Excel file save as comma seperated value file.
No other conversion should be needed.
make it easy on your self.
----- Original Message -----
From: "Frank Roberts - SOTL" <sotl155360@earthlink.net>
To: <slug@nks.net>; "Ranjan Sharma" <webuser@thelinuxusers.net>
Sent: Monday, August 26, 2002 10:23 PM
Subject: Re: [SLUG] Converting from a Excel Work sheet to Ascii Text
>
>
> 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:08:20 EDT