Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
12.0
12.1
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
Statistic
FMM
Blog
Component: XL
Read and Write Excel files.
You can import or export data from/to XML files in old (xls) or new format (xlsx).
Requires LibXL License (not included in MBS Plugin license)
Version | macOS | Windows | Linux | Server | iOS SDK |
2.9 / 13.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Item | Details |
---|---|
XL.Book.AddCustomNumFormat Adds a new custom number format to the workbook. | All 3.5 |
XL.Book.AddFont Adds a new font to the workbook, initial parameters can be copied from other font. | All 3.5 |
XL.Book.AddFontFromBook Copies a font definition. | All 11.2 |
XL.Book.AddFormat Adds a new format to the workbook, initial parameters can be copied from other format. | All 3.5 |
XL.Book.AddFormatFromBook Copies a format definition. | All 11.2 |
XL.Book.AddPictureContainer Adds a picture to the workbook from container. | All 3.5 |
XL.Book.AddPictureFile Adds a picture to the workbook. | All 3.5 |
XL.Book.AddSheet Adds a new sheet to this book, returns the sheet index. | All 3.5 |
XL.Book.BiffVersion Returns BIFF version of binary file. | All 3.5 |
XL.Book.CustomNumFormat Returns a custom format string for specified custom format identifier fmt. | All 3.5 |
XL.Book.DeleteSheet Deletes a sheet with specified index. | All 3.5 |
XL.Book.DeleteSheetsExcept Deletes all sheets except the one with given name. | All 5.4 |
XL.Book.FontCount Returns a number of fonts in this book. | All 3.5 |
XL.Book.FormatCount Returns a number of formats in this book. | All 3.5 |
XL.Book.GetActiveSheet Returns an active sheet index in this workbook. | All 3.5 |
XL.Book.GetCalcMode Queries current calculation mode. | All 10.2 |
XL.Book.GetDefaultFontName Returns a default font name for this workbook. | All 3.5 |
XL.Book.GetDefaultFontSize Returns a default font size for this workbook. | All 3.5 |
XL.Book.GetPicture Returns a picture at position index. | All 3.5 |
XL.Book.GetPictureType Returns a picture type at position index. | All 3.5 |
XL.Book.GetRGBMode Returns whether the RGB mode is active. | All 3.5 |
XL.Book.GetRefR1C1 Returns whether the R1C1 reference mode is active. | All 3.5 |
XL.Book.GetText Queries the text of a workbook. | All 3.5 |
XL.Book.InsertSheet Inserts a new sheet to this book at position index, returns the new sheet index. | All 3.5 |
XL.Book.IsDate1904 Returns whether the 1904 date system is active. | All 7.2 |
XL.Book.IsTemplate Returns whether the workbook is template. | All 7.2 |
XL.Book.IsWriteProtected Queries whether the workbook is marked as read-only. | All 13.1 |
XL.Book.MoveSheet Moves a sheet. | All 7.2 |
XL.Book.PictureCount Returns a number of pictures in this workbook. | All 3.5 |
XL.Book.Release Frees a workbook from memory. | All 3.5 |
XL.Book.ReleaseAll Releases all books from memory. | All 10.0 |
XL.Book.Save Writes excel file to container for storing in database. | All 3.5 |
XL.Book.SaveToFile Saves current workbook into xls-file. | All 3.5 |
XL.Book.SetActiveSheet Sets an active sheet index in this workbook. | All 3.5 |
XL.Book.SetCalcMode Sets the current calculation mode. | All 10.2 |
XL.Book.SetDate1904 Sets the date system mode. | All 7.2 |
XL.Book.SetDefaultFont Sets a default font name and size for this workbook. | All 3.5 |
XL.Book.SetRGBMode Sets a RGB mode. | All 3.5 |
XL.Book.SetRefR1C1 Sets the R1C1 reference mode. | All 3.5 |
XL.Book.SetTemplate Sets the template flag. | All 7.2 |
XL.Book.SheetCount Queries how many sheets are part of the workbook. | All 3.5 |
XL.Book.SheetIndexForName Queries sheet index for sheet name. | All 5.4 |
XL.Book.Sheets Queries list of sheet names. | All 5.4 |
XL.Book.Version Queries version of XL library. | All 7.2 |
XL.Color.Pack Packs red, green and blue components in color type. | All 3.5 |
XL.Color.UnPack Unpacks color type to red, green and blue components. | All 3.5 |
XL.CopyCellValue Copies one cell. | All 11.2 |
XL.CopyColumn Copies cells from one column to another column. | All 10.5 |
XL.CopyContent Copies all content from one book to other book. | All 5.1 |
XL.CopyRow Copies cells from one row to another row. | All 6.5 |
XL.CopySheet Copies a sheet to another book. | All 6.5 |
XL.Date.DoubleToTimeStamp Converts a timestamp number to a timestamp value. | All 5.0 |
XL.Date.Pack Packs date and time information into double type. | All 3.5 |
XL.Date.TimeStampToDouble Converts a date to a numeric value for writing in a number cell. | All 5.0 |
XL.Date.UnPack Unpacks date and time information from double type. | All 3.5 |
XL.Font.GetBold Returns whether the font is bold. | All 3.5 |
XL.Font.GetColor Returns the color of the font. | All 3.5 |
XL.Font.GetItalic Returns whether the font is italic. | All 3.5 |
XL.Font.GetName Returns the name of the font. | All 3.5 |
XL.Font.GetScript Returns the script style of the font. | All 3.5 |
XL.Font.GetSize Returns the size of the font in points. | All 3.5 |
XL.Font.GetStrikeOut Returns whether the font is strikeout. | All 3.5 |
XL.Font.GetUnderline Returns the underline style of the font. | All 3.5 |
XL.Font.SetBold Turns on/off the bold font. | All 3.5 |
XL.Font.SetColor Sets the color of the font. | All 3.5 |
XL.Font.SetItalic Turns on/off the italic font. | All 3.5 |
XL.Font.SetName Sets the name of the font. | All 3.5 |
XL.Font.SetScript Sets the script style of the font. | All 3.5 |
XL.Font.SetSize Sets the size of the font in points. | All 3.5 |
XL.Font.SetStrikeOut Turns on/off the strikeout font. | All 3.5 |
XL.Font.SetUnderline Sets the underline style of the font. | All 3.5 |
XL.FormControl.AddItem Adds the item to a list box or drop-down form control. | All 13.1 |
XL.FormControl.AltText Returns alternative text for the object. | All 13.1 |
XL.FormControl.ClearItems Clears all items from a list box or drop-down form control. | All 13.1 |
XL.FormControl.DefaultSize Returns whether the object is at its default size. | All 13.1 |
XL.FormControl.Disabled Returns whether the object is allowed to run an attached macro. | All 13.1 |
XL.FormControl.GetChecked Queries the check state. | All 13.1 |
XL.FormControl.GetDropLines Returns the number of lines in the drop-down before scroll bars are added. | All 13.1 |
XL.FormControl.GetDx Returns the width of the scroll bar in pixels. | All 13.1 |
XL.FormControl.GetFirstButton Returns whether the object is the first button in a set of radio buttons. | All 13.1 |
XL.FormControl.GetFmlaGroup Queries group name. | All 13.1 |
XL.FormControl.GetFmlaLink Returns the cell reference is linked to. | All 13.1 |
XL.FormControl.GetFmlaRange Returns the cell reference with range of source data cells. | All 13.1 |
XL.FormControl.GetFmlaTxbx Queries the source for the control. | All 13.1 |
XL.FormControl.GetFromAnchor Returns the bottom right location of a control within a document. | All 13.1 |
XL.FormControl.GetHoriz Returns whether the scroll bar is horizontal. | All 13.1 |
XL.FormControl.GetInc Queries increment. | All 13.1 |
XL.FormControl.GetMax Queries maximum value. | All 13.1 |
XL.FormControl.GetMin Queries minimum value. | All 13.1 |
XL.FormControl.GetMultiSel Returns the indices of selected items as a comma-delimited list. | All 13.1 |
XL.FormControl.GetSet Queries the index of the selected item. | All 13.1 |
XL.FormControl.GetToAnchor Returns the top left location of a control within a document. | All 13.1 |
XL.FormControl.InsertItem Inserts the item to the specified position to a list box or drop-down form control. | All 13.1 |
XL.FormControl.Item Returns the item by index from a list box or drop-down form control. | All 13.1 |
XL.FormControl.ItemCount Returns the number of items in a list box or drop-down form control. | All 13.1 |
XL.FormControl.LinkedCell Returns the worksheet range linked to the control's value. | All 13.1 |
XL.FormControl.ListFillRange Returns the range of source data cells used to populate the list box. | All 13.1 |
XL.FormControl.Locked Returns whether the object is locked when the sheet is protected. | All 13.1 |
XL.FormControl.Macro Returns the custom function associated with the object. | All 13.1 |
XL.FormControl.Name Returns the name for this embedded control. | All 13.1 |
XL.FormControl.ObjectType Returns the form control object type. | All 13.1 |
XL.FormControl.Print Returns whether the object is printed when the document is printed. | All 13.1 |
XL.FormControl.SetChecked Sets the check state. | All 13.1 |
XL.FormControl.SetDropLines Sets the number of lines in the drop-down before scroll bars are added. | All 13.1 |
XL.FormControl.SetDx Sets the width of the scroll bar in pixels. | All 13.1 |
XL.FormControl.SetFirstButton Sets whether the object is the first button in a set of radio buttons. | All 13.1 |
XL.FormControl.SetFmlaGroup Sets the cell reference in a group box is linked to. | All 13.1 |
XL.FormControl.SetFmlaLink Sets the cell reference is linked to. | All 13.1 |
XL.FormControl.SetFmlaRange Sets the cell reference with range of source data cells. | All 13.1 |
XL.FormControl.SetFmlaTxbx Sets the source. | All 13.1 |
XL.FormControl.SetHoriz Sets whether the scroll bar is horizontal. | All 13.1 |
XL.FormControl.SetInc Sets increment. | All 13.1 |
XL.FormControl.SetMax Sets the maximum. | All 13.1 |
XL.FormControl.SetMin Sets the minimum. | All 13.1 |
XL.FormControl.SetMultiSel Sets the indices of selected items as a comma-delimited list. | All 13.1 |
XL.FormControl.SetSel Sets the index of the selected item. | All 13.1 |
XL.Format.GetAlignH Returns the horizontal alignment. | All 3.5 |
XL.Format.GetAlignV Returns the vertical alignment. | All 3.5 |
XL.Format.GetBorderBottom Returns the bottom border style. | All 3.5 |
XL.Format.GetBorderBottomColor Returns the color of the bottom border. | All 3.5 |
XL.Format.GetBorderDiagonal Returns the diagonal border. | All 3.5 |
XL.Format.GetBorderDiagonalColor Returns the color of the diagonal border. | All 3.5 |
XL.Format.GetBorderDiagonalStyle Gets the style for diagonal border. | All 3.5 |
XL.Format.GetBorderLeft Returns the left border style. | All 3.5 |
XL.Format.GetBorderLeftColor Returns the color of the left border. | All 3.5 |
XL.Format.GetBorderRight Returns the right border style. | All 3.5 |
XL.Format.GetBorderRightColor Returns the color of the right border. | All 3.5 |
XL.Format.GetBorderTop Returns the top border style. | All 3.5 |
XL.Format.GetBorderTopColor Returns the color of the top border. | All 3.5 |
XL.Format.GetFillPattern Returns the fill pattern. | All 3.5 |
XL.Format.GetFont Returns the font for this format. | All 3.5 |
XL.Format.GetHidden Returns whether the hidden property is set to true. | All 3.5 |
XL.Format.GetIndent Returns the text indentation level. | All 3.5 |
XL.Format.GetLocked Returns whether the locked property is set to true. | All 3.5 |
XL.Format.GetNumFormat Returns the number format identifier. | All 3.5 |
XL.Format.GetPatternBackgroundColor Returns the background color of the fill pattern. | All 3.5 |
XL.Format.GetPatternForegroundColor Returns the foreground color of the fill pattern. | All 3.5 |
XL.Format.GetRotation Returns the text rotation. | All 3.5 |
XL.Format.GetShrinkToFit Returns whether the cell is shrink-to-fit. | All 3.5 |
XL.Format.GetWrap Returns whether the cell text is wrapped. | All 3.5 |
XL.Format.SetAlignH Sets the horizontal alignment. | All 3.5 |
XL.Format.SetAlignV Sets the vertical alignment. | All 3.5 |
XL.Format.SetBorder Sets the border style. | All 3.5 |
XL.Format.SetBorderBottom Sets the bottom border style. | All 3.5 |
XL.Format.SetBorderBottomColor Sets the color of the bottom border. | All 3.5 |
XL.Format.SetBorderColor Sets the border color. | All 3.5 |
XL.Format.SetBorderDiagonal Sets the diagonal border. | All 3.5 |
XL.Format.SetBorderDiagonalColor Sets the color of the diagonal border. | All 3.5 |
XL.Format.SetBorderDiagonalStyle Sets the style for diagonal border. | All 3.5 |
XL.Format.SetBorderLeft Sets the left border style. | All 3.5 |
XL.Format.SetBorderLeftColor Sets the color of the left border. | All 3.5 |
XL.Format.SetBorderRight Sets the right border style. | All 3.5 |
XL.Format.SetBorderRightColor Sets the color of the right border. | All 3.5 |
XL.Format.SetBorderTop Sets the top border style. | All 3.5 |
XL.Format.SetBorderTopColor Sets the color of the top border. | All 3.5 |
XL.Format.SetFillPattern Sets the fill pattern. | All 3.5 |
XL.Format.SetFont Sets the font for the format. | All 3.5 |
XL.Format.SetHidden Sets the hidden property. | All 3.5 |
XL.Format.SetIndent Sets the text indentation level. | All 3.5 |
XL.Format.SetLocked Sets the locked property. | All 3.5 |
XL.Format.SetNumFormat Sets the number format identifier. | All 3.5 |
XL.Format.SetPatternBackgroundColor Sets the background color of the fill pattern. | All 3.5 |
XL.Format.SetPatternForegroundColor Sets the foreground color of the fill pattern. | All 3.5 |
XL.Format.SetRotation Sets the text rotation. | All 3.5 |
XL.Format.SetShrinkToFit Sets the flag whether the cell is shrink-to-fit. | All 3.5 |
XL.Format.SetWrap Sets the flag whether the cell text is wrapped. | All 3.5 |
XL.Initialize Initializes the XL library by loading it. | All 2.9 |
XL.IsInitialized Checks if libXL library has been initialized. | All 4.2 |
XL.List Lists all IDs of current XL books. | All 13.0 |
XL.LoadBook Loads a Excel file. | All 2.9 |
XL.LoadBookPartially Loads a Excel file partially. | All 8.0 |
XL.NewBook Creates a new workbook in memory. | All 2.9 |
XL.Sheet.AddDataValidation Adds a data validation for the specified range. | All 10.5 |
XL.Sheet.AddHyperlink Adds the new hyperlink. | All 4.3 |
XL.Sheet.AddIgnoredError Adds the ignored error for specified range. | All 7.2 |
XL.Sheet.AddSelectionRange Adds a range to the selection. | All 13.1 |
XL.Sheet.AddrToRowCol Converts a cell reference to row and column. | All 3.5 |
XL.Sheet.ApplyFilter Applies the AutoFilter to the sheet. | All 7.2 |
XL.Sheet.AreCellsEmpty New in 13.2 Checks whether the cells in the given range are empty. | All 13.2 |
XL.Sheet.AutoFilter Initializes the AutoFilter. | All 7.2 |
XL.Sheet.AutoFilter.AddFilter Adds the filter value. | All 7.3 |
XL.Sheet.AutoFilter.AddSort Adds the sorted column in AutoFilter by zero-based index and its sort order. | All 11.5 |
XL.Sheet.AutoFilter.Clear Clear the filter criteria. | All 7.3 |
XL.Sheet.AutoFilter.ColumnSize Returns the number of specified AutoFilter columns which have a filter information. | All 7.2 |
XL.Sheet.AutoFilter.Filter Returns the filter value by index. | All 7.3 |
XL.Sheet.AutoFilter.FilterSize Returns the number of filter values. | All 7.3 |
XL.Sheet.AutoFilter.FilterType Returns the filter type of this AutoFilter column. | All 7.3 |
XL.Sheet.AutoFilter.GetCustomFilter Gets the custom filter criteria. | All 7.3 |
XL.Sheet.AutoFilter.GetRef Gets the cell range of AutoFilter with header. | All 7.2 |
XL.Sheet.AutoFilter.GetSort Gets the zero-based index of sorted column in AutoFilter and its sort order. | All 7.2 |
XL.Sheet.AutoFilter.GetSortRange Gets the whole range of data to sort. | All 7.2 |
XL.Sheet.AutoFilter.GetTop10 Gets the number of top or bottom items. | All 7.3 |
XL.Sheet.AutoFilter.SetCustomFilter Sets the custom filter criteria. | All 7.3 |
XL.Sheet.AutoFilter.SetRef Sets the cell range of AutoFilter with header. | All 7.2 |
XL.Sheet.AutoFilter.SetSort Sets the sorted column in AutoFilter by zero-based index and its sort order. | All 7.2 |
XL.Sheet.AutoFilter.SetTop10 Sets the number of top or bottom items. | All 7.3 |
XL.Sheet.CellIsDate Checks that cell contains a date or time value. | All 3.5 |
XL.Sheet.CellIsFormula Checks that cell contains a formula. | All 3.5 |
XL.Sheet.CellIsStyledText Queries whether cell has styled text. | All 10.2 |
XL.Sheet.CellReadBlank Checks if cell is blank. | All 3.5 |
XL.Sheet.CellReadBoolean Reads a boolean value from a cell. | All 3.5 |
XL.Sheet.CellReadBooleans Reads all the boolean values in an area. | All 8.0 |
XL.Sheet.CellReadComment Reads a comment value from a cell. | All 3.5 |
XL.Sheet.CellReadComments Reads all the comments from cells in an area. | All 8.0 |
XL.Sheet.CellReadDate Reads a number value from a cell. | All 5.0 |
XL.Sheet.CellReadDates Reads all the dates from cells in an area. | All 8.0 |
XL.Sheet.CellReadFormula Reads the formula value from a cell. | All 3.5 |
XL.Sheet.CellReadFormulas Reads all the formulas from cells in an area. | All 8.0 |
XL.Sheet.CellReadNumber Reads a number value from a cell. | All 3.5 |
XL.Sheet.CellReadNumbers Reads all the numbers from cells in an area. | All 8.0 |
XL.Sheet.CellReadStyledText Reads a styled text value from a cell. | All 10.2 |
XL.Sheet.CellReadText Reads a text value from a cell. | All 3.5 |
XL.Sheet.CellReadTexts Reads all the texts from cells in an area. | All 8.0 |
XL.Sheet.CellReadValue Reads a value value from a cell. | All 10.5 |
XL.Sheet.CellReadValues Reads all the values from cells in an area. | All 11.5 |
XL.Sheet.CellType Queries type of cell. | All 3.5 |
XL.Sheet.CellWriteBlank Writes a blank cell. | All 3.5 |
XL.Sheet.CellWriteBlanks Writes blanks to an area of cells. | All 8.0 |
XL.Sheet.CellWriteBoolean Writes a boolean value into cell. | All 3.5 |
XL.Sheet.CellWriteBooleans Writes booleans to an area of cells. | All 8.0 |
XL.Sheet.CellWriteComment Writes a comment to a cell. | All 3.5 |
XL.Sheet.CellWriteComments Writes comments to an area of cells. | All 8.0 |
XL.Sheet.CellWriteDate Writes a number into cell. | All 5.0 |
XL.Sheet.CellWriteDates Writes dates to an area of cells. | All 8.0 |
XL.Sheet.CellWriteError Writes error into the cell with specified format. | All 7.2 |
XL.Sheet.CellWriteFormula Writes a formula into cell. | All 3.5 |
XL.Sheet.CellWriteFormulaBoolean Writes a formula and value in a cell. | All 6.5 |
XL.Sheet.CellWriteFormulaNumber Writes a formula and value in a cell. | All 6.5 |
XL.Sheet.CellWriteFormulaText Writes a formula and value in a cell. | All 6.5 |
XL.Sheet.CellWriteFormulas Writes formulas to an area of cells. | All 8.0 |
XL.Sheet.CellWriteMatrix New in 13.3 Writes cell values from matrix. | All 13.3 |
XL.Sheet.CellWriteNumber Writes a number into cell. | All 3.5 |
XL.Sheet.CellWriteNumbers Writes numbers to an area of cells. | All 8.0 |
XL.Sheet.CellWriteStyledText Writes a styled text into a cell. | All 10.2 |
XL.Sheet.CellWriteText Writes a string into cell. | All 3.5 |
XL.Sheet.CellWriteTextAsNumber Writes a number into cell, but passes it as text. | All 10.3 |
XL.Sheet.CellWriteTexts Writes texts to an area of cells. | All 8.0 |
XL.Sheet.Clear Clears cells in specified area. | All 3.5 |
XL.Sheet.ClearPrintArea Clears the print area. | All 3.5 |
XL.Sheet.ClearPrintRepeats Clears repeated rows and columns on each page. | All 3.5 |
XL.Sheet.CopyCell Copies cell with format from (rowSrc, colSrc) to (rowDst, colDst). | All 3.5 |
XL.Sheet.DefaultRowHeight Returns the default row height measured in point size. | All 13.1 |
XL.Sheet.DelHyperlink Removes hyperlink by index. | All 4.3 |
XL.Sheet.DelMergeByIndex Removes merged cells by index. | All 4.3 |
XL.Sheet.DeleteMerge Removes merged cells. | All 3.5 |
XL.Sheet.DeleteNamedRange Deletes the named range by name. | All 3.5 |
XL.Sheet.FormControlCount Queries number of form controls. | All 13.1 |
XL.Sheet.GetActiveCell Gets an active cell of the sheet. | All 13.1 |
XL.Sheet.GetCellError Reads error from cell. | All 3.5 |
XL.Sheet.GetCellErrors Reads all the errors from cells in an area. | All 8.0 |
XL.Sheet.GetCellFormat Returns cell's format. | All 3.5 |
XL.Sheet.GetCellFormats Reads all the formats from cells in an area. | All 8.0 |
XL.Sheet.GetCellPicture Queries picture for a cell. | All 11.5 |
XL.Sheet.GetColHidden Returns whether column is hidden. | All 3.5 |
XL.Sheet.GetColWidth Returns column width in points. | All 3.5 |
XL.Sheet.GetColWidthPixel Returns column width in pixel. | All 10.2 |
XL.Sheet.GetDisplayGridlines Returns whether the gridlines are displayed. | All 3.5 |
XL.Sheet.GetFirstCol Returns the first column in the sheet that contains a used cell. | All 3.5 |
XL.Sheet.GetFirstFilledCol Returns the first column in the sheet that contains a filled cell. | All 10.3 |
XL.Sheet.GetFirstFilledRow Returns the first row in the sheet that contains a filled cell. | All 10.3 |
XL.Sheet.GetFirstRow Returns the first row in the sheet that contains a used cell. | All 3.5 |
XL.Sheet.GetFooter Returns the footer text of the sheet when printed. | All 3.5 |
XL.Sheet.GetFooterMargin Returns the footer margin in inches. | All 3.5 |
XL.Sheet.GetGroupSummaryBelow Returns whether grouping rows summary is below. | All 3.5 |
XL.Sheet.GetGroupSummaryRight Returns whether grouping columns summary is right. | All 3.5 |
XL.Sheet.GetHCenter Returns whether the sheet is centered horizontally when printed. | All 3.5 |
XL.Sheet.GetHeader Returns the header text of the sheet when printed. | All 3.5 |
XL.Sheet.GetHeaderMargin Returns the header margin in inches. | All 3.5 |
XL.Sheet.GetHidden Returns whether sheet is hidden. | All 3.5 |
XL.Sheet.GetHorPageBreak Returns row with horizontal page break at position index. | All 3.5 |
XL.Sheet.GetHorPageBreakCount Returns a number of horizontal page breaks in the sheet. | All 3.5 |
XL.Sheet.GetLandscape Returns a page orientation mode. | All 3.5 |
XL.Sheet.GetLastCol Returns the zero-based index of the column after the last column in the sheet that contains a used cell. | All 3.5 |
XL.Sheet.GetLastFilledCol Returns the zero-based index of the column after the last column in the sheet that contains a filled cell. | All 10.3 |
XL.Sheet.GetLastFilledRow Returns the zero-based index of the row after the last row in the sheet that contains a filled cell. | All 10.3 |
XL.Sheet.GetLastRow Returns the zero-based index of the row after the last row in the sheet that contains a used cell. | All 3.5 |
XL.Sheet.GetMarginBottom Returns the bottom margin of the sheet in inches. | All 3.5 |
XL.Sheet.GetMarginLeft Returns the left margin of the sheet in inches. | All 3.5 |
XL.Sheet.GetMarginRight Returns the right margin of the sheet in inches. | All 3.5 |
XL.Sheet.GetMarginTop Returns the top margin of the sheet in inches. | All 3.5 |
XL.Sheet.GetMerge Gets merged cells for cell at row, col. | All 3.5 |
XL.Sheet.GetName Returns the name of the sheet. | All 3.5 |
XL.Sheet.GetNamedRange Gets the named range coordianates by name. | All 3.5 |
XL.Sheet.GetPaper Returns the paper size. | All 3.5 |
XL.Sheet.GetPicture Returns a workbook picture index at position index in worksheet. | All 3.5 |
XL.Sheet.GetPrintArea Gets the print area. | All 5.1 |
XL.Sheet.GetPrintFit Returns whether fit to page option is enabled. | All 3.5 |
XL.Sheet.GetPrintGridlines Returns whether the gridlines are printed. | All 3.5 |
XL.Sheet.GetPrintRepeatCols Gets repeated columns on each page from colFirst to colLast. | All 5.1 |
XL.Sheet.GetPrintRepeatRows Gets repeated rows on each page from rowFirst to rowLast. | All 5.1 |
XL.Sheet.GetPrintRow Returns whether the row and column headers are printed. | All 3.5 |
XL.Sheet.GetPrintZoom Returns the scaling factor for printing as a percentage. | All 3.5 |
XL.Sheet.GetProtect Returns whether sheet is protected. | All 3.5 |
XL.Sheet.GetRowHeight Returns row height in points. | All 3.5 |
XL.Sheet.GetRowHeightPixel Returns row height in pixels. | All 10.2 |
XL.Sheet.GetRowHidden Returns whether row is hidden. | All 3.5 |
XL.Sheet.GetTabColor Queries the sheet's tab color. | All 13.1 |
XL.Sheet.GetTabColorRGB Queries the sheet's tab RGB color. | All 13.1 |
XL.Sheet.GetText Queries the text of a sheet in a workbook. | All 3.5 |
XL.Sheet.GetTopLeftView Extracts the first visible row and the leftmost visible column of the sheet. | All 3.5 |
XL.Sheet.GetVCenter Returns whether the sheet is centered vertically when printed. | All 3.5 |
XL.Sheet.GetVerPageBreak Returns column with vertical page break at position index. | All 3.5 |
XL.Sheet.GetVerPageBreakCount Returns a number of vertical page breaks in the sheet. | All 3.5 |
XL.Sheet.GetZoom Returns the zoom level of the current view as a percentage. | All 3.5 |
XL.Sheet.GroupCols Groups columns from colFirst to colLast. | All 3.5 |
XL.Sheet.GroupRows Groups rows from rowFirst to rowLast. | All 3.5 |
XL.Sheet.Hyperlink Gets the hyperlink and its coordianates by index. | All 4.3 |
XL.Sheet.HyperlinkIndex New in 13.2 Checks if the cell contains a hyperlink. | All 13.2 |
XL.Sheet.HyperlinkSize Returns the number of hyperlinks in the sheet. | All 4.3 |
XL.Sheet.InsertCol Inserts columns from colFirst to colLast. | All 3.5 |
XL.Sheet.InsertRow Inserts rows from rowFirst to rowLast. | All 3.5 |
XL.Sheet.IsAutoFilter Whether this sheet has an auto filter. | All 11.5 |
XL.Sheet.Merge Gets the merged cells by index. | All 4.3 |
XL.Sheet.MergeSize Returns a number of merged cells in this worksheet. | All 4.3 |
XL.Sheet.NamedRange Gets the named range coordinates by index. | All 3.5 |
XL.Sheet.NamedRangeCount Returns the number of named ranges in the sheet. | All 3.5 |
XL.Sheet.PictureCount Returns a number of pictures in this worksheet. | All 3.5 |
XL.Sheet.ReadCellsAsMatrix Reads all the values from cells in an area into a new matrix. | All 13.0 |
XL.Sheet.RemoveCol Removes columns from colFirst to colLast. | All 3.5 |
XL.Sheet.RemoveComment Removes a comment from a cell. | All 6.5 |
XL.Sheet.RemoveComments Removes comments in given area. | All 8.0 |
XL.Sheet.RemoveDataValidations Removes all data validations for the sheet. | All 10.5 |
XL.Sheet.RemoveFilter Removes the AutoFilter from the sheet. | All 7.2 |
XL.Sheet.RemovePicture Removes a picture from a cell. | All 10.2 |
XL.Sheet.RemovePictureByIndex Removes a picture by index. | All 10.2 |
XL.Sheet.RemoveRow Removes rows from rowFirst to rowLast. | All 3.5 |
XL.Sheet.RemoveSelection Removes all selection. | All 13.1 |
XL.Sheet.RightToLeft Returns whether the text is displayed in right-to-left mode. | All 7.2 |
XL.Sheet.RowColToAddr Converts row and column to a cell reference. | All 3.5 |
XL.Sheet.SelectionRange Returns a range of the selection. | All 13.1 |
XL.Sheet.SetActiveCell Sets an active cell of the sheet. | All 13.1 |
XL.Sheet.SetAutoFitArea Sets the borders for autofit column widths feature. | All 5.1 |
XL.Sheet.SetCellFormat Sets cell's format. | All 3.5 |
XL.Sheet.SetCellFormats Set cell formats in given area. | All 8.0 |
XL.Sheet.SetCol Sets column width and format for all columns from colFirst to colLast. | All 3.5 |
XL.Sheet.SetColHidden Hides or shows a column. | All 3.5 |
XL.Sheet.SetColumn Sets column width and format for all columns from colFirst to colLast. | All 3.5 |
XL.Sheet.SetDefaultRowHeight Sets the default row height measured in point size. | All 13.1 |
XL.Sheet.SetDisplayGridlines Sets gridlines for displaying. | All 3.5 |
XL.Sheet.SetFooter Sets the footer text for the sheet when printed. | All 3.5 |
XL.Sheet.SetGroupSummaryBelow Sets a flag of grouping rows summary. | All 3.5 |
XL.Sheet.SetGroupSummaryRight Sets a flag of grouping rows summary. | All 3.5 |
XL.Sheet.SetHCenter Sets a flag that the sheet is centered horizontally when printed. | All 3.5 |
XL.Sheet.SetHeader Sets the header text of the sheet when printed. | All 3.5 |
XL.Sheet.SetHorPageBreak Sets/removes a horizontal page break. | All 3.5 |
XL.Sheet.SetLandscape Sets landscape or portrait mode for printing. | All 3.5 |
XL.Sheet.SetMarginBottom Sets the bottom margin of the sheet in inches. | All 3.5 |
XL.Sheet.SetMarginLeft Sets the left margin of the sheet in inches. | All 3.5 |
XL.Sheet.SetMarginRight Sets the right margin of the sheet in inches. | All 3.5 |
XL.Sheet.SetMarginTop Sets the top margin of the sheet in inches. | All 3.5 |
XL.Sheet.SetMerge Sets merged cells for range: rowFirst - rowLast, colFirst - colLast. | All 3.5 |
XL.Sheet.SetName Sets the name of the sheet. | All 3.5 |
XL.Sheet.SetNamedRange Sets the named range. | All 3.5 |
XL.Sheet.SetPaper Sets the paper size. | All 3.5 |
XL.Sheet.SetPictureWithScale Sets a picture with pictureId identifier at position row and col with scale factor and offsets in pixels. | All 3.5 |
XL.Sheet.SetPictureWithSize Sets a picture with pictureId identifier at position row and col with custom size and offsets in pixels. | All 3.5 |
XL.Sheet.SetPrintArea Sets the print area. | All 3.5 |
XL.Sheet.SetPrintFit Fits sheet width and sheet height to wPages and hPages respectively. | All 3.5 |
XL.Sheet.SetPrintGridliens Sets gridlines for printing. | All 3.5 |
XL.Sheet.SetPrintRepeatCols Sets repeated columns on each page from colFirst to colLast. | All 3.5 |
XL.Sheet.SetPrintRepeatRows Sets repeated rows on each page from rowFirst to rowLast. | All 3.5 |
XL.Sheet.SetPrintRow Sets a flag that the row and column headers are printed. | All 3.5 |
XL.Sheet.SetPrintZoom Sets the scaling factor for printing as a percentage. | All 3.5 |
XL.Sheet.SetProtect Protects/unprotects the sheet. | All 3.5 |
XL.Sheet.SetProtectEx Protects/unprotects the sheet with password and enhanced parameters below. | All 7.2 |
XL.Sheet.SetRightToLeft Sets the right-to-left mode: Pass 1 and the text is displayed in right-to-left mode, Pass 0 and the text is displayed in left-to-right mode. | All 7.2 |
XL.Sheet.SetRow Sets row height and format. | All 3.5 |
XL.Sheet.SetRowHidden Hides or shows a row. | All 3.5 |
XL.Sheet.SetRows Sets row height and format for multiple rows. | All 11.2 |
XL.Sheet.SetTabColor Sets the color for the sheet's tab. | All 7.2 |
XL.Sheet.SetTabColorRGB Sets the RGB color for the sheet's tab. | All 7.2 |
XL.Sheet.SetTopLeftView Sets the first visible row and the leftmost visible column of the sheet. | All 3.5 |
XL.Sheet.SetVCenter ets a flag that the sheet is centered vertically when printed. | All 3.5 |
XL.Sheet.SetVerPageBreak Sets/removes a vertical page break. | All 3.5 |
XL.Sheet.SetZoom Sets the zoom level of the current view. | All 3.5 |
XL.Sheet.Split Splits a sheet at position (row, col). | All 3.5 |
XL.Sheet.SplitInfo Gets the split information (position of frozen pane) in the sheet. | All 4.3 |
XL.Sheet.Table Gets the table parameters by index. | All 7.2 |
XL.Sheet.TableSize Returns the number of tables in the sheet. | All 7.2 |
XL.Sheet.Type Returns type of sheet with specified index. | All 7.2 |
XL.Uninitialize Uninitializes XL library. | All 10.1 |
381 functions shown.
These functions require a paid license (86%).
Release notes
- Version 13.2
- Added XL.Sheet.AreCellsEmpty function.
- Added XL.Sheet.HyperlinkIndex function.
- Version 13.1
- Added 45 new functions for XL functions to work on form controls and XL.Sheet.FormControlCount function.
- Added XL.Book.IsWriteProtected, XL.Sheet.DefaultRowHeight, XL.Sheet.GetTabColor, XL.Sheet.GetTabColorRGB and XL.Sheet.SetDefaultRowHeight functions.
- Added XL.Sheet.AddSelectionRange, XL.Sheet.GetActiveCell, XL.Sheet.RemoveSelection, XL.Sheet.SelectionRange and XL.Sheet.SetActiveCell functions.
- Version 13.0
- Added XL.List function.
- Added XL.Sheet.ReadCellsAsMatrix function to copy cell values into a new matrix.
- Fixed a problem with XL.Book.AddSheet function not passing correct name each time.
- Fixed XL.Sheet.SetColumn and XL.Sheet.SetRow to better.
- Version 12.5
- Fixed a but in XL.CopySheet, where it failed if the sheet didn't have a name.
- Fixed XL.Format.SetNumFormat and related functions to not crash if you pass an invalid format number.
- Version 12.2
- Fixed issue with XL.Sheet.CellWriteText to allow you to pass empty value to not change format.
- Version 12.1
- Fixed parameters for XL.Sheet.AutoFilter.SetCustomFilter and XL.Sheet.AutoFilter.GetCustomFilter.
- Version 11.5
- Added XL.Sheet.AutoFilter.AddSort and XL.Sheet.IsAutoFilter functions.
- Added XL.Sheet.CellReadValues function.
- Added XL.Sheet.GetCellPicture function.
- Version 11.2
- Added milliseconds for timestamps in XL functions.
- Added XL.Book.AddFontFromBook and XL.Book.AddFormatFromBook functions.
- Added XL.CopyCellValue function.
- Added XL.Sheet.SetRows function.
- Changed XL.Initialize to accept empty path and pick the file name automatically per platform.
- Version 10.5
- Added XL.CopyColumn function.
- Added XL.Sheet.AddDataValidation and XL.Sheet.RemoveDataValidations functions.
- Added XL.Sheet.CellReadValue function.
Blog Entries
- New in MBS FileMaker Plugin 13.2
- New in MBS FileMaker Plugin 13.1
- MBS Plugin 13.1 for Claris FileMaker
- MBS FileMaker Plugin, version 13.1pr2
- Read And Write Excel Files With FileMaker
- New in version 11.5 of MBS FileMaker Plugin
- MBS FileMaker Plugin, June 2021 News
- MBS FileMaker Plugin 11.2 - More than 6500 Functions In One Plugin
- MBS FileMaker Plugin 10.5 - More than 6400 Functions In One Plugin
- New column names in an Excel document
FileMaker Magazin
Example Databases
