As Warren has said, to get something into Excel will have to be a 2-part
1) Using MySQL++ for data retrieval
2) Generating a file suitable for Excel.
I had a similar issue, and ended up finding that Microsoft have
reasonable documentation for their xml spreadsheet format where you can
specify formatting, tabs etc. This ends up being much easier as you can
write to a plain text file.
From: Warren Young [mailto:mysqlpp@stripped]
Sent: 24 September 2008 06:03
To: MySQL++ Mailing List
Subject: Re: dump from mysql to "xl" file
> What are the function present in mysql++ for dump the database into
> microsoft XL file.
There are no large-scale data format conversion functions of any sort in
MySQL++. That is not its purpose.
You could use MySQL++ to write such a thing, with MySQL++ handling the
"read from MySQL" part, but it would be up to you to figure out how to
write the data you retrieve out in Excel format.
If you just need a simple one-time data conversion (i.e. not something
ongoing or needing automation) I recommend MySQL's Query Browser tool:
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus