Is it possible to import outlined data from Excel?
This is where Excel shows drill-down [+] [-].
Reading from ODBC doesn't give parent/child info; neither does exporting to CSV; export to HTML gives this info via mso-outline-level styles, but 2007 version puts actual content into subfolder and users will be VERY confused trying to select an appropriate file.
Excel 'Group and Outline' feature needs one column(or row) to know how to group rows, isn't it ? Info about outline is stored in object. So neither ODBC nor CSV allow you to read it. You should use COM api in older versions of Excel or new C# api in latest to get access to those informations.
I ended up parsing .mht file exported from Excel, it has the required structure in form of tr tags and mso- attributes.