IOverhead.GetCellValueFromWorkbook (String, Int32, Int32) Method

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 localized worksheet name from which you want to read the value. This is the localized name that is displayed in QDV tab name. So it may be different in other languages!

If you want to use the language neutral ID, get the overhead workbook with GetReadOnlyCopyOfWorkbook, enumerate all worksheets in it, and test their OverheadSheetInfo.Name property. Then access the cell in the found sheet.

RowNumber

int

The zero-based row number.

ColumnNumber

int

The zero-based column number.

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