IWbs.GetCellValueFromWorkbook (String, String) Method

Function GetCellValueFromWorkbook( _ 
   ByVal WorksheetName As String, _ 
   ByVal RangeReference As String _ 
) As Object

This language is not supported or no code example is available.

object GetCellValueFromWorkbook( 
   string WorksheetName, 
   string RangeReference 
)

This language is not supported or no code example is available.

Parameters

WorksheetName

string

The worksheet name from which you want to read the value.

RangeReference

string

The reference to the cell you want to read. E.g. 'A1'

Return Value

The value being in the cell.

When you have few values to read from a workbook, prefer this rather than getting an instance of the complete workbook. This is usually faster because you don't have to acquire a lock on the workbook.

When referring to a merged area or a range, it returns the value being in the upper cell.

.NET Framework