Import To GRID with formula in cell | Infragistics Forums

20

Import To GRID with formula in cell

Kingston posted over 16 years ago

HI,

I am trying to Import from excel into grid.If a cell has formula and if i read the cell value I am getting the formula not the cell value.

foreach (WorksheetCell cell in w.Rows[iRow].Cells)

{

if (cell.Value != null && cell.Value.ToString().Length > 0)

{

cell.Value-------Returns the formula but not the value of the cell.

}

Parents

No Data

Reply

44743

Mike Dour posted over 16 years ago

Starting with the next release (8.3), formula solving has been implemented in the Excel assembly. In that version and later, getting the Value property of the cell will return the calculated value.
Cancel
Reply

Cancel

Children

745

karthik posted over 13 years ago in reply to Mike Dour

i m using the infragistics Relases Netadvantage 2010.3

Still the same problem exisit , its accessing only the formula , not the value

Dim ws As Infragistics.Excel.Worksheet = b.Worksheets(WorksheetName)

ws.Rows(r).Cells(0).Value ie the cell has formula ='Tool Summary EC'!C9.

i m getting exception only, Give me the solution for this

Regards

Karthik

HirotecIndia
Cancel
Reply

Cancel
90

Madhavi posted over 15 years ago in reply to Mike Dour

Hi,

I am facing a similar issue. Is there a workaround to this problem without upgrading to 8.3.

I am currently working with v8.1.

Thanks..
Cancel
Reply

Cancel