[Novalug] Way OT: documenting Excel Spreadsheet
cliff at palmercs.com
Tue Nov 6 11:42:01 EST 2007
Thanks Ken - for the immediate term I need to document what the excel
spreadsheet does so we can get a handle on scope.
> On windows, you can use ODBC to move Excel content into a database that
> supports ODBC. MySQL even offers an ODBC driver.
> -----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.
> Novalug mailing list
> Novalug at calypso.tux.org
More information about the Novalug