IOverhead.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 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.

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