IOverhead.GetWorkbook Method
| Exception type | Condition |
|---|---|
|
A problem occurred. |
You need to acquire a lock on the workbook with the GetLockOnWorkbook before
you call this method. When you finish working on the workbook, you should call
the ReleaseLockOnWorkbook method.
You can only use this method with the current estimate version, with IEstimateVersion.Version set to 0.
To handle the worksheets in the workbook, use the IWorksheetManager interface that you can obtain from WorksheetManager property.
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 IWorksheetManager.GetRowPositionsInNativeSheet method or from OverheadSheetInfo.Areas property returned by IWorksheetManager.GetOverheadSheetInformation
- up to the last column from OverheadSheetInfo.LastVisibleColumn property returned by IWorksheetManager.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.
Available since QDV 7.13.0001.
