   c++ Excel read & write
  Could Anybody recommand me what you use to read and write data from Excel file?Thanks   
  Comma Seperated Value (CSV) files?Or do you mean a plug-in for Excel?   ;  If you want to read and write from an actual excel file you've got a couple of options.  Pre-2007 (.xls) is a closed format, meaning it wasn't published.  There is some documentation on this on the web, but it has basically been piece-mailed together, and not a guarantee you wont do more harm than good.  The better choice is to look into using an OLE/ODBC driver to access an excel file.The office 2007 format (.xlsx) is a published standard (XML), so you should be able to find the documentation on the file format, but even then, you are still probably better off using OLE/ODBC to access the file.[edit]Note:The OLE/ODBC option is going to be Windows only.   ;  If it's simple data, use CSV, hands down.   ;Quote:Original post by KonfusiusIf it's simple data, use CSV, hands down."Simple data" not including things like phone numbers or UTF-8 encoded text, that is. [sad] Excel's auto-formatting tends to destroy data (though the UTF-8 bug was fixed in 2007, I think). Fortunately, Excel can open a regular HTML table, and won't mutilate the data inside or screw up the encoding.   ;  A little Googling came up with this, which is a class that wraps Excel file access.  It appears to use MFC and ODBC, however it's possible you can extract the relevant portions and convert what you need to.This is a lot easier in .NET, if that's a viable option (even if you just make a small app that simply extracts the data).  You can either use the OleDbConnection class, or the Intertop.Excel.dll assembly.There are also ways to access Excel files by invoking an instance of EXCEL.EXE and interacting with it directly, but that has its own slew of problems and requires Excel be installed.   