Help retrieving data

[ceekay]

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++ ??