QDVWBS.GetCellValueFromWorkbook (SelectWorkbook, String, String) Method

NOTE: This member is now obsolete. Use Qdv.UserApi.IOverhead.GetCellValueFromWorkbook, Qdv.UserApi.IBoq.GetCellValueFromWorkbook and Qdv.UserApi.IWbs.GetCellValueFromWorkbook() You can obtain these objects from Qdv.UserApi.IEstimateVersion.Overhead, Boq and Wbs properties.

Reads a value from any cell in any workbook directly. No need for lock.
[Obsolete("Use Qdv.UserApi.IOverhead.GetCellValueFromWorkbook, Qdv.UserApi.IBoq.GetCellValueFromWorkbook and Qdv.UserApi.IWbs.GetCellValueFromWorkbook()
    You can obtain these objects from Qdv.UserApi.IEstimateVersion.Overhead, Boq and Wbs properties.
   ")] 
public object GetCellValueFromWorkbook( 
SelectWorkbook WhichWorkbook
string WorksheetName
string RangeReference 
)
This language is not supported or no code example is available.

Parameters

WhichWorkbook
SelectWorkbook

The workbook from which you want to read the value.

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

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.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition