[Novalug] Way OT: documenting Excel Spreadsheet

[Palmer]

Thanks Ken - for the immediate term I need to document what the excel
spreadsheet does so we can get a handle on scope.
Thanks
Cliff

> On windows, you can use ODBC to move Excel content into a database that
> supports ODBC.  MySQL even offers an ODBC driver.
>
> Ken
>
> -----Original Message-----
> From: novalug-bounces at calypso.tux.org
> [mailto:novalug-bounces at calypso.tux.org] On Behalf Of Cliff Palmer
> Sent: Tuesday, November 06, 2007 6:29 AM
> To: novalug at calypso.tux.org
> Subject: [Novalug] Way OT: documenting Excel Spreadsheet
>
> Our client has handed us "the mother of all spreadsheets" and asked us
> to turn it into a web-based application with the data stored in, "GASP",
> a database.  The spreadsheet is huge and no longer meets their file-size
> limits for email attachments, so it's obviously time to upgrade.
>
> The spreadsheet has over a hundred "worksheets" embedded in it, has been
> worked on by a series of passable-to-near-genius excel users over the
> last several years, and lots and lots of fine macros (no VB code, excel
> macros is what we're told).
>
> I have seen tools that document the contents of Lotus spreadsheets,
> printing a report showing what is in each cell in each worksheet, and
> creating a cross-reference of dependencies and forward references.  I
> need something like that for Excel.  Does any one know of such a tool ?
>
> I know about the command in excel to show the function, macro, etc on
> the screen - that really won't help me.
>
> Thanks
> Cliff
>
> _______________________________________________
> Novalug mailing list
> Novalug at calypso.tux.org
> http://calypso.tux.org/cgi-bin/mailman/listinfo/novalug
>