| Old UDF Function/Parameter |
New UDF Function/Parameter |
Comments |
|---|---|---|
| _ExcelBookAttach | _Excel_BookAttach | |
| $oInstance | Added. Object of the Excel instance to be searched. | |
| _ExcelBookClose | _Excel_BookClose | |
| $fAlerts | Removed. | |
| _ExcelBookNew | _Excel_BookNew | |
| $fVisible | Removed. | |
| $iSheets | Added. Number of sheets to be added to the new workbook. | |
| _ExcelBookOpen | _Excel_BookOpen | |
| $oExcel | Added. Excel application object where you want to open the workbook. | |
| _ExcelBookSave | _Excel_BookSave | |
| $fAlerts | Removed. | |
| _ExcelBookSaveAs | _Excel_BookSaveAs | |
| $vType | Name changed to $iFormat. Can be any value of the XlFileFormat enumeration. | |
| $fAlerts | Removed. | |
| $iAccessMode | Removed. | |
| $iConflictResolution | Removed. | |
| $bReadOnlyRecommended | Added. Allows to display a message when the file is opened, recommending that the file be opened as read-only. | |
| _ExcelColumnDelete | _Excel_RangeDelete | |
| $iColumn | Changed to $vRange range object. | |
| _ExcelColumnInsert | _Excel_RangeInsert | |
| $iColumn | Changed to $vRange range object. | |
| _ExcelFontSetProperties | Removed. | |
| _ExcelHorizontalAlignSet | Removed. | |
| _ExcelHyperlinkInsert | _Excel_RangeLinkAddRemove | Changed parameters so specific sheets can be addressed. |
| _ExcelReadArray | _Excel_RangeRead | Changed parameters so specific sheets can be addressed. |
| _ExcelReadCell | _Excel_RangeRead | Changed parameters so specific sheets can be addressed. |
| _ExcelReadSheetToArray | _Excel_RangeRead | Changed parameters so specific sheets can be addressed. |
| _ExcelRowDelete | _Excel_RangeDelete | |
| $iRow | Changed to $vRange range object. | |
| _ExcelRowInsert | _Excel_RangeInsert | |
| $iRow | Changed to $vRange range object. | |
| _ExcelSheetActivate | Removed. | |
| _ExcelSheetNameGet | Removed. | |
| _ExcelSheetNameSet | Removed. | |
| _ExcelWriteArray | _Excel_RangeWrite | Changed parameters so specific sheets can be addressed. |
| _ExcelWriteCell | _Excel_RangeWrite | Changed parameters so specific sheets can be addressed. |
| _ExcelWriteFormula | _Excel_RangeWrite | Changed parameters so specific sheets can be addressed. |
| _ExcelWriteSheetFromArray | _Excel_RangeWrite | Changed parameters so specific sheets can be addressed. |
| _ExcelSheetAddNew | _Excel_SheetAdd | Changed parameters so specific sheets can be addressed. |
| _ExcelSheetDelete | _Excel_SheetDelete | |
| $fAlerts | Removed. | |
| _ExcelSheetList | _Excel_SheetList | |
| _ExcelSheetMove | _Excel_SheetCopyMove | Changed parameters so specific sheets can be addressed. |
| New UDF Function/Parameter |
Comments |
|---|---|
| _Excel_BookList | Returns a list of workbooks of a specified or all Excel instances. |
| _Excel_BookOpenText | Opens a text file and parses the content to a new workbook with a single sheet. |
| _Excel_Close | Closes all worksheets and the instance of the Excel application. |
| _Excel_Open | Connects to an existing Excel instance or creates a new one. It's mandatory now to call function _Excel_Open before any other function. |
| _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_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_SheetCopyMove | Copies or moves the specified sheet before or after a specified sheet in the same or a different workbook. |