Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

New in version 3.5

Item Details Server
Addressbook.LocalizedPropertyOrLabel   Deprecated
Queries a localized name for a label or property.
Mac only
  ❌ Server
Addressbook.Notification.Clear   Deprecated
Clears the registered notification script.
Mac only
  ❌ Server
Addressbook.Notification.GetChangedExternally   Deprecated
Queries if the last notification script call was caused by a changed in another app.
Mac only
  ❌ Server
Addressbook.Notification.GetDeletedRecords   Deprecated
Queries list of deleted records.
Mac only
  ❌ Server
Addressbook.Notification.GetInsertedRecords   Deprecated
Queries list of inserted records.
Mac only
  ❌ Server
Addressbook.Notification.GetProcessID   Deprecated
Queries the process ID.
Mac only
  ❌ Server
Addressbook.Notification.GetProcessName   Deprecated
Queries the process name.
Mac only
  ❌ Server
Addressbook.Notification.GetUpdatedRecords   Deprecated
Queries list of updated records.
Mac only
  ❌ Server
Addressbook.Notification.GetUserUID   Deprecated
Queries the user ID.
Mac only
  ❌ Server
Addressbook.Notification.Set   Deprecated
Installs a notification script.
Mac only
  ❌ Server
Addressbook.personFromVCardTextRepresentation   Deprecated
Creates an Person instance initialized with the given text.
Mac/iOS
  ❌ Server
Addressbook.searchPeopleWithCreationDate   Deprecated
Searches for people in address book with creation date between both dates.
Mac only
  ❌ Server
Addressbook.searchPeopleWithModificationDate   Deprecated
Searches for people in address book with modification date between both dates.
Mac only
  ❌ Server
App.GetProcessPath
Queries the path of the application.
All
  ✅ Server
Barcode.Detect   Deprecated
Detects a barcode.
All
  ✅ Server
Barcode.DrawBarcode
Draws a barcode into a PDF page.
All
  ✅ Server
Barcode.Generate
Generates a barcode.
All
  ✅ Server
Barcode.UPCChecksum
Calculates checksum for UPC barcodes.
All
  ✅ Server
CURL.SetOptionTLSAuthPassword
Sets the TSL authentication password.
All
  ✅ Server
CURL.SetOptionTLSAuthType
Sets the TLS authentication type.
All
  ✅ Server
CURL.SetOptionTLSAuthUsername
Sets the TSL authentication user name.
All
  ✅ Server
Calendar.Alarm.Duplicate
Creates a copy of an alarm.
Mac only
  ❌ Server
Calendar.Alarm.GetAbsoluteTrigger
Queries the absolute trigger timestamp.
Mac only
  ❌ Server
Calendar.Alarm.GetAcknowledged
Queries acknowledged flag.
Mac only
  ❌ Server
Calendar.Alarm.GetAction
Queries the action for this alarm.
Mac only
  ❌ Server
Calendar.Alarm.GetEmailAddress
Queries the email address for an alarm.
Mac only
  ❌ Server
Calendar.Alarm.GetRelatedTo
Queries the related to setting.
Mac only
  ❌ Server
Calendar.Alarm.GetRelativeTrigger
Queries the relative trigger value.
Mac only
  ❌ Server
Calendar.Alarm.GetSound
Queries the sounds for this alarm.
Mac only
  ❌ Server
Calendar.Alarm.GetURL
Queries the URL of the alarm.
Mac only
  ❌ Server
Calendar.Alarm.SetAbsoluteTrigger
Sets the absolute trigger timestamp.
Mac only
  ❌ Server
Calendar.Alarm.SetAcknowledged
Sets acknowledged flag.
Mac only
  ❌ Server
Calendar.Alarm.SetAction
Sets an action for this alarm.
Mac only
  ❌ Server
Calendar.Alarm.SetEmailAddress
Sets the email address for this alarm.
Mac only
  ❌ Server
Calendar.Alarm.SetRelatedTo
Sets the related to setting.
Mac only
  ❌ Server
Calendar.Alarm.SetRelativeTrigger
Sets the relative trigger value.
Mac only
  ❌ Server
Calendar.Alarm.SetSound
Sets the sounds for this alarm.
Mac only
  ❌ Server
Calendar.Alarm.SetURL
Sets the URL of the alarm.
Mac only
  ❌ Server
Calendar.Alarm.TriggerDateRelativeTo
Queries the relative trigger date for this alarm.
Mac only
  ❌ Server
Calendar.Attendee.GetAddress
Returns URL address of attendee entry.
Mac only
  ❌ Server
Calendar.Attendee.GetCommonName
Returns the user-entered name of the attendee.
Mac only
  ❌ Server
Calendar.Attendee.GetStatus
Returns status of attendee.
Mac only
  ❌ Server
Calendar.Item.AddAlarm
Adds an alarm to a calendar item.
Mac only
  ❌ Server
Calendar.Item.GetAlarms
Queries the list of alarms for this item.
Mac only
  ❌ Server
Calendar.Item.GetAttendees
Queries the list of attendees for this event.
Mac only
  ❌ Server
Calendar.Item.RemoveAlarm
Removes an alarm from an item.
Mac only
  ❌ Server
Calendar.NewAlarm
Creates a new alarm.
Mac only
  ❌ Server
Calendar.Notification.Clear
Clears the registered notification script.
Mac only
  ❌ Server
Calendar.Notification.GetChangedExternally
Queries if the last notification script call was caused by a changed in another app.
Mac only
  ❌ Server
Calendar.Notification.GetDeletedRecords
Queries list of deleted records.
Mac only
  ❌ Server
Calendar.Notification.GetInsertedRecords
Queries list of inserted records.
Mac only
  ❌ Server
Calendar.Notification.GetProcessID
Queries the process ID.
Mac only
  ❌ Server
Calendar.Notification.GetProcessName
Queries the process name.
Mac only
  ❌ Server
Calendar.Notification.GetUpdatedRecords
Queries list of updated records.
Mac only
  ❌ Server
Calendar.Notification.GetUserUID
Queries the user ID.
Mac only
  ❌ Server
Calendar.Notification.GetWhat
Queries what changed in the database.
Mac only
  ❌ Server
Calendar.Notification.Set
Installs a notification script.
Mac only
  ❌ Server
DynaPDF.GetImportOrientation
Queries orientation for input page.
All
  ✅ Server
DynaPDF.GetOrientation
Queries orientation of current page.
All
  ✅ Server
DynaPDF.HighlightPattern
Searches a text and adds highlights for it.
All
  ✅ Server
DynaPDF.New
Creates a new DynaPDF instance.
All
  ✅ Server
DynaPDF.Release
Releases a PDF reference.
All
  ✅ Server
DynaPDF.SetOrientation
Changes the orientation of the page.
All
  ✅ Server
DynaPDF.SetOrientationEx
Changes the orientation of the page.
All
  ✅ Server
DynaPDF.Table.AddColumn
Adds a column on the left or right side of the table.
All
  ✅ Server
DynaPDF.Table.AddRow
Adds a new row to the table.
All
  ✅ Server
DynaPDF.Table.AddRows
Adds new rows to the table.
All
  ✅ Server
DynaPDF.Table.ClearColumn
Deletes the content in the specified column in all rows.
All
  ✅ Server
DynaPDF.Table.ClearContent
Deletes the specified object types from the table.
All
  ✅ Server
DynaPDF.Table.ClearRow
The function deletes the content in the specified row.
All
  ✅ Server
DynaPDF.Table.Create
Creates a new table object.
All
  ✅ Server
DynaPDF.Table.DeleteCol
Deletes a column from the table.
All
  ✅ Server
DynaPDF.Table.DeleteRow
Deletes a row from the table.
All
  ✅ Server
DynaPDF.Table.DeleteRows
Deletes all rows from the table.
All
  ✅ Server
DynaPDF.Table.Draw
Draws the table on the specified position.
All
  ✅ Server
DynaPDF.Table.GetFirstRow
Queres first row drawn.
All
  ✅ Server
DynaPDF.Table.GetNextHeight
Calculates the height of the table.
All
  ✅ Server
DynaPDF.Table.GetNextHeightRow
Calculates the height of the table.
All
  ✅ Server
DynaPDF.Table.GetNextRow
Queres next row to be drawn.
All
  ✅ Server
DynaPDF.Table.GetNumCols
Queries number of columns in table.
All
  ✅ Server
DynaPDF.Table.GetNumRows
Queries number of rows in table.
All
  ✅ Server
DynaPDF.Table.GetPDF
Returns the reference to the PDF.
All
  ✅ Server
DynaPDF.Table.GetTableHeight
Returns the full height of the table.
All
  ✅ Server
DynaPDF.Table.GetTableWidth
Returns the width of the table.
All
  ✅ Server
DynaPDF.Table.HaveMore
Checks whether all rows where drawn.
All
  ✅ Server
DynaPDF.Table.Release
Releases the PDF table.
All
  ✅ Server
DynaPDF.Table.SetBorderWidth
Sets or changes the border width.
All
  ✅ Server
DynaPDF.Table.SetBoxProperty
Sets or changes the border width, cell spacing, or cell padding.
All
  ✅ Server
DynaPDF.Table.SetCellImage
Inserts an image horizontally and vertically aligned as specified.
All
  ✅ Server
DynaPDF.Table.SetCellImageEx
Inserts an image from container.
All
  ✅ Server
DynaPDF.Table.SetCellOrientation
Sets the cell orientation.
All
  ✅ Server
DynaPDF.Table.SetCellPadding
Sets or changes the cell padding.
All
  ✅ Server
DynaPDF.Table.SetCellSpacing
Sets or changes the cell spacing.
All
  ✅ Server
DynaPDF.Table.SetCellTable
Inserts a sub table into the specified cell.
All
  ✅ Server
DynaPDF.Table.SetCellTemplate
Inserts a template into the specified cell.
All
  ✅ Server
DynaPDF.Table.SetCellText
Inserts the specified text into the cell.
All
  ✅ Server
DynaPDF.Table.SetColWidth
The function changes the width of a column.
All
  ✅ Server
DynaPDF.Table.SetColor
Sets or changes the specified color as well as the corresponding device color space.
All
  ✅ Server
DynaPDF.Table.SetColorFloat
Sets or changes the specified color and color space.
All
  ✅ Server
DynaPDF.Table.SetFlags
The function sets various flags.
All
  ✅ Server
DynaPDF.Table.SetFont
Sets the font that is used to output text.
All
  ✅ Server
DynaPDF.Table.SetFontSelMode
The function sets or changes the font selection mode.
All
  ✅ Server
DynaPDF.Table.SetFontSize
Sets or changes the font size.
All
  ✅ Server
DynaPDF.Table.SetGridWidth
Sets the grid width.
All
  ✅ Server
DynaPDF.Table.SetPDF
Changes the PDF instance that is associated with the table.
All
  ✅ Server
DynaPDF.Table.SetRGBColor
Sets RGB color.
All
  ✅ Server
DynaPDF.Table.SetRowHeight
Changes the row height.
All
  ✅ Server
DynaPDF.Table.SetTableWidth
Changes the width of the table.
All
  ✅ Server
FM.ExecuteFileSQL
Execute the SQL Statement against a FileMaker database.
All
  ✅ Server
Files.GetTagNames
Queries names of the tags assigned to the file/folder.
Mac only
  ✅ Server
Files.ReadFile
Reads a file with the given path.
All
  ✅ Server
Files.SetTagNames
Sets the tags for a file/folder.
Mac only
  ✅ Server
Files.WriteFile
Writes a file with the given data.
All
  ✅ Server
GMImage.Strip
Remove all profiles and text attributes from the image.
All
  ✅ Server
IKPictureTaker.ClearNotification
Clears the script to be called.
Mac only
  ❌ Server
IKPictureTaker.GetAllowsEditing
Queries whether image editing is allowed.
Mac only
  ❌ Server
IKPictureTaker.GetAllowsFileChoosing
Queries whether image files can be chosen.
Mac only
  ❌ Server
IKPictureTaker.GetAllowsVideoCapture
Queries whether video capture is allowed.
Mac only
  ❌ Server
IKPictureTaker.GetInformationalText
Queries informational text.
Mac only
  ❌ Server
IKPictureTaker.GetInputImage
Return the original PictureTaker's input-image.
Mac only
  ❌ Server
IKPictureTaker.GetMirroring
Queries video mirroring status.
Mac only
  ❌ Server
IKPictureTaker.GetOutputImage
Return the edited image.
Mac only
  ❌ Server
IKPictureTaker.GetOutputImageMaxHeight
Queries the maximum allowed image height.
Mac only
  ❌ Server
IKPictureTaker.GetOutputImageMaxWidth
Queries the maximum allowed image width.
Mac only
  ❌ Server
IKPictureTaker.GetRemainOpenAfterValidate
Queries whether the picture taker should remain open after the user selects done.
Mac only
  ❌ Server
IKPictureTaker.GetShowAddressBookPicture
Queries whether addressbook pictures are shown.
Mac only
  ❌ Server
IKPictureTaker.GetShowEffects
Queries whether to show effects.
Mac only
  ❌ Server
IKPictureTaker.GetShowEmptyPicture
Queries the image to be shown for empty picture.
Mac only
  ❌ Server
IKPictureTaker.GetShowRecentPicture
Queries whether to show recent pictures.
Mac only
  ❌ Server
IKPictureTaker.GetUpdateRecentPicture
Queries whether to allow a recent picture to be updated.
Mac only
  ❌ Server
IKPictureTaker.Run
Launch the PictureTaker.
Mac only
  ❌ Server
IKPictureTaker.SetAllowsEditing
Sets whether image editing is allowed.
Mac only
  ❌ Server
IKPictureTaker.SetAllowsFileChoosing
Sets whether image files can be chosen.
Mac only
  ❌ Server
IKPictureTaker.SetAllowsVideoCapture
Sets whether video capture is allowed.
Mac only
  ❌ Server
IKPictureTaker.SetInformationalText
Sets informational text.
Mac only
  ❌ Server
IKPictureTaker.SetInputImage
Set the image input for the PictureTaker.
Mac only
  ❌ Server
IKPictureTaker.SetMirroring
Controls whether the receiver enable/disable video mirroring durring snapshots (default is on).
Mac only
  ❌ Server
IKPictureTaker.SetNotification
Installs a notification script.
Mac only
  ❌ Server
IKPictureTaker.SetOutputImageMaxSize
Sets maximum size of the output image.
Mac only
  ❌ Server
IKPictureTaker.SetRemainOpenAfterValidate
Sets whether the picture taker should remain open after the user selects done.
Mac only
  ❌ Server
IKPictureTaker.SetShowAddressBookPicture   Deprecated
Sets whether address book pictures are shown.
Mac only
  ❌ Server
IKPictureTaker.SetShowEffects
Sets whether to show effects.
Mac only
  ❌ Server
IKPictureTaker.SetShowEmptyPicture
Sets the image to be shown for empty picture.
Mac only
  ❌ Server
IKPictureTaker.SetShowRecentPicture
Sets whether to show recent pictures.
Mac only
  ❌ Server
IKPictureTaker.SetUpdateRecentPicture
Sets whether to allow a recent picture to be updated.
Mac only
  ❌ Server
MediaLibraryBrowser.getMediaLibraries
Queries which media libraries are currently showing.
Mac only
  ❌ Server
MediaLibraryBrowser.getVisible
Queries visible state of the browser panel.
Mac only
  ❌ Server
MediaLibraryBrowser.setFrame
Sets the panel rectangle.
Mac only
  ❌ Server
MediaLibraryBrowser.setMediaLibraries
Sets which media type is shown in browser.
Mac only
  ❌ Server
MediaLibraryBrowser.setVisible
Sets visible state of the panel.
Mac only
  ❌ Server
MediaLibraryBrowser.togglePanel
Toggles the panel.
Mac only
  ❌ Server
PrintDialog.Disable
Disables the print dialog extension.
Mac only
  ❌ Server
PrintDialog.Enable
Enables the print dialog extension.
Mac only
  ❌ Server
PrintDialog.GetDestinationPath
Queries the destination path.
Mac only
  ❌ Server
PrintDialog.GetNoDialog
Queries whether dialog shows.
Mac only
  ❌ Server
PrintDialog.GetPrintToPDF
Queries whether printing is going to PDF file.
Mac only
  ❌ Server
PrintDialog.GetPrinterName
Queries printer name to use.
Mac only
  ❌ Server
PrintDialog.Install
Installs the extension for the printer dialog.
Mac only
  ❌ Server
PrintDialog.SetDestinationPath
Sets the destination path for PDF.
Mac only
  ❌ Server
PrintDialog.SetNoDialog
Sets whether dialog should show.
Mac only
  ❌ Server
PrintDialog.SetPrintToPDF
Sets whether plugin will redirect print to PDF.
Mac only
  ❌ Server
PrintDialog.SetPrinterName
Sets printer name.
Mac only
  ❌ Server
RichText.Clear
Clears current document.
Mac/iOS
  ✅ Server
RichText.SetAttribute
Sets metadata.
Mac/iOS
  ✅ Server
RichText.SetFormattedText
Sets new text for saving a document.
Mac/iOS
  ✅ Server
RichText.SetText
Sets new text for saving a document.
Mac/iOS
  ✅ Server
RichText.WriteDOC
Writes a Word file.
Mac only
  ✅ Server
RichText.WriteRTF
Writes a RTF file.
Mac/iOS
  ✅ Server
Socket.SSL.Accept
Wait for a TLS/SSL client to initiate a TLS/SSL handshake.
All
  ✅ Server
Socket.SSL.Connect
Initiate the TLS/SSL handshake with an TLS/SSL server.
All
  ✅ Server
Socket.SSL.GetMethod
Queries the SSL method.
All
  ✅ Server
Socket.SSL.Initialize
Initializes a SSL connection.
All
  ✅ Server
Socket.SSL.Prepare
First step in SSL initialization.
All
  ✅ Server
Socket.SSL.SetMethod
Sets the SSL method for this socket.
All
  ✅ Server
Socket.SSL.UseCertificateFile
Defines to use a certificate key file for this SSL socket.
All
  ✅ Server
Socket.SSL.UsePrivateKeyFile
Defines to use a private key file for this SSL socket.
All
  ✅ Server
SyntaxColoring.CheckVariableDeclaration.Disable
Disables checking variable declarations in FileMaker Scripts.
Mac only
  ❌ Server
SyntaxColoring.CheckVariableDeclaration.Enable
Enables checking variable declarations in FileMaker Scripts.
Mac only
  ❌ Server
SyntaxColoring.CheckVariableDeclaration.Enabled
Queries if checking variable declarations are enabled or not.
Mac only
  ❌ Server
SyntaxColoring.LineNumbers.Disable   Deprecated
Disables line numbers in FileMaker Scripts.
Mac only
  ❌ Server
SyntaxColoring.LineNumbers.Enable   Deprecated
Enables line numbers in FileMaker Scripts.
Mac only
  ❌ Server
SyntaxColoring.LineNumbers.Enabled   Deprecated
Queries if line numbers are enabled or not.
Mac only
  ❌ Server
SyntaxColoring.LineNumbers.GetColor   Deprecated
Queries the current color for line numbers.
Mac only
  ❌ Server
SyntaxColoring.LineNumbers.SetColor   Deprecated
Sets the new color to use for line numbers.
Mac only
  ❌ Server
SystemInfo.isMavericks
Whether the operation system is macOS 10.9 Mavericks or newer.
All
  ✅ Server
Text.SoundExGerman
Returns soundex string for the given text.
All
  ✅ Server
Twain.GetAutomaticBrightness
Queries the Source's Auto-brightness function (if any).
Mac/Win
  ❌ Server
Twain.GetBrightness
Queries the brightness setting to use.
Mac/Win
  ❌ Server
Twain.GetContrast
Queries which contrast value to use.
Mac/Win
  ❌ Server
Twain.GetGamma
Queries the gamma correction value for the image data.
Mac/Win
  ❌ Server
Twain.GetHighlight
Queries which value to use for highlight.
Mac/Win
  ❌ Server
Twain.GetShadow
Queries which value in an image should be interpreted as the darkest shadow.
Mac/Win
  ❌ Server
Twain.SetAutomaticBrightness
Enables or disables the Source's Auto-brightness function (if any).
Mac/Win
  ❌ Server
Twain.SetBrightness
Sets the brightness setting to use.
Mac/Win
  ❌ Server
Twain.SetContrast
Sets which contrast value to use.
Mac/Win
  ❌ Server
Twain.SetGamma
Sets the gamma correction value for the image data.
Mac/Win
  ❌ Server
Twain.SetHighlight
Specifies which value in an image should be interpreted as the lightest highlight.
Mac/Win
  ❌ Server
Twain.SetShadow
Specifies which value in an image should be interpreted as the darkest shadow.
Mac/Win
  ❌ Server
UserNotification.ContentImage
Queries image shown in the content of the notification.
Mac only
  ❌ Server
UserNotification.GetIdentifier
Queries the identifier used to uniquely identify a notification.
Mac only
  ❌ Server
UserNotification.GetResponse
Queries the response text.
Mac only
  ❌ Server
UserNotification.GetResponsePlaceholder
Queries the optional placeholder for inline reply field.
Mac only
  ❌ Server
UserNotification.HasReplyButton
Queries whether the notification has a reply button.
Mac only
  ❌ Server
UserNotification.SetContentImage
Sets image shown in the content of the notification.
Mac only
  ❌ Server
UserNotification.SetHasReplyButton
Sets whether the notification has a reply button.
Mac only
  ❌ Server
UserNotification.SetIdentifier
Sets the identifier used to uniquely identify a notification.
Mac only
  ❌ Server
UserNotification.SetResponsePlaceholder
Sets the optional placeholder for inline reply field.
Mac only
  ❌ Server
XL.Book.AddCustomNumFormat
Adds a new custom number format to the workbook.
All
  ✅ Server
XL.Book.AddFont
Adds a new font to the workbook, initial parameters can be copied from other font.
All
  ✅ Server
XL.Book.AddFormat
Adds a new format to the workbook, initial parameters can be copied from other format.
All
  ✅ Server
XL.Book.AddPictureContainer
Adds a picture to the workbook from container.
All
  ✅ Server
XL.Book.AddPictureFile
Adds a picture to the workbook.
All
  ✅ Server
XL.Book.AddSheet
Adds a new sheet to this book, returns the sheet index.
All
  ✅ Server
XL.Book.BiffVersion
Returns BIFF version of binary file.
All
  ✅ Server
XL.Book.CustomNumFormat
Returns a custom format string for specified custom format identifier fmt.
All
  ✅ Server
XL.Book.DeleteSheet
Deletes a sheet with specified index.
All
  ✅ Server
XL.Book.FontCount
Returns a number of fonts in this book.
All
  ✅ Server
XL.Book.FormatCount
Returns a number of formats in this book.
All
  ✅ Server
XL.Book.GetActiveSheet
Returns an active sheet index in this workbook.
All
  ✅ Server
XL.Book.GetDefaultFontName
Returns a default font name for this workbook.
All
  ✅ Server
XL.Book.GetDefaultFontSize
Returns a default font size for this workbook.
All
  ✅ Server
XL.Book.GetPicture
Returns a picture at position index.
All
  ✅ Server
XL.Book.GetPictureType
Returns a picture type at position index.
All
  ✅ Server
XL.Book.GetRGBMode
Returns whether the RGB mode is active.
All
  ✅ Server
XL.Book.GetRefR1C1
Returns whether the R1C1 reference mode is active.
All
  ✅ Server
XL.Book.GetText
Queries the text of a workbook.
All
  ✅ Server
XL.Book.InsertSheet
Inserts a new sheet to this book at position index, returns the new sheet index.
All
  ✅ Server
XL.Book.PictureCount
Returns a number of pictures in this workbook.
All
  ✅ Server
XL.Book.Release
Frees a workbook from memory.
All
  ✅ Server
XL.Book.Save
Writes excel file to container for storing in database.
All
  ✅ Server
XL.Book.SaveToFile
Saves current workbook into xls-file.
All
  ✅ Server
XL.Book.SetActiveSheet
Sets an active sheet index in this workbook.
All
  ✅ Server
XL.Book.SetDefaultFont
Sets a default font name and size for this workbook.
All
  ✅ Server
XL.Book.SetRGBMode
Sets a RGB mode.
All
  ✅ Server
XL.Book.SetRefR1C1
Sets the R1C1 reference mode.
All
  ✅ Server
XL.Book.SheetCount
Queries how many sheets are part of the workbook.
All
  ✅ Server
XL.Color.Pack
Packs red, green and blue components in color type.
All
  ✅ Server
XL.Color.UnPack
Unpacks color type to red, green and blue components.
All
  ✅ Server
XL.Date.Pack
Packs date and time information into double type.
All
  ✅ Server
XL.Date.UnPack
Unpacks date and time information from double type.
All
  ✅ Server
XL.Font.GetBold
Returns whether the font is bold.
All
  ✅ Server
XL.Font.GetColor
Returns the color of the font.
All
  ✅ Server
XL.Font.GetItalic
Returns whether the font is italic.
All
  ✅ Server
XL.Font.GetName
Returns the name of the font.
All
  ✅ Server
XL.Font.GetScript
Returns the script style of the font.
All
  ✅ Server
XL.Font.GetSize
Returns the size of the font in points.
All
  ✅ Server
XL.Font.GetStrikeOut
Returns whether the font is strikeout.
All
  ✅ Server
XL.Font.GetUnderline
Returns the underline style of the font.
All
  ✅ Server
XL.Font.SetBold
Turns on/off the bold font.
All
  ✅ Server
XL.Font.SetColor
Sets the color of the font.
All
  ✅ Server
XL.Font.SetItalic
Turns on/off the italic font.
All
  ✅ Server
XL.Font.SetName
Sets the name of the font.
All
  ✅ Server
XL.Font.SetScript
Sets the script style of the font.
All
  ✅ Server
XL.Font.SetSize
Sets the size of the font in points.
All
  ✅ Server
XL.Font.SetStrikeOut
Turns on/off the strikeout font.
All
  ✅ Server
XL.Font.SetUnderline
Sets the underline style of the font.
All
  ✅ Server
XL.Format.GetAlignH
Returns the horizontal alignment.
All
  ✅ Server
XL.Format.GetAlignV
Returns the vertical alignment.
All
  ✅ Server
XL.Format.GetBorderBottom
Returns the bottom border style.
All
  ✅ Server
XL.Format.GetBorderBottomColor
Returns the color of the bottom border.
All
  ✅ Server
XL.Format.GetBorderDiagonal
Returns the diagonal border.
All
  ✅ Server
XL.Format.GetBorderDiagonalColor
Returns the color of the diagonal border.
All
  ✅ Server
XL.Format.GetBorderDiagonalStyle
Gets the style for diagonal border.
All
  ✅ Server
XL.Format.GetBorderLeft
Returns the left border style.
All
  ✅ Server
XL.Format.GetBorderLeftColor
Returns the color of the left border.
All
  ✅ Server
XL.Format.GetBorderRight
Returns the right border style.
All
  ✅ Server
XL.Format.GetBorderRightColor
Returns the color of the right border.
All
  ✅ Server
XL.Format.GetBorderTop
Returns the top border style.
All
  ✅ Server
XL.Format.GetBorderTopColor
Returns the color of the top border.
All
  ✅ Server
XL.Format.GetFillPattern
Returns the fill pattern.
All
  ✅ Server
XL.Format.GetFont
Returns the font for this format.
All
  ✅ Server
XL.Format.GetHidden
Returns whether the hidden property is set to true.
All
  ✅ Server
XL.Format.GetIndent
Returns the text indentation level.
All
  ✅ Server
XL.Format.GetLocked
Returns whether the locked property is set to true.
All
  ✅ Server
XL.Format.GetNumFormat
Returns the number format identifier.
All
  ✅ Server
XL.Format.GetPatternBackgroundColor
Returns the background color of the fill pattern.
All
  ✅ Server
XL.Format.GetPatternForegroundColor
Returns the foreground color of the fill pattern.
All
  ✅ Server
XL.Format.GetRotation
Returns the text rotation.
All
  ✅ Server
XL.Format.GetShrinkToFit
Returns whether the cell is shrink-to-fit.
All
  ✅ Server
XL.Format.GetWrap
Returns whether the cell text is wrapped.
All
  ✅ Server
XL.Format.SetAlignH
Sets the horizontal alignment.
All
  ✅ Server
XL.Format.SetAlignV
Sets the vertical alignment.
All
  ✅ Server
XL.Format.SetBorder
Sets the border style.
All
  ✅ Server
XL.Format.SetBorderBottom
Sets the bottom border style.
All
  ✅ Server
XL.Format.SetBorderBottomColor
Sets the color of the bottom border.
All
  ✅ Server
XL.Format.SetBorderColor
Sets the border color.
All
  ✅ Server
XL.Format.SetBorderDiagonal
Sets the diagonal border.
All
  ✅ Server
XL.Format.SetBorderDiagonalColor
Sets the color of the diagonal border.
All
  ✅ Server
XL.Format.SetBorderDiagonalStyle
Sets the style for diagonal border.
All
  ✅ Server
XL.Format.SetBorderLeft
Sets the left border style.
All
  ✅ Server
XL.Format.SetBorderLeftColor
Sets the color of the left border.
All
  ✅ Server
XL.Format.SetBorderRight
Sets the right border style.
All
  ✅ Server
XL.Format.SetBorderRightColor
Sets the color of the right border.
All
  ✅ Server
XL.Format.SetBorderTop
Sets the top border style.
All
  ✅ Server
XL.Format.SetBorderTopColor
Sets the color of the top border.
All
  ✅ Server
XL.Format.SetFillPattern
Sets the fill pattern.
All
  ✅ Server
XL.Format.SetFont
Sets the font for the format.
All
  ✅ Server
XL.Format.SetHidden
Sets the hidden property.
All
  ✅ Server
XL.Format.SetIndent
Sets the text indentation level.
All
  ✅ Server
XL.Format.SetLocked
Sets the locked property.
All
  ✅ Server
XL.Format.SetNumFormat
Sets the number format identifier.
All
  ✅ Server
XL.Format.SetPatternBackgroundColor
Sets the background color of the fill pattern.
All
  ✅ Server
XL.Format.SetPatternForegroundColor
Sets the foreground color of the fill pattern.
All
  ✅ Server
XL.Format.SetRotation
Sets the text rotation.
All
  ✅ Server
XL.Format.SetShrinkToFit
Sets the flag whether the cell is shrink-to-fit.
All
  ✅ Server
XL.Format.SetWrap
Sets the flag whether the cell text is wrapped.
All
  ✅ Server
XL.Sheet.AddrToRowCol
Converts a cell reference to row and column.
All
  ✅ Server
XL.Sheet.CellIsDate
Checks that cell contains a date or time value.
All
  ✅ Server
XL.Sheet.CellIsFormula
Checks that cell contains a formula.
All
  ✅ Server
XL.Sheet.CellReadBlank
Checks if cell is blank.
All
  ✅ Server
XL.Sheet.CellReadBoolean
Reads a boolean value from a cell.
All
  ✅ Server
XL.Sheet.CellReadComment
Reads a comment value from a cell.
All
  ✅ Server
XL.Sheet.CellReadFormula
Reads the formula value from a cell.
All
  ✅ Server
XL.Sheet.CellReadNumber
Reads a number value from a cell.
All
  ✅ Server
XL.Sheet.CellReadText
Reads a text value from a cell.
All
  ✅ Server
XL.Sheet.CellType
Queries type of cell.
All
  ✅ Server
XL.Sheet.CellWriteBlank
Writes a blank cell.
All
  ✅ Server
XL.Sheet.CellWriteBoolean
Writes a boolean value into cell.
All
  ✅ Server
XL.Sheet.CellWriteComment
Writes a comment to a cell.
All
  ✅ Server
XL.Sheet.CellWriteFormula
Writes a formula into cell.
All
  ✅ Server
XL.Sheet.CellWriteNumber
Writes a number into cell.
All
  ✅ Server
XL.Sheet.CellWriteText
Writes a string into cell.
All
  ✅ Server
XL.Sheet.Clear
Clears cells in specified area.
All
  ✅ Server
XL.Sheet.ClearPrintArea
Clears the print area.
All
  ✅ Server
XL.Sheet.ClearPrintRepeats
Clears repeated rows and columns on each page.
All
  ✅ Server
XL.Sheet.CopyCell
Copies cell with format from (rowSrc, colSrc) to (rowDst, colDst).
All
  ✅ Server
XL.Sheet.DeleteMerge
Removes merged cells.
All
  ✅ Server
XL.Sheet.DeleteNamedRange
Deletes the named range by name.
All
  ✅ Server
XL.Sheet.GetCellError
Reads error from cell.
All
  ✅ Server
XL.Sheet.GetCellFormat
Returns cell's format.
All
  ✅ Server
XL.Sheet.GetColHidden
Returns whether column is hidden.
All
  ✅ Server
XL.Sheet.GetColWidth
Returns column width in points.
All
  ✅ Server
XL.Sheet.GetDisplayGridlines
Returns whether the gridlines are displayed.
All
  ✅ Server
XL.Sheet.GetFirstCol
Returns the first column in the sheet that contains a used cell.
All
  ✅ Server
XL.Sheet.GetFirstRow
Returns the first row in the sheet that contains a used cell.
All
  ✅ Server
XL.Sheet.GetFooter
Returns the footer text of the sheet when printed.
All
  ✅ Server
XL.Sheet.GetFooterMargin
Returns the footer margin in inches.
All
  ✅ Server
XL.Sheet.GetGroupSummaryBelow
Returns whether grouping rows summary is below.
All
  ✅ Server
XL.Sheet.GetGroupSummaryRight
Returns whether grouping columns summary is right.
All
  ✅ Server
XL.Sheet.GetHCenter
Returns whether the sheet is centered horizontally when printed.
All
  ✅ Server
XL.Sheet.GetHeader
Returns the header text of the sheet when printed.
All
  ✅ Server
XL.Sheet.GetHeaderMargin
Returns the header margin in inches.
All
  ✅ Server
XL.Sheet.GetHidden
Returns whether sheet is hidden.
All
  ✅ Server
XL.Sheet.GetHorPageBreak
Returns row with horizontal page break at position index.
All
  ✅ Server
XL.Sheet.GetHorPageBreakCount
Returns a number of horizontal page breaks in the sheet.
All
  ✅ Server
XL.Sheet.GetLandscape
Returns a page orientation mode.
All
  ✅ Server
XL.Sheet.GetLastCol
Returns the zero-based index of the column after the last column in the sheet that contains a used cell.
All
  ✅ Server
XL.Sheet.GetLastRow
Returns the zero-based index of the row after the last row in the sheet that contains a used cell.
All
  ✅ Server
XL.Sheet.GetMarginBottom
Returns the bottom margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.GetMarginLeft
Returns the left margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.GetMarginRight
Returns the right margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.GetMarginTop
Returns the top margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.GetMerge
Gets merged cells for cell at row, col.
All
  ✅ Server
XL.Sheet.GetName
Returns the name of the sheet.
All
  ✅ Server
XL.Sheet.GetNamedRange
Gets the named range coordianates by name.
All
  ✅ Server
XL.Sheet.GetPaper
Returns the paper size.
All
  ✅ Server
XL.Sheet.GetPicture
Returns a workbook picture index at position index in worksheet.
All
  ✅ Server
XL.Sheet.GetPrintFit
Returns whether fit to page option is enabled.
All
  ✅ Server
XL.Sheet.GetPrintGridlines
Returns whether the gridlines are printed.
All
  ✅ Server
XL.Sheet.GetPrintRow
Returns whether the row and column headers are printed.
All
  ✅ Server
XL.Sheet.GetPrintZoom
Returns the scaling factor for printing as a percentage.
All
  ✅ Server
XL.Sheet.GetProtect
Returns whether sheet is protected.
All
  ✅ Server
XL.Sheet.GetRowHeight
Returns row height in points.
All
  ✅ Server
XL.Sheet.GetRowHidden
Returns whether row is hidden.
All
  ✅ Server
XL.Sheet.GetText
Queries the text of a sheet in a workbook.
All
  ✅ Server
XL.Sheet.GetTopLeftView
Extracts the first visible row and the leftmost visible column of the sheet.
All
  ✅ Server
XL.Sheet.GetVCenter
Returns whether the sheet is centered vertically when printed.
All
  ✅ Server
XL.Sheet.GetVerPageBreak
Returns column with vertical page break at position index.
All
  ✅ Server
XL.Sheet.GetVerPageBreakCount
Returns a number of vertical page breaks in the sheet.
All
  ✅ Server
XL.Sheet.GetZoom
Returns the zoom level of the current view as a percentage.
All
  ✅ Server
XL.Sheet.GroupCols
Groups columns from colFirst to colLast.
All
  ✅ Server
XL.Sheet.GroupRows
Groups rows from rowFirst to rowLast.
All
  ✅ Server
XL.Sheet.InsertCol
Inserts columns from colFirst to colLast.
All
  ✅ Server
XL.Sheet.InsertRow
Inserts rows from rowFirst to rowLast.
All
  ✅ Server
XL.Sheet.NamedRange
Gets the named range coordinates by index.
All
  ✅ Server
XL.Sheet.NamedRangeCount
Returns the number of named ranges in the sheet.
All
  ✅ Server
XL.Sheet.PictureCount
Returns a number of pictures in this worksheet.
All
  ✅ Server
XL.Sheet.RemoveCol
Removes columns from colFirst to colLast.
All
  ✅ Server
XL.Sheet.RemoveRow
Removes rows from rowFirst to rowLast.
All
  ✅ Server
XL.Sheet.RowColToAddr
Converts row and column to a cell reference.
All
  ✅ Server
XL.Sheet.SetCellFormat
Sets cell's format.
All
  ✅ Server
XL.Sheet.SetCol
Sets column width and format for all columns from colFirst to colLast.
All
  ✅ Server
XL.Sheet.SetColHidden
Hides or shows a column.
All
  ✅ Server
XL.Sheet.SetColumn
Sets column width and format for all columns from colFirst to colLast.
All
  ✅ Server
XL.Sheet.SetDisplayGridlines
Sets gridlines for displaying.
All
  ✅ Server
XL.Sheet.SetFooter
Sets the footer text for the sheet when printed.
All
  ✅ Server
XL.Sheet.SetGroupSummaryBelow
Sets a flag of grouping rows summary.
All
  ✅ Server
XL.Sheet.SetGroupSummaryRight
Sets a flag of grouping rows summary.
All
  ✅ Server
XL.Sheet.SetHCenter
Sets a flag that the sheet is centered horizontally when printed.
All
  ✅ Server
XL.Sheet.SetHeader
Sets the header text of the sheet when printed.
All
  ✅ Server
XL.Sheet.SetHorPageBreak
Sets/removes a horizontal page break.
All
  ✅ Server
XL.Sheet.SetLandscape
Sets landscape or portrait mode for printing.
All
  ✅ Server
XL.Sheet.SetMarginBottom
Sets the bottom margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.SetMarginLeft
Sets the left margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.SetMarginRight
Sets the right margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.SetMarginTop
Sets the top margin of the sheet in inches.
All
  ✅ Server
XL.Sheet.SetMerge
Sets merged cells for range: rowFirst - rowLast, colFirst - colLast.
All
  ✅ Server
XL.Sheet.SetName
Sets the name of the sheet.
All
  ✅ Server
XL.Sheet.SetNamedRange
Sets the named range.
All
  ✅ Server
XL.Sheet.SetPaper
Sets the paper size.
All
  ✅ Server
XL.Sheet.SetPictureWithScale
Sets a picture with pictureId identifier at position row and col with scale factor and offsets in pixels.
All
  ✅ Server
XL.Sheet.SetPictureWithSize
Sets a picture with pictureId identifier at position row and col with custom size and offsets in pixels.
All
  ✅ Server
XL.Sheet.SetPrintArea
Sets the print area.
All
  ✅ Server
XL.Sheet.SetPrintFit
Fits sheet width and sheet height to wPages and hPages respectively.
All
  ✅ Server
XL.Sheet.SetPrintGridliens
Sets gridlines for printing.
All
  ✅ Server
XL.Sheet.SetPrintRepeatCols
Sets repeated columns on each page from colFirst to colLast.
All
  ✅ Server
XL.Sheet.SetPrintRepeatRows
Sets repeated rows on each page from rowFirst to rowLast.
All
  ✅ Server
XL.Sheet.SetPrintRow
Sets a flag that the row and column headers are printed.
All
  ✅ Server
XL.Sheet.SetPrintZoom
Sets the scaling factor for printing as a percentage.
All
  ✅ Server
XL.Sheet.SetProtect
Protects/unprotects the sheet.
All
  ✅ Server
XL.Sheet.SetRow
Sets row height and format.
All
  ✅ Server
XL.Sheet.SetRowHidden
Hides or shows a row.
All
  ✅ Server
XL.Sheet.SetTopLeftView
Sets the first visible row and the leftmost visible column of the sheet.
All
  ✅ Server
XL.Sheet.SetVCenter
ets a flag that the sheet is centered vertically when printed.
All
  ✅ Server
XL.Sheet.SetVerPageBreak
Sets/removes a vertical page break.
All
  ✅ Server
XL.Sheet.SetZoom
Sets the zoom level of the current view.
All
  ✅ Server
XL.Sheet.Split
Splits a sheet at position (row, col).
All
  ✅ Server

417 functions shown.

These functions require a license (87%).

Older Version 3.4   Newer Version 4.0