Object: 2DTableSettings
- Updated2024-09-12
- 1 minute(s) read
(ReportObjects | SelectedObjects) > 2DTable > Object: 2DTableSettings
Object: 2DTableSettings
The 2DTableSettings object provides the properties of a 2D table in DIAdem REPORT.
The following example generates a table with two columns and a gray background:
| VBScript | Python |
Dim oMy2DTable, oMyPosition, oMySettings, oMyColumn1, oMyColumn2 Call Report.NewLayout() Set oMy2DTable = Report.ActiveSheet.Objects.Add(eReportObject2DTable,"My2DTable") Set oMyPosition = oMy2DTable.Position.ByBorder oMyPosition.Top = 30 oMyPosition.Bottom = 20 oMyPosition.Left = 20 oMyPosition.Right = 30 Set oMySettings = oMy2DTable.Settings oMySettings.Header.Height = 20 Call oMySettings.BackgroundColor.SetPredefinedColor(eColorIndexGrey) Set oMyColumn1 = oMy2DTable.Columns.Add(e2DTableColumnChannel) oMyColumn1.Channel.Reference = "[1]/[1]" Set oMyColumn2 = oMy2DTable.Columns.Add(e2DTableColumnChannel) oMyColumn2.Channel.Reference = "[1]/[2]" Call Report.Refresh()
Properties
BackgroundColor | BorderLineColor | ColumnBackground | ColumnExpansionMode | Footer | GridHorizontal | GridVertical | Header | HideEmptyLines | IndexSettings | Orientation | Palette | RowBackground | UseAutoFontSize | UseChannelTransformation | UseSorting | UseXDoubleLine | UseYDoubleLine