ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
  • Properties specific to the description of xlsLayout variables
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
xlsLayout (Type of variable)
In french: xlsMiseEnPage
The xlsLayout type is used to define all the layout characteristics to print a sheet of an XLSX document in a Spreadsheet control or in a variable of type xlsDocument. The characteristics of this layout can be defined and changed using different WLanguage properties.
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
Example
// Current sheet [NoMargins]
xLayout is xlsLayout = PSHEET_SpreadsheetControl.PageLayout
xLayout.LeftMargin = 0
xLayout.RightMargin = 0
PSHEET_SpreadsheetControl.PageLayout = xLayout
Remarks

Properties specific to the description of xlsLayout variables

The following properties can be used to handle layouts:
Property nameType usedEffect
HeaderPrintedBoolean
  • True (default) to print the sheet header.
  • False otherwise.
HeaderVisibleBoolean
  • True (default) to show the sheet header in the Spreadsheet control.
  • False otherwise.
PageHeaderRealHeight of the page header in the printed sheet, expressed in millimeters.
PageHeightRealHeight of the printed page, expressed in millimeters.
PageWidthRealWidth of the printed page, expressed in millimeters.
BottomMarginDouble realBottom margin of the printed page, expressed in millimeters.
RightMarginRealRight margin of the printed page, expressed in millimeters.
LeftMarginRealLeft margin of the printed page, expressed in millimeters.
TopMarginRealTop margin of the printed page, expressed in millimeters.
AdjustmentModeInteger constant
  • adjustmentModeNone: No scaling is performed.
  • adjustementModeColumns: All the columns are adjusted to the control width.
  • adjustementModeRows: All the rows are adjusted to the control height.
  • adjustmentModeRowsAndColumns: The worksheet is adjusted to the dimensions of a Spreadsheet control.
LandscapeOrientationBoolean
  • True (default) for landscape orientation,
  • False for portrait orientation.
PageFooterRealHeight of the footer in the printed page, expressed in millimeters.
GridlinesPrintedBoolean
  • True (default) to print the gridlines around the cells,
  • False to print without gridlines.
GridlinesVisibleBoolean
  • True (default) to show the gridlines around the cells in the Spreadsheet control,
  • False otherwise.
Minimum version required
  • Version 28
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/25/2022

Send a report | Local help