Hi,
Which is the better way of getting the 'as displayed' cell value?
Dim selection As CellSelection = worksheet.Cells(i, j) Dim value As ICellValue = selection.GetValue().Value Dim format As CellValueFormat = selection.GetFormat().Value Dim formatResult As CellValueFormatResult = format.GetFormatResult(value) Dim result As String result = value.GetResultValueAsString(format) 'vs. result = formatResult.VisibleInfosText
Thanks,
Sid