New Feature:

• Worksheet_SortRange— sorts the rows of a range by one or more columns, each ascending or descending. Cell values and formatting move together with their row.
  • Set HasHeader to keep the range's first row in place instead of sorting it in with the data.
  • Sort columns are counted from the left of the sorted range starting at 1.
  • Sorting is locale-independent, so results are the same on any server.

Fix

• Conditional formatting no longer forces an underline on the text. A rule with the font underline set to 0 was still underlining, because an unrecognised underline value was written into the rule's format and Excel fell back to a single underline. Requesting an underline still works as before.

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