C++中操作Excel

使用CSpreadSheet类：

http://www.codeproject.com/KB/database/cspreadsheet.aspx

作者列出了该类的一些使用限制：

1. Requires MFC.
2. May or may not support unicode. (didn't check it out)
3. Uses ODBC to read and write to Excel file, thus will have the limitations of ODBC driver. (I am not sure whatever limitation does the ODBC driver has)
4. Must have header row in Excel file and every column of the header row must be unique. (because class is treating Excel file as a database)
5. Cannot delete a sheet from Excel file. Can only delete contents of that sheet
6. Cell values are treated as a string, regardless of their format in Excel.

del.icio.us Tags: Excel,C++