I need to retrieve/export the data from an excel file. I can't just save the file as txt because I noticed that the comments on cells are not saved with it.
So I need all the comments attached to cells and I need the data from cells who are formatted as General or text
So what I need to do is:
buffer []
for each sheet
{
getbounds // get maxrange or something like that
for all cells => buffer += getNotes // get the comments attached to cells
for the cells that are not empty
{
if formattype is general or txt
buffer += cell.getValue.toString
}
}
Anyone who can help me to program this in VB or prefferable in C++ ??
Bookmarks