IWorksheetManager Interface
| Name | Description | |
|---|---|---|
|
GetColumnLettersFromPosition(int) | Gets the column letters in A1 notation from column numeric position. |
|
|
GetColumnPositionFromLetters(string) | Gets the column numeric position from column letters in A1 notation. |
|
|
GetNativeWorksheet(IWorkbook, NativeSheetType, string) | Gets the overhead worksheet of the specified type from the overhead workbook. |
|
|
GetOverheadSheetInformation(IWorksheet) | Gets the information about a sheet in the overhead workbook. |
|
|
GetRowPositionsInNativeSheet(IWorksheet) | Obsolete. Gets the row numbers of various sheet areas in an overhead worksheet. |
|
|
RemoveSheetsFromWorkbook(IWorkbook, IList<IWorksheet>) | Removes specified sheets from a workbook. The operation is safe, it means that formulas in remaining sheets will be converted to computed values, because formulas could contain cells from the removed sheets. |
|
|
ShowHeadingsAndGridlines(IWorkbook) | Shows the headings and gridlines of a workbook. |
You can obtain an instance of this interface from QdvManager.WorksheetManager property or from IOverhead.WorksheetManager property.
Information about overhead sheets is stored for all native sheets in column 255 (IV), but for workbooks having Time Frame sheets extended, the information is stored in column 1023 (AMJ).
We know that a workbook has extended time frame when it has a workbook variable named HasExtendedTimeFrames whose value is 1.
Available since QDV 7.13.0001.
