IWorksheetManager.GetNativeWorksheet Method

Function GetNativeWorksheet( _ 
   ByVal overheadWorkbook As IWorkbook, _ 
   ByVal sheetType As NativeSheetType, _ 
   Optional ByVal fieldMnemonic As String = "" _ 
) As IWorksheet

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

IWorksheet GetNativeWorksheet( 
   IWorkbook overheadWorkbook, 
   NativeSheetType sheetType, 
   string fieldMnemonic = "" 
)

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

Parameters

overheadWorkbook

IWorkbook

The overhead workbook.

sheetType

NativeSheetType

Required.

fieldMnemonic

string

The mnemonic of a minute field or set of fields, which refers to the sheet in the fields manager. It has only meaning for some types of overhead worksheets, such as material, workforce, list, etc. In such a case, it should be the same as OverheadSheetInfo.Name returned from GetOverheadSheetInformation.

Return Value

A more flexible alternative to calling this method is to simply enumerate all sheets in overheadWorkbook. Then just call GetOverheadSheetInformation on each sheet and test the returned OverheadSheetInfo.

Sheets of type NativeSheetType.Template are very hidden in QDV. They are used by QDV internally when you create new sheets. You must NOT modify these sheets.

It is highly recommended that you don't write to sheets of any other type than NativeSheetType.User.

If you really want to add information to such sheets, please make sure that you write only:

• into free columns
• between the top and bottom rows (including these rows) of the sheet areas returned by GetRowPositionsInNativeSheet method or from OverheadSheetInfo.Areas property returned by GetOverheadSheetInformation
• up to the last column from OverheadSheetInfo.LastVisibleColumn property returned by GetOverheadSheetInformation.

If by mistake, you break the logic of such sheet, you can remove it (by removing the corresponding field of set of fields) and create it again. You'll get a fresh sheet derived from the hidden templates.

.NET Framework