I have a 'data health' project which requires excel as a final output. However the requirements are in my opinion ill suited to VBA, it just does not scale to the job properly. I plan to write in C++ for a quality solution - The actual processing and 'tool' spec is nailed on for it. Can anybody point me to a library that is free and allows me to talk to excel once processing is over? I would like access to excel formatting and worksheets, save in proprietary formats. I have checked a few things out but any suggestions? Is there any e.g. open source, good quality library around?
If you don't mind a "bit of cheating" write a csv file -- possibly with extension .xls :)
Excel will open and convert it on the fly.
Thats what i am saying, I know i can generate data and filetypes that excel will open but i need the true access - I don't want to deliver a tool that requires anybody to go and add all the formatting for tables etc afterwards -Though Its not the end of the world if that is what ends up happening like. I have stuff i can use to write chart output in all sorts of ways via fltk - but there is no budget for 'roll your own' on this job - interface yes, quick and easy, output via fancy formatting to custom code widgets - no.
Unless you are working with an old version of Excel (before 2007) then you can just use the open document format. OpenDocument Format for developers
LibOPC is yet another option. http://libopc.codeplex.com/documentation
ok, cool, thanks for the suggestions will take a look