| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | Tom Keller <kellert(at)ohsu(dot)edu> |
| Cc: | PDX PostgreSQL Users <pdxpug(at)postgresql(dot)org> |
| Subject: | Re: Any Excel Experts |
| Date: | 2011-05-06 00:08:16 |
| Message-ID: | E3814460-F686-43AB-B34F-C6D11F7F7F50@kineticode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pdxpug |
On May 5, 2011, at 5:06 PM, Tom Keller wrote:
> There's an app for that!
> ... sort of.
> Spreadsheet::ParseExcel (current maintainer is John McNamara) reads and parses Excel files. I've used it for grabbing data from spreadsheets to put into my lab's database. It works great. I've not used it with cells populated by functions using cells from other worksheets however.
Alas, it's not just the data we need from the spreadsheet. It's the algorithms. Also, they're a mess, with decidedly un-normalized data. They need to be detangled before they can be used programmatically. And therein lies our need.
Thanks,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lacey L. Powers | 2011-05-06 00:27:03 | Re: Migrating Data from MySQL to PostgreSQL |
| Previous Message | Rich Shepard | 2011-05-06 00:08:05 | Re: Migrating Data from MySQL to PostgreSQL |