Currently my company has a very old demo of a C++ version of Cells. I’ve been tasked with turning our proof of concept into an actual feature, and it seems that the path of least resistance for that would be to continue using Cells. However, in looking at your website, I’ve been unable to find mention of a C++ version. Our existing application is 100% C++. Is a C++ version still offered? If not, is it possible to link a C++ application against your library? Would it be possible for us to write a wrapper in C# that can be linked to C++?
Assuming that we can somehow integrate with your product, I have a few other questions about its capabilities:
- Your documentation mentions that it supports Excel file formats from 97 through 2007. Does this include all the myriad formats introduced in 2007, such as XSLX and XSLB? Do you support manipulating CSV files? Do you have any support for native OpenOffice spreadsheets (ODS)? This last one isn’t a requirement, but would be nice to have. What about saving/exporting to these formats? What about saving as PDF or HTML?
- Your documentation mentions you can create and access named ranges, but doesn’t mention modifying them. Can I modify named ranges (as in the range that is named, not the cells in that range). One of the primary use cases of our software will be to look at a named range to determine a start cell, fill in a bunch of data into cells in that column, then update the named range to point to the cells just filled in. Can you support this?
- Is it possible to easily copy all the formatting information (including conditional formatting) from one cell to another? As described above, when we’re filling in those cells, we want to apply the formatting from the start cell to all of the cells subsequently filled in.