I think you'll find that most Big Co Excel spreadsheets are far more than rows of data to be imported into mysql at the push of a button.
They will contain thousands of formula, links to other sheets and workbooks, macros, Visual Basic classes and modules, VBScript, charts and possibly complex 3rd party addins and analysis packs.
So the "export to DB and done" is about 0.001% of the task.
Next.
They will contain thousands of formula, links to other sheets and workbooks, macros, Visual Basic classes and modules, VBScript, charts and possibly complex 3rd party addins and analysis packs.
So the "export to DB and done" is about 0.001% of the task.
Next.
Comment