Re: converting .xls to delimited file

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Martin Lillepuu <martin(dot)lillepuu(at)mail(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: converting .xls to delimited file
Date: 2001-01-15 01:03:11
Message-ID: 20010114190311.A988@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Thu, Jan 11, 2001 at 12:13:34AM +0200,
Martin Lillepuu <martin(dot)lillepuu(at)mail(dot)ee> wrote:
> William Staniewicz wrote:
> >
> > Is there any way to convert an Excel file (".xls")
> > to a delimited file? Maybe using sed?
>
> search for xls2csv on freshmeat. it works for simpler excel files but
> tends to segfault with complicated ones (with macros, etc) :(
>
> if anyone currently knows some better tool for the task, i'm all ears.

I currently get data for my database backed web pages from some other
people that keep it in excel files. What I am using to get at the data
is xlHtml-0.2.7.2.

I have tweaked it a bit. I have problems with dates showing up as numbers
and need to check for what are effectively Julian days for dates as well
as the more normal formats.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Castle 2001-01-15 01:05:05 Re: Re: starting PGSQL automatically on Redhat 6.2
Previous Message Stephan Szabo 2001-01-15 00:59:33 Re: Can't compare decimal columns???

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-15 01:32:30 Re: POSTGRES TOO SLOW
Previous Message Mills, Wallace 2001-01-15 00:25:50 Storing Graphic Files