I am using Infragistic 10.2 and reading excel file using Infragistic.excel
1) To read formula attached to a cell.
Below is the code for reading :
Workbook workbook1 = Workbook.Load("filename.xls");
"filename.xls"
Infragistics.Documents.Excel.Worksheet worksheet = workBook.Worksheets["DifferentFormats"];
string aValue;
for (int i = 0; i < 8; i++){
aValue = worksheet.Rows[i].Cells[1].value;
}
aValue is reading =T("1299") whereas it has to read 1299 and ignore formula applied to that cell.
Searched on infragistic site and found to use "GetText" property but in version of infragistic to able to find this property.
Due to some restrictions , can't upgrade infragistic version . Can any one suggest any solution for this problem or any sample of code which can read such values.
Please need solution on urgent basis.
The Value property of the cell will return the calculated value from the formula andit has doing this since version 8.2 I believe. We do have support for the VLOOKUP function starting in the 10.2.20102.2035 SR of 10.2.
What can be doen incase vlookup like formula which is applied to the cell.
Can we request for any patch from infragistics which can be added with Infragistics2.excel.v10.2 and which can solve the problem.
Which version of infragistics has separate property to read value generated from formula?
Getting the Value property should return the calculated value. However it looks like we don't have support for the T function, so this should actually return a #NAME? error. It looks like the only option is to manually parse the formula and see if the "T" function is being used and if so, get its argument's value. I can't think of another option at this point.