Find a cell & Read Data from Excel


#1


Hello,

How to find a cell that have the specified data in it?

How can I get the data from a excel cell if the cell has formula?

I have a cell and it has a formula like "=$B$5&$N30&$O30"
However, I can’t get its string value or its fomula.

cell.StringValue is “”, and cell.Foumula is “”.
How can I get those values?

Thank you,
Xhh


#2

Dear Xhh,

If the cell’s formula is set in designer file, Aspose.Excel cannot return the result data or formula. If you set formula by Aspose.Excel api, you can only get the formula. The result data is automatically calculated by Microsoft Excel, not by Aspose.Excel.