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.
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??? |
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 |