your three solutions are
1. use the
OLEDB JET Driver for Excel[
^]
2. the
object model for Excel[
^]
3. the
Office XML format[
^]
The first requires you have a C++ OLEDB client library
The second requires using COM and messing with the godawful Excel Automation model (here we use an Active Script Host in C++ and let a VB script do all the heavy lifting, it's easier to debug, and develop that way)
The third could be done by turning your raw data into a basic XML doc then XSLT'ing it to the required format - again, this involves either a third party XML/XSLT client or getting your hands dirty with
MSXML[
^]