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](newinversion29.md "First functions introduced with version 2.9.") / [16.3](newinversion163.md "Newest functions in version 16.3.") | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

  
| Item | Details |
|:--|:--|
| [XL.Book.AddConditionalFormat](XLBookAddConditionalFormat.md)   Adds a new conditional format to the workbook for using with conditional formatting rules. | All   14.2 |
| [XL.Book.AddCustomNumFormat](XLBookAddCustomNumFormat.md)   Adds a new custom number format to the workbook. | All   3.5 |
| [XL.Book.AddFont](XLBookAddFont.md)   Adds a new font to the workbook, initial parameters can be copied from other font. | All   3.5 |
| [XL.Book.AddFontFromBook](XLBookAddFontFromBook.md)   Copies a font definition. | All   11.2 |
| [XL.Book.AddFormat](XLBookAddFormat.md)   Adds a new format to the workbook, initial parameters can be copied from other format. | All   3.5 |
| [XL.Book.AddFormatFromBook](XLBookAddFormatFromBook.md)   Copies a format definition. | All   11.2 |
| [XL.Book.AddPictureContainer](XLBookAddPictureContainer.md)   Adds a picture to the workbook from container. | All   3.5 |
| [XL.Book.AddPictureFile](XLBookAddPictureFile.md)   Adds a picture to the workbook. | All   3.5 |
| [XL.Book.AddSheet](XLBookAddSheet.md)   Adds a new sheet to this book, returns the sheet index. | All   3.5 |
| [XL.Book.BiffVersion](XLBookBiffVersion.md)   Returns BIFF version of binary file. | All   3.5 |
| [XL.Book.Clear](XLBookClear.md)   Removes all data from a workbook. | All   16.1 |
| [XL.Book.ConditionalFormat](XLBookConditionalFormat.md)   Returns a conditional format with defined index. | All   16.1 |
| [XL.Book.ConditionalFormatSize](XLBookConditionalFormatSize.md)   Returns a number of conditional formats in this book. | All   16.1 |
| [XL.Book.CustomNumFormat](XLBookCustomNumFormat.md)   Returns a custom format string for specified custom format identifier. | All   3.5 |
| [XL.Book.DeleteSheet](XLBookDeleteSheet.md)   Deletes a sheet with specified index. | All   3.5 |
| [XL.Book.DeleteSheetsExcept](XLBookDeleteSheetsExcept.md)   Deletes all sheets except the one with given name. | All   5.4 |
| [XL.Book.ErrorCode](XLBookErrorCode.md)   Queries the last error code. | All   16.1 |
| [XL.Book.FontCount](XLBookFontCount.md)   Returns a number of fonts in this book. | All   3.5 |
| [XL.Book.FormatCount](XLBookFormatCount.md)   Returns a number of formats in this book. | All   3.5 |
| [XL.Book.GetActiveSheet](XLBookGetActiveSheet.md)   Returns an active sheet index in this workbook. | All   3.5 |
| [XL.Book.GetCalcMode](XLBookGetCalcMode.md)   Queries current calculation mode. | All   10.2 |
| [XL.Book.GetCoreProperty](XLBookGetCoreProperty.md)   Queries a property. | All   15.0 |
| [XL.Book.GetDefaultFontName](XLBookGetDefaultFontName.md)   Returns a default font name for this workbook. | All   3.5 |
| [XL.Book.GetDefaultFontSize](XLBookGetDefaultFontSize.md)   Returns a default font size for this workbook. | All   3.5 |
| [XL.Book.GetPicture](XLBookGetPicture.md)   Returns a picture at position index. | All   3.5 |
| [XL.Book.GetPictureType](XLBookGetPictureType.md)   Returns a picture type at position index. | All   3.5 |
| [XL.Book.GetRGBMode](XLBookGetRGBMode.md)   Returns whether the RGB mode is active. | All   3.5 |
| [XL.Book.GetRefR1C1](XLBookGetRefR1C1.md)   Returns whether the R1C1 reference mode is active. | All   3.5 |
| [XL.Book.GetText](XLBookGetText.md)   Queries the text of a workbook. | All   3.5 |
| [XL.Book.InsertSheet](XLBookInsertSheet.md)   Inserts a new sheet to this book at position index, returns the new sheet index. | All   3.5 |
| [XL.Book.IsDate1904](XLBookIsDate1904.md)   Returns whether the 1904 date system is active. | All   7.2 |
| [XL.Book.IsTemplate](XLBookIsTemplate.md)   Returns whether the workbook is template. | All   7.2 |
| [XL.Book.IsWriteProtected](XLBookIsWriteProtected.md)   Queries whether the workbook is marked as read-only. | All   13.1 |
| [XL.Book.MoveSheet](XLBookMoveSheet.md)   Moves a sheet. | All   7.2 |
| [XL.Book.PictureCount](XLBookPictureCount.md)   Returns a number of pictures in this workbook. | All   3.5 |
| [XL.Book.Release](XLBookRelease.md)   Frees a workbook from memory. | All   3.5 |
| [XL.Book.ReleaseAll](XLBookReleaseAll.md)   Releases all books from memory. | All   10.0 |
| [XL.Book.RemoveAllCoreProperties](XLBookRemoveAllCoreProperties.md)   Remove all workbook properties. | All   15.0 |
| [XL.Book.RemoveAllPhonetics](XLBookRemoveAllPhonetics.md)   Removes all phonetics data (furigana) from a workbook. | All   15.0 |
| [XL.Book.RemovePrinterSettings](XLBookRemovePrinterSettings.md)   Removes all printer settings from the workbook. | All   14.4 |
| [XL.Book.RemoveVBA](XLBookRemoveVBA.md)   Removes all VBA scripts (macros) from the workbook. | All   14.4 |
| [XL.Book.Save](XLBookSave.md)   Writes excel file to container for storing in database. | All   3.5 |
| [XL.Book.SaveToFile](XLBookSaveToFile.md)   Saves current workbook into xls-file. | All   3.5 |
| [XL.Book.SetActiveSheet](XLBookSetActiveSheet.md)   Sets an active sheet index in this workbook. | All   3.5 |
| [XL.Book.SetCalcMode](XLBookSetCalcMode.md)   Sets the current calculation mode. | All   10.2 |
| [XL.Book.SetCoreProperty](XLBookSetCoreProperty.md)   Sets a property. | All   15.0 |
| [XL.Book.SetDate1904](XLBookSetDate1904.md)   Sets the date system mode. | All   7.2 |
| [XL.Book.SetDefaultFont](XLBookSetDefaultFont.md)   Sets a default font name and size for this workbook. | All   3.5 |
| [XL.Book.SetRGBMode](XLBookSetRGBMode.md)   Sets a RGB mode. | All   3.5 |
| [XL.Book.SetRefR1C1](XLBookSetRefR1C1.md)   Sets the R1C1 reference mode. | All   3.5 |
| [XL.Book.SetTemplate](XLBookSetTemplate.md)   Sets the template flag. | All   7.2 |
| [XL.Book.SheetCount](XLBookSheetCount.md)   Queries how many sheets are part of the workbook. | All   3.5 |
| [XL.Book.SheetIndexForName](XLBookSheetIndexForName.md)   Queries sheet index for sheet name. | All   5.4 |
| [XL.Book.SheetName](XLBookSheetName.md)   Queries the name of a sheet. | All   16.1 |
| [XL.Book.Sheets](XLBookSheets.md)   Queries list of sheet names. | All   5.4 |
| [XL.Book.Version](XLBookVersion.md)   Queries version of XL library. | All   7.2 |
| [XL.Color.Pack](XLColorPack.md)   Packs red, green and blue components in color type. | All   3.5 |
| [XL.Color.UnPack](XLColorUnPack.md)   Unpacks color type to red, green and blue components. | All   3.5 |
| [XL.ConditionalFormat.Font](XLConditionalFormatFont.md)   Returns the font for this format. | All   14.2 |
| [XL.ConditionalFormat.GetBorderBottom](XLConditionalFormatGetBorderBottom.md)   Returns the bottom border style. | All   14.2 |
| [XL.ConditionalFormat.GetBorderBottomColor](XLConditionalFormatGetBorderBottomColor.md)   Returns the color of the bottom border. | All   14.2 |
| [XL.ConditionalFormat.GetBorderLeft](XLConditionalFormatGetBorderLeft.md)   Returns the left border style. | All   14.2 |
| [XL.ConditionalFormat.GetBorderLeftColor](XLConditionalFormatGetBorderLeftColor.md)   Returns the color of the left border. | All   14.2 |
| [XL.ConditionalFormat.GetBorderRight](XLConditionalFormatGetBorderRight.md)   Returns the right border style. | All   14.2 |
| [XL.ConditionalFormat.GetBorderRightColor](XLConditionalFormatGetBorderRightColor.md)   Returns the color of the right border. | All   14.2 |
| [XL.ConditionalFormat.GetBorderTop](XLConditionalFormatGetBorderTop.md)   Returns the top border style. | All   14.2 |
| [XL.ConditionalFormat.GetBorderTopColor](XLConditionalFormatGetBorderTopColor.md)   Returns the color of the top border. | All   14.2 |
| [XL.ConditionalFormat.GetCustomNumFormat](XLConditionalFormatGetCustomNumFormat.md)   Queries custom format string. | All   14.2 |
| [XL.ConditionalFormat.GetFillPattern](XLConditionalFormatGetFillPattern.md)   Returns the fill pattern. | All   14.2 |
| [XL.ConditionalFormat.GetNumFormat](XLConditionalFormatGetNumFormat.md)   Returns the number format identifier. | All   14.2 |
| [XL.ConditionalFormat.GetPatternBackgroundColor](XLConditionalFormatGetPatternBackgroundColor.md)   Returns the background color of the fill pattern. | All   14.2 |
| [XL.ConditionalFormat.GetPatternForegroundColor](XLConditionalFormatGetPatternForegroundColor.md)   Returns the foreground color of the fill pattern. | All   14.2 |
| [XL.ConditionalFormat.SetBorder](XLConditionalFormatSetBorder.md)   Sets the border style. | All   14.2 |
| [XL.ConditionalFormat.SetBorderBottom](XLConditionalFormatSetBorderBottom.md)   Sets the bottom border style. | All   14.2 |
| [XL.ConditionalFormat.SetBorderBottomColor](XLConditionalFormatSetBorderBottomColor.md)   Sets the color of the bottom border. | All   14.2 |
| [XL.ConditionalFormat.SetBorderColor](XLConditionalFormatSetBorderColor.md)   Sets the border color. | All   14.2 |
| [XL.ConditionalFormat.SetBorderLeft](XLConditionalFormatSetBorderLeft.md)   Sets the left border style. | All   14.2 |
| [XL.ConditionalFormat.SetBorderLeftColor](XLConditionalFormatSetBorderLeftColor.md)   Sets the color of the left border. | All   14.2 |
| [XL.ConditionalFormat.SetBorderRight](XLConditionalFormatSetBorderRight.md)   Sets the right border style. | All   14.2 |
| [XL.ConditionalFormat.SetBorderRightColor](XLConditionalFormatSetBorderRightColor.md)   Sets the color of the right border. | All   14.2 |
| [XL.ConditionalFormat.SetBorderTop](XLConditionalFormatSetBorderTop.md)   Sets the top border style. | All   14.2 |
| [XL.ConditionalFormat.SetBorderTopColor](XLConditionalFormatSetBorderTopColor.md)   Sets the color of the top border. | All   14.2 |
| [XL.ConditionalFormat.SetCustomNumFormat](XLConditionalFormatSetCustomNumFormat.md)   Sets a custom number format. | All   14.2 |
| [XL.ConditionalFormat.SetFillPattern](XLConditionalFormatSetFillPattern.md)   Sets the fill pattern. | All   14.2 |
| [XL.ConditionalFormat.SetNumFormat](XLConditionalFormatSetNumFormat.md)   Sets the number format identifier. | All   14.2 |
| [XL.ConditionalFormat.SetPatternBackgroundColor](XLConditionalFormatSetPatternBackgroundColor.md)   Sets the background color of the fill pattern. | All   14.2 |
| [XL.ConditionalFormat.SetPatternForegroundColor](XLConditionalFormatSetPatternForegroundColor.md)   Sets the foreground color of the fill pattern. | All   14.2 |
| [XL.ConditionalFormating.Add2ColorScaleFormulaRule](XLConditionalFormatingAdd2ColorScaleFormulaRule.md)   Adds a conditional formatting rule that creates a gradated 2-color scale on the cells. | All   14.2 |
| [XL.ConditionalFormating.Add2ColorScaleRule](XLConditionalFormatingAdd2ColorScaleRule.md)   Adds a conditional formatting rule that creates a gradated 2-color scale on the cells. | All   14.2 |
| [XL.ConditionalFormating.Add3ColorScaleFormulaRule](XLConditionalFormatingAdd3ColorScaleFormulaRule.md)   Adds a conditional formatting rule that creates a gradated 3-color scale on the cells. | All   14.2 |
| [XL.ConditionalFormating.Add3ColorScaleRule](XLConditionalFormatingAdd3ColorScaleRule.md)   Adds a conditional formatting rule that creates a gradated 3-color scale on the cells. | All   14.2 |
| [XL.ConditionalFormating.AddAboveAverageRule](XLConditionalFormatingAddAboveAverageRule.md)   Adds a conditional formatting rule that highlights cells that are above or below the average for all values in the range. | All   14.2 |
| [XL.ConditionalFormating.AddOpNumRule](XLConditionalFormatingAddOpNumRule.md)   Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator. | All   14.2 |
| [XL.ConditionalFormating.AddOpStrRule](XLConditionalFormatingAddOpStrRule.md)   Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator. | All   14.2 |
| [XL.ConditionalFormating.AddRange](XLConditionalFormatingAddRange.md)   Adds a range to these conditional formatting rules. | All   14.2 |
| [XL.ConditionalFormating.AddRule](XLConditionalFormatingAddRule.md)   Adds a conditional formatting rule that highlights cells whose values correspond to the specified criteria. | All   14.2 |
| [XL.ConditionalFormating.AddTimePeriodRule](XLConditionalFormatingAddTimePeriodRule.md)   Adds a conditional formatting rule that highlights cells containing dates in the specified time period. | All   14.2 |
| [XL.ConditionalFormating.AddTopRule](XLConditionalFormatingAddTopRule.md)   Adds a conditional formatting rule that highlights cells whose values fall in the \[top N\] or \[bottom N\] bracket. | All   14.2 |
| [XL.CopyCellValue](XLCopyCellValue.md)   Copies one cell. | All   11.2 |
| [XL.CopyColumn](XLCopyColumn.md)   Copies cells from one column to another column. | All   10.5 |
| [XL.CopyContent](XLCopyContent.md)   Copies all content from one book to other book. | All   5.1 |
| [XL.CopyRow](XLCopyRow.md)   Copies cells from one row to another row. | All   6.5 |
| [XL.CopySheet](XLCopySheet.md)   Copies a sheet to another book. | All   6.5 |
| [XL.Date.DoubleToTimeStamp](XLDateDoubleToTimeStamp.md)   Converts a timestamp number to a timestamp value. | All   5.0 |
| [XL.Date.Pack](XLDatePack.md)   Packs date and time information into double type. | All   3.5 |
| [XL.Date.TimeStampToDouble](XLDateTimeStampToDouble.md)   Converts a date to a numeric value for writing in a number cell. | All   5.0 |
| [XL.Date.UnPack](XLDateUnPack.md)   Unpacks date and time information from double type. | All   3.5 |
| [XL.Font.GetBold](XLFontGetBold.md)   Returns whether the font is bold. | All   3.5 |
| [XL.Font.GetColor](XLFontGetColor.md)   Returns the color of the font. | All   3.5 |
| [XL.Font.GetItalic](XLFontGetItalic.md)   Returns whether the font is italic. | All   3.5 |
| [XL.Font.GetName](XLFontGetName.md)   Returns the name of the font. | All   3.5 |
| [XL.Font.GetScript](XLFontGetScript.md)   Returns the script style of the font. | All   3.5 |
| [XL.Font.GetSize](XLFontGetSize.md)   Returns the size of the font in points. | All   3.5 |
| [XL.Font.GetStrikeOut](XLFontGetStrikeOut.md)   Returns whether the font is strikeout. | All   3.5 |
| [XL.Font.GetUnderline](XLFontGetUnderline.md)   Returns the underline style of the font. | All   3.5 |
| [XL.Font.SetBold](XLFontSetBold.md)   Turns on/off the bold font. | All   3.5 |
| [XL.Font.SetColor](XLFontSetColor.md)   Sets the color of the font. | All   3.5 |
| [XL.Font.SetItalic](XLFontSetItalic.md)   Turns on/off the italic font. | All   3.5 |
| [XL.Font.SetName](XLFontSetName.md)   Sets the name of the font. | All   3.5 |
| [XL.Font.SetScript](XLFontSetScript.md)   Sets the script style of the font. | All   3.5 |
| [XL.Font.SetSize](XLFontSetSize.md)   Sets the size of the font in points. | All   3.5 |
| [XL.Font.SetStrikeOut](XLFontSetStrikeOut.md)   Turns on/off the strikeout font. | All   3.5 |
| [XL.Font.SetUnderline](XLFontSetUnderline.md)   Sets the underline style of the font. | All   3.5 |
| [XL.FormControl.AddItem](XLFormControlAddItem.md)   Adds the item to a list box or drop-down form control. | All   13.1 |
| [XL.FormControl.AltText](XLFormControlAltText.md)   Returns alternative text for the object. | All   13.1 |
| [XL.FormControl.ClearItems](XLFormControlClearItems.md)   Clears all items from a list box or drop-down form control. | All   13.1 |
| [XL.FormControl.DefaultSize](XLFormControlDefaultSize.md)   Returns whether the object is at its default size. | All   13.1 |
| [XL.FormControl.Disabled](XLFormControlDisabled.md)   Returns whether the object is allowed to run an attached macro. | All   13.1 |
| [XL.FormControl.GetChecked](XLFormControlGetChecked.md)   Queries the check state. | All   13.1 |
| [XL.FormControl.GetDropLines](XLFormControlGetDropLines.md)   Returns the number of lines in the drop-down before scroll bars are added. | All   13.1 |
| [XL.FormControl.GetDx](XLFormControlGetDx.md)   Returns the width of the scroll bar in pixels. | All   13.1 |
| [XL.FormControl.GetFirstButton](XLFormControlGetFirstButton.md)   Returns whether the object is the first button in a set of radio buttons. | All   13.1 |
| [XL.FormControl.GetFmlaGroup](XLFormControlGetFmlaGroup.md)   Queries group name. | All   13.1 |
| [XL.FormControl.GetFmlaLink](XLFormControlGetFmlaLink.md)   Returns the cell reference is linked to. | All   13.1 |
| [XL.FormControl.GetFmlaRange](XLFormControlGetFmlaRange.md)   Returns the cell reference with range of source data cells. | All   13.1 |
| [XL.FormControl.GetFmlaTxbx](XLFormControlGetFmlaTxbx.md)   Queries the source for the control. | All   13.1 |
| [XL.FormControl.GetFromAnchor](XLFormControlGetFromAnchor.md)   Returns the bottom right location of a control within a document. | All   13.1 |
| [XL.FormControl.GetHoriz](XLFormControlGetHoriz.md)   Returns whether the scroll bar is horizontal. | All   13.1 |
| [XL.FormControl.GetInc](XLFormControlGetInc.md)   Queries increment. | All   13.1 |
| [XL.FormControl.GetMax](XLFormControlGetMax.md)   Queries maximum value. | All   13.1 |
| [XL.FormControl.GetMin](XLFormControlGetMin.md)   Queries minimum value. | All   13.1 |
| [XL.FormControl.GetMultiSel](XLFormControlGetMultiSel.md)   Returns the indices of selected items as a comma-delimited list. | All   13.1 |
| [XL.FormControl.GetSet](XLFormControlGetSet.md)   Queries the index of the selected item. | All   13.1 |
| [XL.FormControl.GetToAnchor](XLFormControlGetToAnchor.md)   Returns the top left location of a control within a document. | All   13.1 |
| [XL.FormControl.InsertItem](XLFormControlInsertItem.md)   Inserts the item to the specified position to a list box or drop-down form control. | All   13.1 |
| [XL.FormControl.Item](XLFormControlItem.md)   Returns the item by index from a list box or drop-down form control. | All   13.1 |
| [XL.FormControl.ItemCount](XLFormControlItemCount.md)   Returns the number of items in a list box or drop-down form control. | All   13.1 |
| [XL.FormControl.JSON](XLFormControlJSON.md)   Queries form controls as JSON. | All   14.0 |
| [XL.FormControl.LinkedCell](XLFormControlLinkedCell.md)   Returns the worksheet range linked to the control's value. | All   13.1 |
| [XL.FormControl.ListFillRange](XLFormControlListFillRange.md)   Returns the range of source data cells used to populate the list box. | All   13.1 |
| [XL.FormControl.Locked](XLFormControlLocked.md)   Returns whether the object is locked when the sheet is protected. | All   13.1 |
| [XL.FormControl.Macro](XLFormControlMacro.md)   Returns the custom function associated with the object. | All   13.1 |
| [XL.FormControl.Name](XLFormControlName.md)   Returns the name for this embedded control. | All   13.1 |
| [XL.FormControl.ObjectType](XLFormControlObjectType.md)   Returns the form control object type. | All   13.1 |
| [XL.FormControl.Print](XLFormControlPrint.md)   Returns whether the object is printed when the document is printed. | All   13.1 |
| [XL.FormControl.SetChecked](XLFormControlSetChecked.md)   Sets the check state. | All   13.1 |
| [XL.FormControl.SetDropLines](XLFormControlSetDropLines.md)   Sets the number of lines in the drop-down before scroll bars are added. | All   13.1 |
| [XL.FormControl.SetDx](XLFormControlSetDx.md)   Sets the width of the scroll bar in pixels. | All   13.1 |
| [XL.FormControl.SetFirstButton](XLFormControlSetFirstButton.md)   Sets whether the object is the first button in a set of radio buttons. | All   13.1 |
| [XL.FormControl.SetFmlaGroup](XLFormControlSetFmlaGroup.md)   Sets the cell reference in a group box is linked to. | All   13.1 |
| [XL.FormControl.SetFmlaLink](XLFormControlSetFmlaLink.md)   Sets the cell reference is linked to. | All   13.1 |
| [XL.FormControl.SetFmlaRange](XLFormControlSetFmlaRange.md)   Sets the cell reference with range of source data cells. | All   13.1 |
| [XL.FormControl.SetFmlaTxbx](XLFormControlSetFmlaTxbx.md)   Sets the source. | All   13.1 |
| [XL.FormControl.SetHoriz](XLFormControlSetHoriz.md)   Sets whether the scroll bar is horizontal. | All   13.1 |
| [XL.FormControl.SetInc](XLFormControlSetInc.md)   Sets increment. | All   13.1 |
| [XL.FormControl.SetMax](XLFormControlSetMax.md)   Sets the maximum. | All   13.1 |
| [XL.FormControl.SetMin](XLFormControlSetMin.md)   Sets the minimum. | All   13.1 |
| [XL.FormControl.SetMultiSel](XLFormControlSetMultiSel.md)   Sets the indices of selected items as a comma-delimited list. | All   13.1 |
| [XL.FormControl.SetSel](XLFormControlSetSel.md)   Sets the index of the selected item. | All   13.1 |
| [XL.Format.GetAlignH](XLFormatGetAlignH.md)   Returns the horizontal alignment. | All   3.5 |
| [XL.Format.GetAlignV](XLFormatGetAlignV.md)   Returns the vertical alignment. | All   3.5 |
| [XL.Format.GetBorderBottom](XLFormatGetBorderBottom.md)   Returns the bottom border style. | All   3.5 |
| [XL.Format.GetBorderBottomColor](XLFormatGetBorderBottomColor.md)   Returns the color of the bottom border. | All   3.5 |
| [XL.Format.GetBorderDiagonal](XLFormatGetBorderDiagonal.md)   Returns the diagonal border. | All   3.5 |
| [XL.Format.GetBorderDiagonalColor](XLFormatGetBorderDiagonalColor.md)   Returns the color of the diagonal border. | All   3.5 |
| [XL.Format.GetBorderDiagonalStyle](XLFormatGetBorderDiagonalStyle.md)   Gets the style for diagonal border. | All   3.5 |
| [XL.Format.GetBorderLeft](XLFormatGetBorderLeft.md)   Returns the left border style. | All   3.5 |
| [XL.Format.GetBorderLeftColor](XLFormatGetBorderLeftColor.md)   Returns the color of the left border. | All   3.5 |
| [XL.Format.GetBorderRight](XLFormatGetBorderRight.md)   Returns the right border style. | All   3.5 |
| [XL.Format.GetBorderRightColor](XLFormatGetBorderRightColor.md)   Returns the color of the right border. | All   3.5 |
| [XL.Format.GetBorderTop](XLFormatGetBorderTop.md)   Returns the top border style. | All   3.5 |
| [XL.Format.GetBorderTopColor](XLFormatGetBorderTopColor.md)   Returns the color of the top border. | All   3.5 |
| [XL.Format.GetFillPattern](XLFormatGetFillPattern.md)   Returns the fill pattern. | All   3.5 |
| [XL.Format.GetFont](XLFormatGetFont.md)   Returns the font for this format. | All   3.5 |
| [XL.Format.GetHidden](XLFormatGetHidden.md)   Returns whether the hidden property is set to true. | All   3.5 |
| [XL.Format.GetIndent](XLFormatGetIndent.md)   Returns the text indentation level. | All   3.5 |
| [XL.Format.GetLocked](XLFormatGetLocked.md)   Returns whether the locked property is set to true. | All   3.5 |
| [XL.Format.GetNumFormat](XLFormatGetNumFormat.md)   Returns the number format identifier. | All   3.5 |
| [XL.Format.GetPatternBackgroundColor](XLFormatGetPatternBackgroundColor.md)   Returns the background color of the fill pattern. | All   3.5 |
| [XL.Format.GetPatternForegroundColor](XLFormatGetPatternForegroundColor.md)   Returns the foreground color of the fill pattern. | All   3.5 |
| [XL.Format.GetRotation](XLFormatGetRotation.md)   Returns the text rotation. | All   3.5 |
| [XL.Format.GetShrinkToFit](XLFormatGetShrinkToFit.md)   Returns whether the cell is shrink-to-fit. | All   3.5 |
| [XL.Format.GetWrap](XLFormatGetWrap.md)   Returns whether the cell text is wrapped. | All   3.5 |
| [XL.Format.SetAlignH](XLFormatSetAlignH.md)   Sets the horizontal alignment. | All   3.5 |
| [XL.Format.SetAlignV](XLFormatSetAlignV.md)   Sets the vertical alignment. | All   3.5 |
| [XL.Format.SetBorder](XLFormatSetBorder.md)   Sets the border style. | All   3.5 |
| [XL.Format.SetBorderBottom](XLFormatSetBorderBottom.md)   Sets the bottom border style. | All   3.5 |
| [XL.Format.SetBorderBottomColor](XLFormatSetBorderBottomColor.md)   Sets the color of the bottom border. | All   3.5 |
| [XL.Format.SetBorderColor](XLFormatSetBorderColor.md)   Sets the border color. | All   3.5 |
| [XL.Format.SetBorderDiagonal](XLFormatSetBorderDiagonal.md)   Sets the diagonal border. | All   3.5 |
| [XL.Format.SetBorderDiagonalColor](XLFormatSetBorderDiagonalColor.md)   Sets the color of the diagonal border. | All   3.5 |
| [XL.Format.SetBorderDiagonalStyle](XLFormatSetBorderDiagonalStyle.md)   Sets the style for diagonal border. | All   3.5 |
| [XL.Format.SetBorderLeft](XLFormatSetBorderLeft.md)   Sets the left border style. | All   3.5 |
| [XL.Format.SetBorderLeftColor](XLFormatSetBorderLeftColor.md)   Sets the color of the left border. | All   3.5 |
| [XL.Format.SetBorderRight](XLFormatSetBorderRight.md)   Sets the right border style. | All   3.5 |
| [XL.Format.SetBorderRightColor](XLFormatSetBorderRightColor.md)   Sets the color of the right border. | All   3.5 |
| [XL.Format.SetBorderTop](XLFormatSetBorderTop.md)   Sets the top border style. | All   3.5 |
| [XL.Format.SetBorderTopColor](XLFormatSetBorderTopColor.md)   Sets the color of the top border. | All   3.5 |
| [XL.Format.SetFillPattern](XLFormatSetFillPattern.md)   Sets the fill pattern. | All   3.5 |
| [XL.Format.SetFont](XLFormatSetFont.md)   Sets the font for the format. | All   3.5 |
| [XL.Format.SetHidden](XLFormatSetHidden.md)   Sets the hidden property. | All   3.5 |
| [XL.Format.SetIndent](XLFormatSetIndent.md)   Sets the text indentation level. | All   3.5 |
| [XL.Format.SetLocked](XLFormatSetLocked.md)   Sets the locked property. | All   3.5 |
| [XL.Format.SetNumFormat](XLFormatSetNumFormat.md)   Sets the number format identifier. | All   3.5 |
| [XL.Format.SetPatternBackgroundColor](XLFormatSetPatternBackgroundColor.md)   Sets the background color of the fill pattern. | All   3.5 |
| [XL.Format.SetPatternForegroundColor](XLFormatSetPatternForegroundColor.md)   Sets the foreground color of the fill pattern. | All   3.5 |
| [XL.Format.SetRotation](XLFormatSetRotation.md)   Sets the text rotation. | All   3.5 |
| [XL.Format.SetShrinkToFit](XLFormatSetShrinkToFit.md)   Sets the flag whether the cell is shrink-to-fit. | All   3.5 |
| [XL.Format.SetWrap](XLFormatSetWrap.md)   Sets the flag whether the cell text is wrapped. | All   3.5 |
| [XL.Initialize](XLInitialize.md)   Initializes the XL library by loading it. | All   2.9 |
| [XL.IsInitialized](XLIsInitialized.md)   Checks if libXL library has been initialized. | All   4.2 |
| [XL.List](XLList.md)   Lists all IDs of current XL books. | All   13.0 |
| [XL.LoadBook](XLLoadBook.md)   Loads a Excel file. | All   2.9 |
| [XL.LoadBookInfo](XLLoadBookInfo.md)   Loads a Excel file metadata. | All   16.1 |
| [XL.LoadBookPartially](XLLoadBookPartially.md)   Loads a Excel file partially. | All   8.0 |
| [XL.NewBook](XLNewBook.md)   Creates a new workbook in memory. | All   2.9 |
| [XL.Sheet.AddConditionalFormatting](XLSheetAddConditionalFormatting.md)   Adds a conditional formatting rules to the sheet. | All   14.2 |
| [XL.Sheet.AddDataValidation](XLSheetAddDataValidation.md)   Adds a data validation for the specified range. | All   10.5 |
| [XL.Sheet.AddHyperlink](XLSheetAddHyperlink.md)   Adds the new hyperlink. | All   4.3 |
| [XL.Sheet.AddIgnoredError](XLSheetAddIgnoredError.md)   Adds the ignored error for specified range. | All   7.2 |
| [XL.Sheet.AddSelectionRange](XLSheetAddSelectionRange.md)   Adds a range to the selection. | All   13.1 |
| [XL.Sheet.AddTable](XLSheetAddTable.md)   Adds a table to the sheet with the specified name, range and style. | All   15.2 |
| [XL.Sheet.AddrToRowCol](XLSheetAddrToRowCol.md)   Converts a cell reference to row and column. | All   3.5 |
| [XL.Sheet.ApplyFilter](XLSheetApplyFilter.md)   Applies the AutoFilter to the sheet. | All   7.2 |
| [XL.Sheet.AreCellsEmpty](XLSheetAreCellsEmpty.md)   Checks whether the cells in the given range are empty. | All   13.2 |
| [XL.Sheet.AutoFilter](XLSheetAutoFilter.md)   Initializes the AutoFilter. | All   7.2 |
| [XL.Sheet.AutoFilter.AddFilter](XLSheetAutoFilterAddFilter.md)   Adds the filter value. | All   7.3 |
| [XL.Sheet.AutoFilter.AddSort](XLSheetAutoFilterAddSort.md)   Adds the sorted column in AutoFilter by zero-based index and its sort order. | All   11.5 |
| [XL.Sheet.AutoFilter.Clear](XLSheetAutoFilterClear.md)   Clear the filter criteria. | All   7.3 |
| [XL.Sheet.AutoFilter.ColumnSize](XLSheetAutoFilterColumnSize.md)   Returns the number of specified AutoFilter columns which have a filter information. | All   7.2 |
| [XL.Sheet.AutoFilter.Filter](XLSheetAutoFilterFilter.md)   Returns the filter value by index. | All   7.3 |
| [XL.Sheet.AutoFilter.FilterSize](XLSheetAutoFilterFilterSize.md)   Returns the number of filter values. | All   7.3 |
| [XL.Sheet.AutoFilter.FilterType](XLSheetAutoFilterFilterType.md)   Returns the filter type of this AutoFilter column. | All   7.3 |
| [XL.Sheet.AutoFilter.GetCustomFilter](XLSheetAutoFilterGetCustomFilter.md)   Gets the custom filter criteria. | All   7.3 |
| [XL.Sheet.AutoFilter.GetRef](XLSheetAutoFilterGetRef.md)   Gets the cell range of AutoFilter with header. | All   7.2 |
| [XL.Sheet.AutoFilter.GetSort](XLSheetAutoFilterGetSort.md)   Gets the zero-based index of sorted column in AutoFilter and its sort order. | All   7.2 |
| [XL.Sheet.AutoFilter.GetSortEx](XLSheetAutoFilterGetSortEx.md)  **New in 16.3**    Gets the zero-based index of sorted column in AutoFilter and its sort order. | All   16.3 |
| [XL.Sheet.AutoFilter.GetSortRange](XLSheetAutoFilterGetSortRange.md)   Gets the whole range of data to sort. | All   7.2 |
| [XL.Sheet.AutoFilter.GetTop10](XLSheetAutoFilterGetTop10.md)   Gets the number of top or bottom items. | All   7.3 |
| [XL.Sheet.AutoFilter.SetCustomFilter](XLSheetAutoFilterSetCustomFilter.md)   Sets the custom filter criteria. | All   7.3 |
| [XL.Sheet.AutoFilter.SetRef](XLSheetAutoFilterSetRef.md)   Sets the cell range of AutoFilter with header. | All   7.2 |
| [XL.Sheet.AutoFilter.SetSort](XLSheetAutoFilterSetSort.md)   Sets the sorted column in AutoFilter by zero-based index and its sort order. | All   7.2 |
| [XL.Sheet.AutoFilter.SetTop10](XLSheetAutoFilterSetTop10.md)   Sets the number of top or bottom items. | All   7.3 |
| [XL.Sheet.AutoFilter.SortLevels](XLSheetAutoFilterSortLevels.md)  **New in 16.3**    Gets the number of sort levels. | All   16.3 |
| [XL.Sheet.CellIsDate](XLSheetCellIsDate.md)   Checks that cell contains a date or time value. | All   3.5 |
| [XL.Sheet.CellIsFormula](XLSheetCellIsFormula.md)   Checks that cell contains a formula. | All   3.5 |
| [XL.Sheet.CellIsStyledText](XLSheetCellIsStyledText.md)   Queries whether cell has styled text. | All   10.2 |
| [XL.Sheet.CellReadBlank](XLSheetCellReadBlank.md)   Checks if cell is blank. | All   3.5 |
| [XL.Sheet.CellReadBoolean](XLSheetCellReadBoolean.md)   Reads a boolean value from a cell. | All   3.5 |
| [XL.Sheet.CellReadBooleans](XLSheetCellReadBooleans.md)   Reads all the boolean values in an area. | All   8.0 |
| [XL.Sheet.CellReadComment](XLSheetCellReadComment.md)   Reads a comment value from a cell. | All   3.5 |
| [XL.Sheet.CellReadComments](XLSheetCellReadComments.md)   Reads all the comments from cells in an area. | All   8.0 |
| [XL.Sheet.CellReadDate](XLSheetCellReadDate.md)   Reads a number value from a cell. | All   5.0 |
| [XL.Sheet.CellReadDates](XLSheetCellReadDates.md)   Reads all the dates from cells in an area. | All   8.0 |
| [XL.Sheet.CellReadFormula](XLSheetCellReadFormula.md)   Reads the formula value from a cell. | All   3.5 |
| [XL.Sheet.CellReadFormulas](XLSheetCellReadFormulas.md)   Reads all the formulas from cells in an area. | All   8.0 |
| [XL.Sheet.CellReadNumber](XLSheetCellReadNumber.md)   Reads a number value from a cell. | All   3.5 |
| [XL.Sheet.CellReadNumbers](XLSheetCellReadNumbers.md)   Reads all the numbers from cells in an area. | All   8.0 |
| [XL.Sheet.CellReadStyledText](XLSheetCellReadStyledText.md)   Reads a styled text value from a cell. | All   10.2 |
| [XL.Sheet.CellReadText](XLSheetCellReadText.md)   Reads a text value from a cell. | All   3.5 |
| [XL.Sheet.CellReadTexts](XLSheetCellReadTexts.md)   Reads all the texts from cells in an area. | All   8.0 |
| [XL.Sheet.CellReadValue](XLSheetCellReadValue.md)   Reads a value value from a cell. | All   10.5 |
| [XL.Sheet.CellReadValues](XLSheetCellReadValues.md)   Reads all the values from cells in an area. | All   11.5 |
| [XL.Sheet.CellType](XLSheetCellType.md)   Queries type of cell. | All   3.5 |
| [XL.Sheet.CellWriteBlank](XLSheetCellWriteBlank.md)   Writes a blank cell. | All   3.5 |
| [XL.Sheet.CellWriteBlanks](XLSheetCellWriteBlanks.md)   Writes blanks to an area of cells. | All   8.0 |
| [XL.Sheet.CellWriteBoolean](XLSheetCellWriteBoolean.md)   Writes a boolean value into cell. | All   3.5 |
| [XL.Sheet.CellWriteBooleans](XLSheetCellWriteBooleans.md)   Writes booleans to an area of cells. | All   8.0 |
| [XL.Sheet.CellWriteComment](XLSheetCellWriteComment.md)   Writes a comment to a cell. | All   3.5 |
| [XL.Sheet.CellWriteComments](XLSheetCellWriteComments.md)   Writes comments to an area of cells. | All   8.0 |
| [XL.Sheet.CellWriteDate](XLSheetCellWriteDate.md)   Writes a number into cell. | All   5.0 |
| [XL.Sheet.CellWriteDates](XLSheetCellWriteDates.md)   Writes dates to an area of cells. | All   8.0 |
| [XL.Sheet.CellWriteError](XLSheetCellWriteError.md)   Writes error into the cell with specified format. | All   7.2 |
| [XL.Sheet.CellWriteFormula](XLSheetCellWriteFormula.md)   Writes a formula into cell. | All   3.5 |
| [XL.Sheet.CellWriteFormulaBoolean](XLSheetCellWriteFormulaBoolean.md)   Writes a formula and value in a cell. | All   6.5 |
| [XL.Sheet.CellWriteFormulaNumber](XLSheetCellWriteFormulaNumber.md)   Writes a formula and value in a cell. | All   6.5 |
| [XL.Sheet.CellWriteFormulaText](XLSheetCellWriteFormulaText.md)   Writes a formula and value in a cell. | All   6.5 |
| [XL.Sheet.CellWriteFormulas](XLSheetCellWriteFormulas.md)   Writes formulas to an area of cells. | All   8.0 |
| [XL.Sheet.CellWriteMatrix](XLSheetCellWriteMatrix.md)   Writes cell values from matrix. | All   13.3 |
| [XL.Sheet.CellWriteNumber](XLSheetCellWriteNumber.md)   Writes a number into cell. | All   3.5 |
| [XL.Sheet.CellWriteNumbers](XLSheetCellWriteNumbers.md)   Writes numbers to an area of cells. | All   8.0 |
| [XL.Sheet.CellWriteStyledText](XLSheetCellWriteStyledText.md)   Writes a styled text into a cell. | All   10.2 |
| [XL.Sheet.CellWriteText](XLSheetCellWriteText.md)   Writes a string into cell. | All   3.5 |
| [XL.Sheet.CellWriteTextAsNumber](XLSheetCellWriteTextAsNumber.md)   Writes a number into cell, but passes it as text. | All   10.3 |
| [XL.Sheet.CellWriteTexts](XLSheetCellWriteTexts.md)   Writes texts to an area of cells. | All   8.0 |
| [XL.Sheet.Clear](XLSheetClear.md)   Clears cells in specified area. | All   3.5 |
| [XL.Sheet.ClearPrintArea](XLSheetClearPrintArea.md)   Clears the print area. | All   3.5 |
| [XL.Sheet.ClearPrintRepeats](XLSheetClearPrintRepeats.md)   Clears repeated rows and columns on each page. | All   3.5 |
| [XL.Sheet.ColFormat](XLSheetColFormat.md)   Returns column's format. | All   15.0 |
| [XL.Sheet.ConditionalFormatSize](XLSheetConditionalFormatSize.md)   Returns a number of conditional formatting rules in this worksheet (only for xlsx files). | All   16.1 |
| [XL.Sheet.ConditionalFormatting](XLSheetConditionalFormatting.md)   Returns conditional formatting rules with the specified index (only for xlsx files). | All   16.1 |
| [XL.Sheet.CopyCell](XLSheetCopyCell.md)   Copies cell with format from (rowSrc, colSrc) to (rowDst, colDst). | All   3.5 |
| [XL.Sheet.DataValidation](XLSheetDataValidation.md)  **New in 16.3**    Queries details on one data validation. | All   16.3 |
| [XL.Sheet.DataValidationSize](XLSheetDataValidationSize.md)  **New in 16.3**    Returns a number of data validations in this worksheet (only for xlsx files). | All   16.3 |
| [XL.Sheet.DataValidations](XLSheetDataValidations.md)  **New in 16.3**    Queries details on all data validations. | All   16.3 |
| [XL.Sheet.DefaultRowHeight](XLSheetDefaultRowHeight.md)   Returns the default row height measured in point size. | All   13.1 |
| [XL.Sheet.DelHyperlink](XLSheetDelHyperlink.md)   Removes hyperlink by index. | All   4.3 |
| [XL.Sheet.DelMergeByIndex](XLSheetDelMergeByIndex.md)   Removes merged cells by index. | All   4.3 |
| [XL.Sheet.DeleteMerge](XLSheetDeleteMerge.md)   Removes merged cells. | All   3.5 |
| [XL.Sheet.DeleteNamedRange](XLSheetDeleteNamedRange.md)   Deletes the named range by name. | All   3.5 |
| [XL.Sheet.FormControlCount](XLSheetFormControlCount.md)   Queries number of form controls. | All   13.1 |
| [XL.Sheet.GetActiveCell](XLSheetGetActiveCell.md)   Gets an active cell of the sheet. | All   13.1 |
| [XL.Sheet.GetCellError](XLSheetGetCellError.md)   Reads error from cell. | All   3.5 |
| [XL.Sheet.GetCellErrors](XLSheetGetCellErrors.md)   Reads all the errors from cells in an area. | All   8.0 |
| [XL.Sheet.GetCellFormat](XLSheetGetCellFormat.md)   Returns cell's format. | All   3.5 |
| [XL.Sheet.GetCellFormats](XLSheetGetCellFormats.md)   Reads all the formats from cells in an area. | All   8.0 |
| [XL.Sheet.GetCellPicture](XLSheetGetCellPicture.md)   Queries picture for a cell. | All   11.5 |
| [XL.Sheet.GetColHidden](XLSheetGetColHidden.md)   Returns whether column is hidden. | All   3.5 |
| [XL.Sheet.GetColWidth](XLSheetGetColWidth.md)   Returns column width in points. | All   3.5 |
| [XL.Sheet.GetColWidthPixel](XLSheetGetColWidthPixel.md)   Returns column width in pixel. | All   10.2 |
| [XL.Sheet.GetDisplayGridlines](XLSheetGetDisplayGridlines.md)   Returns whether the gridlines are displayed. | All   3.5 |
| [XL.Sheet.GetFirstCol](XLSheetGetFirstCol.md)   Returns the first column in the sheet that contains a used cell. | All   3.5 |
| [XL.Sheet.GetFirstFilledCol](XLSheetGetFirstFilledCol.md)   Returns the first column in the sheet that contains a filled cell. | All   10.3 |
| [XL.Sheet.GetFirstFilledRow](XLSheetGetFirstFilledRow.md)   Returns the first row in the sheet that contains a filled cell. | All   10.3 |
| [XL.Sheet.GetFirstRow](XLSheetGetFirstRow.md)   Returns the first row in the sheet that contains a used cell. | All   3.5 |
| [XL.Sheet.GetFooter](XLSheetGetFooter.md)   Returns the footer text of the sheet when printed. | All   3.5 |
| [XL.Sheet.GetFooterMargin](XLSheetGetFooterMargin.md)   Returns the footer margin in inches. | All   3.5 |
| [XL.Sheet.GetGroupSummaryBelow](XLSheetGetGroupSummaryBelow.md)   Returns whether grouping rows summary is below. | All   3.5 |
| [XL.Sheet.GetGroupSummaryRight](XLSheetGetGroupSummaryRight.md)   Returns whether grouping columns summary is right. | All   3.5 |
| [XL.Sheet.GetHCenter](XLSheetGetHCenter.md)   Returns whether the sheet is centered horizontally when printed. | All   3.5 |
| [XL.Sheet.GetHeader](XLSheetGetHeader.md)   Returns the header text of the sheet when printed. | All   3.5 |
| [XL.Sheet.GetHeaderMargin](XLSheetGetHeaderMargin.md)   Returns the header margin in inches. | All   3.5 |
| [XL.Sheet.GetHidden](XLSheetGetHidden.md)   Returns whether sheet is hidden. | All   3.5 |
| [XL.Sheet.GetHorPageBreak](XLSheetGetHorPageBreak.md)   Returns row with horizontal page break at position index. | All   3.5 |
| [XL.Sheet.GetHorPageBreakCount](XLSheetGetHorPageBreakCount.md)   Returns a number of horizontal page breaks in the sheet. | All   3.5 |
| [XL.Sheet.GetLandscape](XLSheetGetLandscape.md)   Returns a page orientation mode. | All   3.5 |
| [XL.Sheet.GetLastCol](XLSheetGetLastCol.md)   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](XLSheetGetLastFilledCol.md)   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](XLSheetGetLastFilledRow.md)   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](XLSheetGetLastRow.md)   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](XLSheetGetMarginBottom.md)   Returns the bottom margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.GetMarginLeft](XLSheetGetMarginLeft.md)   Returns the left margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.GetMarginRight](XLSheetGetMarginRight.md)   Returns the right margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.GetMarginTop](XLSheetGetMarginTop.md)   Returns the top margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.GetMerge](XLSheetGetMerge.md)   Gets merged cells for cell at row, col. | All   3.5 |
| [XL.Sheet.GetName](XLSheetGetName.md)   Returns the name of the sheet. | All   3.5 |
| [XL.Sheet.GetNamedRange](XLSheetGetNamedRange.md)   Gets the named range coordianates by name. | All   3.5 |
| [XL.Sheet.GetPaper](XLSheetGetPaper.md)   Returns the paper size. | All   3.5 |
| [XL.Sheet.GetPicture](XLSheetGetPicture.md)   Returns a workbook picture index at position index in worksheet. | All   3.5 |
| [XL.Sheet.GetPrintArea](XLSheetGetPrintArea.md)   Gets the print area. | All   5.1 |
| [XL.Sheet.GetPrintFit](XLSheetGetPrintFit.md)   Returns whether fit to page option is enabled. | All   3.5 |
| [XL.Sheet.GetPrintGridlines](XLSheetGetPrintGridlines.md)   Returns whether the gridlines are printed. | All   3.5 |
| [XL.Sheet.GetPrintRepeatCols](XLSheetGetPrintRepeatCols.md)   Gets repeated columns on each page from colFirst to colLast. | All   5.1 |
| [XL.Sheet.GetPrintRepeatRows](XLSheetGetPrintRepeatRows.md)   Gets repeated rows on each page from rowFirst to rowLast. | All   5.1 |
| [XL.Sheet.GetPrintRow](XLSheetGetPrintRow.md)   Returns whether the row and column headers are printed. | All   3.5 |
| [XL.Sheet.GetPrintZoom](XLSheetGetPrintZoom.md)   Returns the scaling factor for printing as a percentage. | All   3.5 |
| [XL.Sheet.GetProtect](XLSheetGetProtect.md)   Returns whether sheet is protected. | All   3.5 |
| [XL.Sheet.GetRowHeight](XLSheetGetRowHeight.md)   Returns row height in points. | All   3.5 |
| [XL.Sheet.GetRowHeightPixel](XLSheetGetRowHeightPixel.md)   Returns row height in pixels. | All   10.2 |
| [XL.Sheet.GetRowHidden](XLSheetGetRowHidden.md)   Returns whether row is hidden. | All   3.5 |
| [XL.Sheet.GetTabColor](XLSheetGetTabColor.md)   Queries the sheet's tab color. | All   13.1 |
| [XL.Sheet.GetTabColorRGB](XLSheetGetTabColorRGB.md)   Queries the sheet's tab RGB color. | All   13.1 |
| [XL.Sheet.GetText](XLSheetGetText.md)   Queries the text of a sheet in a workbook. | All   3.5 |
| [XL.Sheet.GetTopLeftView](XLSheetGetTopLeftView.md)   Extracts the first visible row and the leftmost visible column of the sheet. | All   3.5 |
| [XL.Sheet.GetVCenter](XLSheetGetVCenter.md)   Returns whether the sheet is centered vertically when printed. | All   3.5 |
| [XL.Sheet.GetVerPageBreak](XLSheetGetVerPageBreak.md)   Returns column with vertical page break at position index. | All   3.5 |
| [XL.Sheet.GetVerPageBreakCount](XLSheetGetVerPageBreakCount.md)   Returns a number of vertical page breaks in the sheet. | All   3.5 |
| [XL.Sheet.GetZoom](XLSheetGetZoom.md)   Returns the zoom level of the current view as a percentage. | All   3.5 |
| [XL.Sheet.GroupCols](XLSheetGroupCols.md)   Groups columns from colFirst to colLast. | All   3.5 |
| [XL.Sheet.GroupRows](XLSheetGroupRows.md)   Groups rows from rowFirst to rowLast. | All   3.5 |
| [XL.Sheet.Hyperlink](XLSheetHyperlink.md)   Gets the hyperlink and its coordianates by index. | All   4.3 |
| [XL.Sheet.HyperlinkIndex](XLSheetHyperlinkIndex.md)   Checks if the cell contains a hyperlink. | All   13.2 |
| [XL.Sheet.HyperlinkSize](XLSheetHyperlinkSize.md)   Returns the number of hyperlinks in the sheet. | All   4.3 |
| [XL.Sheet.InsertCol](XLSheetInsertCol.md)   Inserts columns from colFirst to colLast. | All   3.5 |
| [XL.Sheet.InsertRow](XLSheetInsertRow.md)   Inserts rows from rowFirst to rowLast. | All   3.5 |
| [XL.Sheet.IsAutoFilter](XLSheetIsAutoFilter.md)   Whether this sheet has an auto filter. | All   11.5 |
| [XL.Sheet.Merge](XLSheetMerge.md)   Gets the merged cells by index. | All   4.3 |
| [XL.Sheet.MergeSize](XLSheetMergeSize.md)   Returns a number of merged cells in this worksheet. | All   4.3 |
| [XL.Sheet.NamedRange](XLSheetNamedRange.md)   Gets the named range coordinates by index. | All   3.5 |
| [XL.Sheet.NamedRangeCount](XLSheetNamedRangeCount.md)   Returns the number of named ranges in the sheet. | All   3.5 |
| [XL.Sheet.PictureCount](XLSheetPictureCount.md)   Returns a number of pictures in this worksheet. | All   3.5 |
| [XL.Sheet.ReadCellsAsMatrix](XLSheetReadCellsAsMatrix.md)   Reads all the values from cells in an area into a new matrix. | All   13.0 |
| [XL.Sheet.RemoveCol](XLSheetRemoveCol.md)   Removes columns from colFirst to colLast. | All   3.5 |
| [XL.Sheet.RemoveComment](XLSheetRemoveComment.md)   Removes a comment from a cell. | All   6.5 |
| [XL.Sheet.RemoveComments](XLSheetRemoveComments.md)   Removes comments in given area. | All   8.0 |
| [XL.Sheet.RemoveConditionalFormatting](XLSheetRemoveConditionalFormatting.md)   Removes conditional formatting rules with the specified index for the sheet (only for xlsx files). | All   16.1 |
| [XL.Sheet.RemoveDataValidations](XLSheetRemoveDataValidations.md)   Removes all data validations for the sheet. | All   10.5 |
| [XL.Sheet.RemoveFilter](XLSheetRemoveFilter.md)   Removes the AutoFilter from the sheet. | All   7.2 |
| [XL.Sheet.RemovePicture](XLSheetRemovePicture.md)   Removes a picture from a cell. | All   10.2 |
| [XL.Sheet.RemovePictureByIndex](XLSheetRemovePictureByIndex.md)   Removes a picture by index. | All   10.2 |
| [XL.Sheet.RemoveRow](XLSheetRemoveRow.md)   Removes rows from rowFirst to rowLast. | All   3.5 |
| [XL.Sheet.RemoveSelection](XLSheetRemoveSelection.md)   Removes all selection. | All   13.1 |
| [XL.Sheet.RightToLeft](XLSheetRightToLeft.md)   Returns whether the text is displayed in right-to-left mode. | All   7.2 |
| [XL.Sheet.RowColToAddr](XLSheetRowColToAddr.md)   Converts row and column to a cell reference. | All   3.5 |
| [XL.Sheet.RowFormat](XLSheetRowFormat.md)   Returns row's format. | All   15.0 |
| [XL.Sheet.SelectionRange](XLSheetSelectionRange.md)   Returns a range of the selection. | All   13.1 |
| [XL.Sheet.SetActiveCell](XLSheetSetActiveCell.md)   Sets an active cell of the sheet. | All   13.1 |
| [XL.Sheet.SetAutoFitArea](XLSheetSetAutoFitArea.md)   Sets the borders for autofit column widths feature. | All   5.1 |
| [XL.Sheet.SetBorder](XLSheetSetBorder.md)   Sets the border in the specified range of cells. | All   15.2 |
| [XL.Sheet.SetCellFormat](XLSheetSetCellFormat.md)   Sets cell's format. | All   3.5 |
| [XL.Sheet.SetCellFormats](XLSheetSetCellFormats.md)   Set cell formats in given area. | All   8.0 |
| [XL.Sheet.SetCol](XLSheetSetCol.md)   Sets column width and format for all columns from colFirst to colLast. | All   3.5 |
| [XL.Sheet.SetColHidden](XLSheetSetColHidden.md)   Hides or shows a column. | All   3.5 |
| [XL.Sheet.SetColPx](XLSheetSetColPx.md)   Sets column width in pixels and format for all columns from colFirst to colLast. | All   13.3 |
| [XL.Sheet.SetColumn](XLSheetSetColumn.md)   Sets column width and format for all columns from colFirst to colLast. | All   3.5 |
| [XL.Sheet.SetDefaultRowHeight](XLSheetSetDefaultRowHeight.md)   Sets the default row height measured in point size. | All   13.1 |
| [XL.Sheet.SetDisplayGridlines](XLSheetSetDisplayGridlines.md)   Sets gridlines for displaying. | All   3.5 |
| [XL.Sheet.SetFooter](XLSheetSetFooter.md)   Sets the footer text for the sheet when printed. | All   3.5 |
| [XL.Sheet.SetGroupSummaryBelow](XLSheetSetGroupSummaryBelow.md)   Sets a flag of grouping rows summary. | All   3.5 |
| [XL.Sheet.SetGroupSummaryRight](XLSheetSetGroupSummaryRight.md)   Sets a flag of grouping rows summary. | All   3.5 |
| [XL.Sheet.SetHCenter](XLSheetSetHCenter.md)   Sets a flag that the sheet is centered horizontally when printed. | All   3.5 |
| [XL.Sheet.SetHeader](XLSheetSetHeader.md)   Sets the header text of the sheet when printed. | All   3.5 |
| [XL.Sheet.SetHidden](XLSheetSetHidden.md)   Hides/unhides the sheet. Returns false if error occurs. | All   13.4 |
| [XL.Sheet.SetHorPageBreak](XLSheetSetHorPageBreak.md)   Sets/removes a horizontal page break. | All   3.5 |
| [XL.Sheet.SetLandscape](XLSheetSetLandscape.md)   Sets landscape or portrait mode for printing. | All   3.5 |
| [XL.Sheet.SetMarginBottom](XLSheetSetMarginBottom.md)   Sets the bottom margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.SetMarginLeft](XLSheetSetMarginLeft.md)   Sets the left margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.SetMarginRight](XLSheetSetMarginRight.md)   Sets the right margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.SetMarginTop](XLSheetSetMarginTop.md)   Sets the top margin of the sheet in inches. | All   3.5 |
| [XL.Sheet.SetMerge](XLSheetSetMerge.md)   Sets merged cells for range: rowFirst - rowLast, colFirst - colLast. | All   3.5 |
| [XL.Sheet.SetName](XLSheetSetName.md)   Sets the name of the sheet. | All   3.5 |
| [XL.Sheet.SetNamedRange](XLSheetSetNamedRange.md)   Sets the named range. | All   3.5 |
| [XL.Sheet.SetPaper](XLSheetSetPaper.md)   Sets the paper size. | All   3.5 |
| [XL.Sheet.SetPictureWithScale](XLSheetSetPictureWithScale.md)   Sets a picture with pictureId identifier at position row and col with scale factor and offsets in pixels. | All   3.5 |
| [XL.Sheet.SetPictureWithSize](XLSheetSetPictureWithSize.md)   Sets a picture with pictureId identifier at position row and col with custom size and offsets in pixels. | All   3.5 |
| [XL.Sheet.SetPrintArea](XLSheetSetPrintArea.md)   Sets the print area. | All   3.5 |
| [XL.Sheet.SetPrintFit](XLSheetSetPrintFit.md)   Fits sheet width and sheet height to wPages and hPages respectively. | All   3.5 |
| [XL.Sheet.SetPrintGridlines](XLSheetSetPrintGridlines.md)   Sets gridlines for printing. | All   3.5 |
| [XL.Sheet.SetPrintRepeatCols](XLSheetSetPrintRepeatCols.md)   Sets repeated columns on each page from colFirst to colLast. | All   3.5 |
| [XL.Sheet.SetPrintRepeatRows](XLSheetSetPrintRepeatRows.md)   Sets repeated rows on each page from rowFirst to rowLast. | All   3.5 |
| [XL.Sheet.SetPrintRow](XLSheetSetPrintRow.md)   Sets a flag that the row and column headers are printed. | All   3.5 |
| [XL.Sheet.SetPrintZoom](XLSheetSetPrintZoom.md)   Sets the scaling factor for printing as a percentage. | All   3.5 |
| [XL.Sheet.SetProtect](XLSheetSetProtect.md)   Protects/unprotects the sheet. | All   3.5 |
| [XL.Sheet.SetProtectEx](XLSheetSetProtectEx.md)   Protects/unprotects the sheet with password and enhanced parameters below. | All   7.2 |
| [XL.Sheet.SetRightToLeft](XLSheetSetRightToLeft.md)   Sets the right-to-left mode. | All   7.2 |
| [XL.Sheet.SetRow](XLSheetSetRow.md)   Sets row height and format. | All   3.5 |
| [XL.Sheet.SetRowHidden](XLSheetSetRowHidden.md)   Hides or shows a row. | All   3.5 |
| [XL.Sheet.SetRowPx](XLSheetSetRowPx.md)   Sets column width in pixels and format for all columns from colFirst to colLast. | All   13.3 |
| [XL.Sheet.SetRows](XLSheetSetRows.md)   Sets row height and format for multiple rows. | All   11.2 |
| [XL.Sheet.SetTabColor](XLSheetSetTabColor.md)   Sets the color for the sheet's tab. | All   7.2 |
| [XL.Sheet.SetTabColorRGB](XLSheetSetTabColorRGB.md)   Sets the RGB color for the sheet's tab. | All   7.2 |
| [XL.Sheet.SetTopLeftView](XLSheetSetTopLeftView.md)   Sets the first visible row and the leftmost visible column of the sheet. | All   3.5 |
| [XL.Sheet.SetVCenter](XLSheetSetVCenter.md)   ets a flag that the sheet is centered vertically when printed. | All   3.5 |
| [XL.Sheet.SetVerPageBreak](XLSheetSetVerPageBreak.md)   Sets/removes a vertical page break. | All   3.5 |
| [XL.Sheet.SetZoom](XLSheetSetZoom.md)   Sets the zoom level of the current view. | All   3.5 |
| [XL.Sheet.Split](XLSheetSplit.md)   Splits a sheet at position (row, col). | All   3.5 |
| [XL.Sheet.SplitInfo](XLSheetSplitInfo.md)   Gets the split information (position of frozen pane) in the sheet. | All   4.3 |
| [XL.Sheet.Table](XLSheetTable.md)   Gets the table parameters by index. | All   7.2 |
| [XL.Sheet.TableSize](XLSheetTableSize.md)   Returns the number of tables in the sheet. | All   7.2 |
| [XL.Sheet.Type](XLSheetType.md)   Returns type of sheet with specified index. | All   7.2 |
| [XL.Table.ColumnSize](XLTableColumnSize.md)   Returns the number of columns in the table. | All   15.2 |
| [XL.Table.GetColumnName](XLTableGetColumnName.md)   Queries unique name of the table column with the specified index. | All   15.2 |
| [XL.Table.GetName](XLTableGetName.md)   Queries the name of the table. | All   15.2 |
| [XL.Table.GetRef](XLTableGetRef.md)   Queries the range on the sheet for this table. | All   15.2 |
| [XL.Table.GetShowColumnStripes](XLTableGetShowColumnStripes.md)   Queries whether column stripe formatting is applied. | All   15.2 |
| [XL.Table.GetShowFirstColumn](XLTableGetShowFirstColumn.md)   Queries whether the first column in the table should have the style applied. | All   15.2 |
| [XL.Table.GetShowLastColumn](XLTableGetShowLastColumn.md)   Queries whether the last column in the table should have the style applied. | All   15.2 |
| [XL.Table.GetShowRowStripes](XLTableGetShowRowStripes.md)   Queries whether row stripe formatting is applied. | All   15.2 |
| [XL.Table.GetStyle](XLTableGetStyle.md)   Get the table style. | All   15.2 |
| [XL.Table.IsAutoFilter](XLTableIsAutoFilter.md)  **New in 16.3**    Returns true if the AutoFilter already exists (only for xlsx files). | All   16.3 |
| [XL.Table.RemoveFilter](XLTableRemoveFilter.md)  **New in 16.3**    Removes the AutoFilter from the sheet (only for xlsx files). | All   16.3 |
| [XL.Table.SetColumnName](XLTableSetColumnName.md)   Sets the unique name of the table column with the specified index. | All   15.2 |
| [XL.Table.SetName](XLTableSetName.md)   Sets the name of the table. | All   15.2 |
| [XL.Table.SetRef](XLTableSetRef.md)   Sets the range on the sheet for this table. | All   15.2 |
| [XL.Table.SetShowColumnStripes](XLTableSetShowColumnStripes.md)   Sets whether column stripe formatting is applied. | All   15.2 |
| [XL.Table.SetShowFirstColumn](XLTableSetShowFirstColumn.md)   Sets whether the first column in the table should have the style applied. | All   15.2 |
| [XL.Table.SetShowLastColumn](XLTableSetShowLastColumn.md)   Sets whether the last column in the table should have the style applied. | All   15.2 |
| [XL.Table.SetShowRowStripes](XLTableSetShowRowStripes.md)   Sets whether row stripe formatting is applied. | All   15.2 |
| [XL.Table.SetStyle](XLTableSetStyle.md)   Sets the table style. | All   15.2 |
| [XL.Uninitialize](XLUninitialize.md)   Uninitializes XL library. | All   10.1 |

470 functions shown.

These functions require a license (77%).

### Release notes

- **Version 16.1**
    - Added [XL.Book.Clear](https://www.mbsplugins.eu/XLBookClear.shtml) and [XL.Book.ErrorCode](https://www.mbsplugins.eu/XLBookErrorCode.shtml) functions.
    - Added [XL.Book.ConditionalFormat](https://www.mbsplugins.eu/XLBookConditionalFormat.shtml) and [XL.Book.ConditionalFormatSize](https://www.mbsplugins.eu/XLBookConditionalFormatSize.shtml) functions.
    - Added [XL.LoadBookInfo](https://www.mbsplugins.eu/XLLoadBookInfo.shtml) function.
    - Added [XL.Sheet.ConditionalFormatSize](https://www.mbsplugins.eu/XLSheetConditionalFormatSize.shtml) and [XL.Sheet.ConditionalFormatting](https://www.mbsplugins.eu/XLSheetConditionalFormatting.shtml) functions.
    - Added [XL.Sheet.RemoveConditionalFormatting](https://www.mbsplugins.eu/XLSheetRemoveConditionalFormatting.shtml) function.
    - Changed [XL.Book.AddConditionalFormat](https://www.mbsplugins.eu/XLBookAddConditionalFormat.shtml) function to take area as parameters.
    - Changed [XL.Sheet.AddConditionalFormatting](https://www.mbsplugins.eu/XLSheetAddConditionalFormatting.shtml) so you pass the first range with the function call.
    - Removed unneeded empty path check for [XL.Initialize](https://www.mbsplugins.eu/XLInitialize.shtml) function.
- **Version 16.0**
    - Added password parameter for [XL.LoadBook](https://www.mbsplugins.eu/XLLoadBook.shtml) and [XL.LoadBookPartially](https://www.mbsplugins.eu/XLLoadBookPartially.shtml) functions.
- **Version 15.5**
    - Changed [DynaPDF.Initialize](https://www.mbsplugins.eu/DynaPDFInitialize.shtml) und [XL.Initialize](https://www.mbsplugins.eu/XLInitialize.shtml) to not check if you have a MBS license, so you can run this before our [Register](https://www.mbsplugins.eu/Register.shtml) function.
    - Fixed [XL.ConditionalFormat.Font](https://www.mbsplugins.eu/XLConditionalFormatFont.shtml) to return correct font index.
- **Version 15.2**
    - Added [XL.Sheet.AddTable](https://www.mbsplugins.eu/XLSheetAddTable.shtml) to add a table to a sheet.
    - Added [XL.Sheet.SetBorder](https://www.mbsplugins.eu/XLSheetSetBorder.shtml) to set border fo sheet.
    - Fixed an error in [XL.Sheet.SetProtectEx](https://www.mbsplugins.eu/XLSheetSetProtectEx.shtml) function parsing the protection flags.
    - Fixed [XL.CopyCellValue](https://www.mbsplugins.eu/XLCopyCellValue.shtml), [XL.CopyColumn](https://www.mbsplugins.eu/XLCopyColumn.shtml) and [XL.CopyRow](https://www.mbsplugins.eu/XLCopyRow.shtml) to work if second document has more sheets.
    - Improved auto complete to work better with [XL](https://www.mbsplugins.eu/component_XL.shtml) functions.
- **Version 15.1**
    - Changed [XL](https://www.mbsplugins.eu/component_XL.shtml) functions to accept letters for column parameters.
- **Version 15.0**
    - Added DoBlanksForEmptyText parameter to [XL.Sheet.CellWriteTexts](https://www.mbsplugins.eu/XLSheetCellWriteTexts.shtml) function.
    - Added [XL.Book.GetCoreProperty](https://www.mbsplugins.eu/XLBookGetCoreProperty.shtml) and [XL.Book.SetCoreProperty](https://www.mbsplugins.eu/XLBookSetCoreProperty.shtml) functions.
    - Added [XL.Book.RemoveAllCoreProperties](https://www.mbsplugins.eu/XLBookRemoveAllCoreProperties.shtml) and [XL.Book.RemoveAllPhonetics](https://www.mbsplugins.eu/XLBookRemoveAllPhonetics.shtml) functions.
    - Added [XL.Sheet.ColFormat](https://www.mbsplugins.eu/XLSheetColFormat.shtml) and [XL.Sheet.RowFormat](https://www.mbsplugins.eu/XLSheetRowFormat.shtml) functions.
    - Fixed a problem with font handling for [XL](https://www.mbsplugins.eu/component_XL.shtml) functions.
- **Version 14.4**
    - Added [XL.Book.RemovePrinterSettings](https://www.mbsplugins.eu/XLBookRemovePrinterSettings.shtml) and [XL.Book.RemoveVBA](https://www.mbsplugins.eu/XLBookRemoveVBA.shtml) functions.
    - Improved check to [XL.Initialize](https://www.mbsplugins.eu/XLInitialize.shtml) to return an error if the license key includes invalid characters like a space character.
- **Version 14.3**
    - Added check to [XL.Initialize](https://www.mbsplugins.eu/XLInitialize.shtml) and [DynaPDF.Initialize](https://www.mbsplugins.eu/DynaPDFInitialize.shtml) to return an error if the license key includes invalid characters like a space character.
    - Changed [XL.Book.Version](https://www.mbsplugins.eu/XLBookVersion.shtml) to have the book parameter optional.
    - Fixed a memory leak in loading Excel file from disk with [XL.LoadBook](https://www.mbsplugins.eu/XLLoadBook.shtml) function.
    - Fixed a problem with [XL](https://www.mbsplugins.eu/component_XL.shtml) functions where license key was not recognized properly.
- **Version 14.2**
    - Added new [XL](https://www.mbsplugins.eu/component_XL.shtml) functions to create conditional formatting including [XL.Book.AddConditionalFormat](https://www.mbsplugins.eu/XLBookAddConditionalFormat.shtml) and [XL.Sheet.AddConditionalFormatting](https://www.mbsplugins.eu/XLSheetAddConditionalFormatting.shtml).
    - Added keepAllSheets parameter for [XL.LoadBookPartially](https://www.mbsplugins.eu/XLLoadBookPartially.shtml) function.
    - Added SVG for [XL.Book.GetPictureType](https://www.mbsplugins.eu/XLBookGetPictureType.shtml) and [XL.Book.GetPicture](https://www.mbsplugins.eu/XLBookGetPicture.shtml).
    - Added work around for [XL.Book.GetPicture](https://www.mbsplugins.eu/XLBookGetPicture.shtml) to return image data, even if LibXL returns an error, but does provide data.
    - Improved handling of font and format reference numbers in [XL](https://www.mbsplugins.eu/component_XL.shtml) functions to cache the objects and reuse the indexes.
    - Improved [XL.Book.GetPicture](https://www.mbsplugins.eu/XLBookGetPicture.shtml) to return future pictures types as FILE containers.
    - Improved [XL.Book.GetPictureType](https://www.mbsplugins.eu/XLBookGetPictureType.shtml) to report future types as number.

### Blog Entries

- [MBS Plugin 16.0 for Claris FileMaker - More than 7800 functions in one plugin](https://www.mbsplugins.de/archive/2026-01-13/MBS_Plugin_160_for_Claris_File/monkeybreadsoftware_blog_filemaker)
- [MBS Plugin 15.2 for Claris FileMaker](https://www.mbsplugins.de/archive/2025-05-06/MBS_Plugin_152_for_Claris_File/monkeybreadsoftware_blog_filemaker)
- [MBS Plugin 15.1 for Claris FileMaker](https://www.mbsplugins.de/archive/2025-03-11/MBS_Plugin_151_for_Claris_File/monkeybreadsoftware_blog_filemaker)
- [MBS @ FMTraining.TV - 15.0 MonkeyBread FileMaker Plug-in Release with Christian Schmitz](https://www.mbsplugins.de/archive/2025-01-22/MBS_@_FMTrainingTV_-_150_Monke/monkeybreadsoftware_blog_filemaker)
- [MBS Plugin 15.0 for Claris FileMaker](https://www.mbsplugins.de/archive/2025-01-14/MBS_Plugin_150_for_Claris_File/monkeybreadsoftware_blog_filemaker)
- [MBS @ FMTraining.TV - Exporting to Excel from FileMaker using MBS](https://www.mbsplugins.de/archive/2024-12-18/MBS_@_FMTrainingTV_-_Exporting/monkeybreadsoftware_blog_filemaker)
- [New in MBS FileMaker Plugin 14.4](https://www.mbsplugins.de/archive/2024-09-24/New_in_MBS_FileMaker_Plugin_14/monkeybreadsoftware_blog_filemaker)
- [MBS Plugin 14.4 for Claris FileMaker](https://www.mbsplugins.de/archive/2024-09-17/MBS_Plugin_144_for_Claris_File/monkeybreadsoftware_blog_filemaker)
- [MBS @ dotfmp 2024](https://www.mbsplugins.de/archive/2024-06-17/MBS_@_dotfmp_2024/monkeybreadsoftware_blog_filemaker)
- [MBS @ FMTraining.TV - Exporting FileMaker Settings into Excel Files using the MonkeyBread Plug-in with Christian Schmitz](https://www.mbsplugins.de/archive/2024-06-05/MBS_@_FMTrainingTV_-_Exporting/monkeybreadsoftware_blog_filemaker)

### FileMaker Magazin

- [Ausgabe 1/2025, Seite 27 bis 29](https://filemaker-magazin.de/neuigkeit/4282-Appetithappen-FMM_202501)
- [Ausgabe 5/2022, Seite 21 bis 23](https://filemaker-magazin.de/neuigkeit/4196-Appetithappen-FMM_202205)
- [Ausgabe 6/2020, Seite 24](https://filemaker-magazin.de/neuigkeit/4118-Appetithappen-FMM_202006)

### Example Databases

- [XL/AutoFilter](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/AutoFilter.shtml#1ScriptAnchor_)
- [XL/Change Column Names](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Change%20Column%20Names.shtml#5ScriptAnchor_)
- [XL/Conditional Formatting](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Conditional%20Formatting.shtml#1ScriptAnchor_)
- [XL/Converter](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Converter.shtml#1ScriptAnchor_)
- [XL/Edit Sheet](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Edit%20Sheet.shtml#1ScriptAnchor_)
- [XL/Export records](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Export%20records.shtml#1ScriptAnchor_)
- [XL/Writing data](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/Writing%20data.shtml#1ScriptAnchor_)
- [XL/XL Import and Export](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/XL%20Import%20and%20Export.shtml#1ScriptAnchor_)
- [XL/XL Test](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/XL/XL%20Test.shtml#1ScriptAnchor_)

[HTML Version](component_XL.shtml)