Parsing xls with groups

Question

Hi! Can you tell me how to parse xls file, which contains groups(outlines) using ODBC or COM

Answer 1

I think groups won't show with ODBC. If these are Excel 2007 files you could crack open the open xml file. With COM... you can access outlines.. but I forgot the object names !

Answer 2

I'd suggest taking a look at the following links. I've done a bit of work on this recently I would suggest checking out this document.

http://msdn.microsoft.com/en-us/library/wss56bz7%28VS.80%29.aspx

and

http://www.ecma-international.org/publications/standards/Ecma-376.htm

The first is a no brainer but the second is the back XML portion which I found priceless.