I want to make a c++ program that edits a excel file with what has been inputted into it. But the problem is that i only know how to do it with a csv file which is useless to me as i want to also want to change the colour of cells.
So is there a file format that can allow me to change the colour of cells and do borders around cells as well?
If you're looking for information on controlling Excel, the phrase to search for is "Excel Automation", though you will prob. need to quality your searches with C++ to avoid all the C# and VB.NET discussions.
There are a number of threads on this subject on this forum already, as well as about the greater web. For example, this recent one:
(Here you'll see that I prefer to use Direct-to-COM style programming (using compiler generated smart wrapper classes) whereas freddie1 prefers to work the WinAPI COM Automation functions directly.)
Andy
PS When you say:
So is there a file format that can allow me to change the colour of cells and do borders around cells as well?
You are meaning one which you can load back into Excel, yes?