Bug fix

• Worksheet_SortRange now refuses ranges containing merged cells or formulas, with a clear error, instead of silently corrupting them. Sorting was moving values out of their merged cells and leaving formulas pointing at the wrong rows. A merged title row above the data still sorts fine when HasHeader is set.

New

• Worksheet_AddHeaderFooterImage — places an image, such as a company logo, in the worksheet's page header or footer, shown when the sheet is printed. Choose the header or footer and the Left, Center, or Right section; each section can hold one image, and PNG transparency is preserved.

Added the Chart_Create action which allows for creation of charts in a specific worksheet. 

Define the ranges of cells from which you want to feed your series into the chart and choose from a number of types by passing in the name of the type.

Check out an example here:

https://www.outsystems.com/forums/discussion/36870/advanced-excel-chart-creation-example/

A new action has been added to the "Advanced Excel" extension called “Workbook_AddOsDbSheet”.

This action will need a few input parameters, like the WorkbookInObj, the WorksheetName, the OsDbDataSet, the RowStart, the ColumStart and IncludingHeader.

When this action is used for the first time in a row, the WorkbookInObj  should be nullObject().

In that case the action will automatically open a workbook object, which reference will be returned via WorkbookOutObj afterwards.

The next time the action is used the WorkbookInObj will be populated with the previous WorkbookOutObj reference. The use of the other fields is clear, I guess.

• Fixed a bug in Cell_WriteByIndex function;
• Added function Worksheet_GetName that returns, as text, the name of the worksheet provided;
• Added function Worksheet_DeleteByIndex to delete sheets by index;
• Added function Worksheet_DeleteByName to delete sheets by name;
• Added function WorkBook_AddSheet to add new sheets by name;
• Added function Cell_MergeRange to merge multiple cells.

Upgrade to version 9