Michael said:
Is it possible to generate Pivot Tables in HTML or XML?
The bigger question is what your intention is. You can create an XML
spreadsheet that contains a PivotTable by going File->Save As, and
choosing "XML Spreadsheet" from the "File Type" list.
I don't know about others, but when I've tried to do just that, I got
mixed results - Safari can't make any structure for the XML, but Firefox
can.
As far as making an HTML page from a worksheet containing a PivotTable,
yeah, sorta. By default, the generated file opens in Internet Explorer,
which is no longer supported for the Mac, so there's bound to be issues
there, especially on an Intel-based Mac.
Again, I would return to the question - what's your ultimate intent?
There may be more scalable, graceful solutions, depending on what you're
looking for. For example, you can export the XL data to a MySql
database, then create interactive, flexible displays of the data using PHP.
Please post back with more info.
