Breaking Changes

• None

Non-Breaking Changes

• Added the following actions, courtesy of a pull request by Beatriz
  • Cell_ConvertHexCodeToRGB
  • Cell_GetFillColorByIndex
  • Cell_GetFillColorByName

Note: The last two functions were previously requested here

Breaking changes

None

Non-breaking changes

1. Added Worksheet_CopyRows action that allows you to copy rows within a worksheet

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