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