Re: Any Excel Experts

David,
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.

TomK
MMI DNA Services Core Facility
503-494-2442
kellert at ohsu.edu
Office: 6588 RJH (CROET/BasicScience)

On May 5, 2011, at 3:20 PM, David E. Wheeler wrote:

> Fellow database fans,
>
> We're looking for someone who lives and breathes Microsoft Excel to detangle a large collection of worksheets and work it into a more generalizable format for publication as part of an environmental open data project. We're talking 5-6 years of data collected willy-nilly into 120 worksheets and held together with links, formulas, and duct tape. The ideal candidate will be:
>
> * An expert in Excel 10
> * Able to consolidate the worksheets down to a single workbook.
> * Able to downgrade the worksheet to Excel 97 format
> * Able to convert the worksheet to OpenOffice.org or Gnumeric and fix the breakage
> * Available to complete this task before June 15th.
> * Has experience and interest in the publication of open data
>
> Anybody qualified for this, or know someone who is?
>
> Thanks!
>
> David
>
>
>
>
>
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug