Below is a complete list of the user defined functions available in AutoIt. Click on a user defined function name for a detailed description.
When using them you need to add a #include <Excel.au3>.
| User Defined Function | Description |
|---|---|
| _Excel_BookAttach | Attaches to the first instance of a workbook where the search string matches based on the selected mode |
| _Excel_BookClose | Closes the specified workbook |
| _Excel_BookList | Returns a list of workbooks of a specified or all Excel instances |
| _Excel_BookNew | Creates a new workbook |
| _Excel_BookOpen | Opens an existing workbook |
| _Excel_BookOpenText | Opens a text file and parses the content to a new workbook with a single sheet |
| _Excel_BookSave | Saves the specified workbook |
| _Excel_BookSaveAs | Saves the specified workbook with a new filename and/or type |
| _Excel_Close | Closes all worksheets and the instance of the Excel application |
| _Excel_ColumnToLetter | Converts the column number to letter(s) |
| _Excel_ColumnToNumber | Converts the column letter(s) to a number |
| _Excel_ConvertFormula | Converts cell references in a formula between A1 and R1C1 reference styles, relative and absolute reference type, or both |
| _Excel_Export | Exports a workbook, worksheet, chart or range as PDF or XPS |
| _Excel_FilterGet | Returns a list of set filters |
| _Excel_FilterSet | Sets/unsets filter definitions and filters the range |
| _Excel_Open | Connects to an existing Excel instance or creates a new one |
| _Excel_PictureAdd | Adds a picture on the specified workbook and worksheet |
| _Excel_Print | Prints a workbook, worksheet, chart or range |
| _Excel_RangeCopyPaste | Cuts or copies one or multiple cells, rows or columns to a range or from/to the clipboard |
| _Excel_RangeDelete | Deletes one or multiple cells, rows or columns from the specified worksheet |
| _Excel_RangeFind | Finds matching cells in a range or workbook and returns an array with information about the found cells |
| _Excel_RangeInsert | Inserts one or multiple empty cells, rows or columns into the specified worksheet |
| _Excel_RangeLinkAddRemove | Adds or removes a hyperlink to/from a specified range |
| _Excel_RangeRead | Reads the value, formula or displayed text from a cell or range of cells of the specified workbook and worksheet |
| _Excel_RangeReplace | Finds and replaces matching strings in a range or worksheet |
| _Excel_RangeSort | Sorts a cell range |
| _Excel_RangeValidate | Adds data validation to the specified range |
| _Excel_RangeWrite | Writes value(s) or formula(s) to a cell or a cell range on the specified workbook and worksheet |
| _Excel_SheetAdd | Adds new sheet(s) to a workbook and sets their names |
| _Excel_SheetCopyMove | Copies or moves the specified sheet before or after a specified sheet in the same or a different workbook |
| _Excel_SheetDelete | Deletes the specified sheet by object, string name or by number |
| _Excel_SheetList | Returns a list of all sheets in the specified workbook |