Hi,

This may not be the correct forum for this post so please direct me elsewhere if that is the case.

I need to generate Grouping (i.e. tie a range of cells together so that they can be expanded or collapsed) in a Xslt that produces an Excel 2003 Xml spreadsheet. I don't see any attributes on the Worksheet, Table, Row , Cell or Data in my Office Xml Reference documentation that pertain.

So I tried to reverse engineer the xml by creating a simple Excel spreadsheet of 3 rows then do the grouping (Data/Grouping) then save the spreadsheet as Xml Spreadsheet 2003 (.xml). I get a warning that some features will be lost. After saving the spreadsheet as .xml and opening in Notepad I don't see any trace of the grouping. When I open the .xml file in Excel the grouping is gone.

Does this mean that SpreadsheetML for Excel 2003 does not support Grouping? If ExcelML does support Grouping can someone point me to an example that contains the attributes/elements that I need to code my Xslt?

Thanks...Ron

You're right, this is the wrong forum. If you don't know what output you want your stylesheet to produce then we can't help you write it.

You'll need to find someone who knows Excel Spreadsheet XML very deeply to get a better answer than you have been able to find by experiment.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

If the Spreadsheet was only one worksheet with no formatting and simple data then it looks like the feature about to be lost was indeed the grouping. I will ask around but 2003 SpreadsheetML is not a well-known topic.

--

Joe (Microsoft MVP - XML)