ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
  • Properties specific to xlsColumn 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
xlsColumn (Variable type)
In french: xlsColonne
The xlsColumn type is used to describe and modify a column in an Excel document. The characteristics of this column can be defined and modified using different WLanguage properties.
This type of variable is used by the xlsDocument type.
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
New in version SaaS
Android This type of variable is now available for Android applications.
Android Widget This type of variable is now available in Android widget mode.
iPhone/iPad This type of variable is now available for iPhone/iPad applications.
Example
// Open an Excel file.
sExcelFile is string
sExcelFile = fSelect("", "", "Select an Excel file...", ...
	"Excel" + TAB + "*.xlsx" + CR + "All files (*.*)" + TAB + "*.*", "*.xlsx")
IF sExcelFile = "" THEN RETURN

// Open the Excel document.
MyDocument is xlsDocument
MyDocument = xlsOpen(sExcelFile)

// Cell by default.
Cell is xlsCell
Cell.BackgroundColor = LightRed

// xlsColumn variable
Column is xlsColumn
Column.Width = 200
Column.DefaultColumn = Cell

// The Column variable is used by column 2 of the document.
MyDocument..Column[2] = Column

// Saves the modifications.
xlsSave(MyDocument)
xlsClose(MyDocument)
Remarks

Properties specific to xlsColumn variables

The following properties can be used to handle xlsColumn variables:
NameType usedEffect
CellArray of xlsCellCells of the column.
DefaultCellxlsCellThe default style of the column will correspond to the style of the specified cell.
WidthRealWidth of column in pixels (between 0 and 1789 pixels). If this property is initialized to -1, the default width of the columns in the Excel document will be used.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/06/2024

Send a report | Local help