-
C++ and MS Excel
Hi,
I've written some programs in C++ before which open and write to plain text files. However, I was wondering if it is possible to do the same with MS Excel files. If it is, is there any way to control which cells within the Excel file are written to?
I've tried searching the Internet for some possible solutions but the few which I have found are quite unclear. (By the way, I am using MS Office XP)
Any help would be greatly appreciated. Thanks so much!
-
Would The Comma Separated Value (CSV) File Format work for you? I'm sure Excel would accept that and give you some control of how data is displayed within Excel. Although I'm just guessing so maybe someone else can give you a better answer. Perhaps XML format or something
-
there are a couple of ways to do this.
you can either access the excel object model from C++, or you could try writing the file yourself with the excel file format, although that can change from version to version.