IWbs.GetCellValueFromWorkbook (String, Int32, Int32) Method

Reads a value from any cell in any workbook directly. No need for lock.
Function GetCellValueFromWorkbook( _ 
ByVal WorksheetName As String, _ 
ByVal RowNumber As Integer, _ 
ByVal ColumnNumber As Integer
) As Object
This language is not supported or no code example is available.
object GetCellValueFromWorkbook( 
string WorksheetName
int RowNumber
int ColumnNumber 
)
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.

RowNumber
int

The zero-based row number.

ColumnNumber
int

The zero-based column number.

Return Value

object

The value being in the cell.

Remarks
 

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.

Version
 
Available since QDV 7.13.0001.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition