<xlsDocument variable>.AddWorksheet (Function) Adds or inserts a new worksheet into an Excel document. <xlsDocument variable>.Close (Function) Closes an XLS file. <xlsDocument variable>.DeleteWorksheet (Function) Deletes a worksheet from the Excel document. <xlsDocument variable>.GetMerge (Function) Determines if a cell is merged with other cells and gets the merged cell range. <xlsDocument variable>.MergeCell (Function) Merges the specified cells in an Excel document. <xlsDocument variable>.RecalculateAll (Function) Recalculates all formulas in an Excel (XLSX) document. <xlsDocument variable>.Save (Function) Saves an XLS document. <xlsDocument variable>.UnmergeCell (Function) Unmerges a given cell. Handling XLS files WINDEV and WEBDEV propose two methods for handling Excel files... Handling XLS files (prefix syntax) WINDEV and WEBDEV propose two methods for handling Excel files... Type XLSCell: MaskWD property The MaskWD property of the xlsDocument type is used to define the display mask in WINDEV or WEBDEV format that will be used in the Excel cell ("DD/MM/YYYY" for example)... XLS file constants List of constants used by the functions for managing XLS files. XLS file functions List of functions for managing XLS files XLS file functions (prefix syntax) XLS file functions xlsAddWorksheet (Function) Adds or inserts a new worksheet into an Excel document. xlsCell (Variable type) An xlsCell variable is used to describe and modify a cell in an Excel document... xlsClose (Example) Usage example of the xlsClose function xlsClose (Function) Closes an XLS file. xlsColumn (Variable type) The xlsColumn type is used to describe and modify a column in an Excel document... xlsColumnTitle (Example) Usage example of the xlsColumnTitle function xlsColumnTitle (Function) Retrieves the title of a column found in an XLS file. xlsColumnType (Example) Usage example of the xlsColumnType function xlsColumnType (Function) Returns the type of data entered in a column of an XLS file. xlsComment (Variable type) The xlsComment type is used to defined all the advanced characteristics of a comment in a cell of an XLS file or Spreadsheet control. xlsCoordinatesToName (Function) Retrieves the name of a cell, XLS worksheet or Spreadsheet control according to its coordinates. xlsCurrentWorksheet (Function) Used to find out and modify the current worksheet in an XLS file. xlsData (Example) Usage example of the xlsData function xlsData (Function) Retrieves the content of a cell found in an XLS file. xlsDeleteWorksheet (Function) Deletes a worksheet from the Excel document. xlsDocument (Example) Usage example of the xlsDocument type xlsDocument (Variable type) An xlsDocument variable is used to describe and modify an Excel document... xlsGetMerge (Function) Determines if a cell is merged with other cells and gets the merged cell range. xlsLayout (Variable type) The xlsLayout type is used to define all the layout characteristics of a sheet of an XLSX document in a Spreadsheet control. xlsMergeCell (Function) Merges the specified cells in an Excel document. xlsMsgError (Example) Usage example of the xlsMsgError function xlsMsgError (Function) Returns the caption of the last error caused by an XLS function. xlsNameToCoordinates (Function) Returns the coordinates of a cell, XLS file or spreadsheet control according to its name. xlsNbColumn (Example) Usage example of the xlsNbColumn function xlsNbColumn (Function) Returns the number of columns found in a worksheet of an XLS file. xlsNbColumns (Function) xlsNbColumns is kept for backward compatibility only. xlsNbRow (Example) Usage example of the xlsNbRow function xlsNbRow (Function) Returns the number of rows found in an XLS file. xlsNbRows (Function) xlsNbRows is kept for backward compatibility only. xlsNbWorksheet (Function) Returns the number of worksheets found in an XLS file. xlsOpen (Example) Usage example of the xlsOpen function xlsOpen (Function) Opens an Excel file (xls or xlsx files). xlsRecalculateAll (Function) Recalculates all formulas in an Excel (XLSX) document. xlsRow (Variable type) The xlsRow variable type defines and changes the characteristics of a row in an Excel document... xlsSave (Function) Saves an XLS document. xlsUnmergeCell (Function) Unmerges a range of cells. xlsVersion (Example) Usage example of the xlsVersion function xlsVersion (Function) Returns the Excel version that was used to save the file.