Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
There doesn't seem to be a whole ton of info about XML with Excel 2003 yet
on MSDN (unless I'm looking in the wrong place). I'm trying to understand what functionality in Excel will be supported with the XML file format. Right now I'm using automation of Excel to create workbooks with one sheet with a table of data, and a second sheet with a pivot table based on the data from the first sheet. In some cases I'll have a 3rd sheet with a pivot chart. I'm really hoping that in the next version of my software, I'll be able to forget about automating Excel, and instead produce an XML document that users will be able to load into Excel 2003. There will (hopefully) be all the info in the XML file that Excel needs to automatically set up all the sheets, including the pivot table and chart. Is this someting that is supported with Excel 2003? Thanks, Chris |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I see the schema for Excel 2003 XML files will be released Dec 5, 2003
(http://www.microsoft.com/office/xml/default.mspx), so I'll be able to get my answer then. "Chris Pettingill" wrote in message ... There doesn't seem to be a whole ton of info about XML with Excel 2003 yet on MSDN (unless I'm looking in the wrong place). I'm trying to understand what functionality in Excel will be supported with the XML file format. Right now I'm using automation of Excel to create workbooks with one sheet with a table of data, and a second sheet with a pivot table based on the data from the first sheet. In some cases I'll have a 3rd sheet with a pivot chart. I'm really hoping that in the next version of my software, I'll be able to forget about automating Excel, and instead produce an XML document that users will be able to load into Excel 2003. There will (hopefully) be all the info in the XML file that Excel needs to automatically set up all the sheets, including the pivot table and chart. Is this someting that is supported with Excel 2003? Thanks, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |