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.
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.
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?
Please follow the following link: https://es.infragistics.com/my-account/keys-and-downloads/. Please sign-in if you have not already. Please select NetAdvantage 2010 Vol. 2, then click on 'Service Releases' below. Please locate the release for Windows Forms. You have to install it and test your application against it, please make sure that it is 10.2.2035 in your assemblies in the project.
Thanks for quick response.I will check and update you whether it is solving or not.
I am facing one more issue of reading excel file of 2010 with extension .xlsx
Will this service release also resolve issue of reading.xlsx file.
Can you guide me on implementation of IpackageFactory which is required. I am unable to find sample code for this.
Hello Renuka,
The service release you are going to download is actually 2151 and it is even newer so everything is fine.
As to reading xlsx - please use Infragistics3.Excel.v10.2 assembly instead of the Infragistics2.Excel.v10.2 one.
No other option than updating Infragistic2 to Infragistics3. This is impacting my entire application and its functionality.This is not be accepted by our client.
IPackageFactory implementation is not solution for this?
I am not talking about any update here. Just changing the assemblies. What could possibly do this to the application? Please let me know, I think that I misunderstood you.
Will 2035 service release for v10.2 solve my problem of reading any formula field like T("1299") , VLOOKUP(), SUM(C1,C2) or just VLOOKUP().
Because currently with Netadvantage 10.2 WIN CLR2x , it reading #Name in value property for all above formula.
Need confirmation on this to proceed further for downloading this service. Thanks in advance.
Renuka,
It is very to hear this! I will be waiting for your feedback.
Thanks alot for solving my one issue. I have updated in my application Infragistics3 and it is working fine. Thanks for your quick and useful replies.
I will check regarding service release suggested for formula and update you by tomorrow.
I do not think that you should change anything. Just to be sure - I tested this and it is working fine. What is bothering you exactly, could you paste some code which will not work?
Using Infragistics2.Win.UltraWinGrid.v10.2 and this Infragistics3.Win.UltraWinGrid.ExcelExport.v10.2 will work properly. It will not have version conflict.We have overrided many methods of CGDATAGRID which is of Infragistics2.