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.
I have understood that you are refering to change the assemblies. But we are using infragistics2.excel and their are many methods which are refered from Infragistics2 in my application. So this is causing impact on my application to large extent.
So asking is there any simple solution. I will try with Infragistics3 and let you know.
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.
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?
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.
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.