hi mike,
I m Retriving the value from Excel and assigning the value directly to Datatable , Whict act as datasource for Ultragrid
Dim ws As Infragistics.Excel.Worksheet = b.Worksheets(WorksheetName)
dattable.Rows(Row)(column) = ws.Rows(r).Cells(c).Value
its working fine but if the cell have any formula value its throw an exception like
ws.Rows(r).Cells(c).Value might be -> ='Tool Summary EC'!B8
please help to fix this exception
Regards
Karthik
HirotecIndia LTd
Hi Karthik,
I tried this out and it works just fine for me.
What's the exception you are getting?
What version of the controls are you using?
You might want to make sure you are using the latest service release.
How to get the latest service release - Infragistics Community
hi Mike, For me also its working Properly but is the that particular cell getting value if it is same sheet formula , its retriving only the formula instead of its actual value if refeering other sheet
for Example if the cell has ='Tool Summary EC'!b8 ie some other sheet cell value in that particular workbook.
Actually my need is , i have opened sheet A , it refers the value from the Sheet C a1 cell value, so sheet A -> a1 Contains ='c'!a1 ,
guide me how to access other sheet formula in another sheet
HirotecIndia ltd
I'm afraid I do not understand your question. If you have a cell with a Formula, then accessing the Value property of the cell will return the calculated value.
If you just want reference some other cell, then you use the Worksheets collection of the Workbook to get the Worksheet, and then access the row and cell that you want using worksheet.Rows[index].Cells[index].
I have some examples where what you describe is true, but I have other examples where cell.value returns 0.0 even though when I open the xlsx file and view its xml, the value stored in the file and displayed by Excel is 180. Does the list of functions or the references inside the formula have any bearing on accessing Excel's stored value?