Bug fixes

• Worksheet references stay valid after saving. Worksheet references obtained before Workbook_GetBinaryData or Workbook_SaveRightToLeft stopped working after the call — writes through them could be silently lost, and passing one to Workbook_AddSheet could crash. They now keep working.
• Hyperlinks are preserved when copying a sheet to another workbook. Workbook_AddSheet / Workbook_AddCopyWorksheet kept the display text but dropped the link.
• Cell values read back identically on any server locale. Raw reads from Cell_Read, Cell_ReadByIndex/ByName and Worksheet_ReadRange were formatted with the server's culture — a decimal written as 1.5 could read back as 1,5. Reads with ReadText enabled still return Excel's display text, unchanged.
• Worksheet_GetMergedCellRanges (and the workbook variant) no longer list removed merges as garbage entries.

Improvements

• ConditionalFormatting_GetAllRules now returns a data-bar rule's colour and show-value settings instead of only the rule type.
• Worksheet_AddDropdown gives a clear error when the inline item list exceeds Excel's 255-character limit, instead of producing a dropdown Excel silently drops. Use a cell range (ItemsAddress) for longer lists.

Conditional formatting fixes

• Rule formatting now applies reliably. A 6-digit hex colour (e.g. #FF0000) on a rule's fill was treated as transparent, so Excel showed "No Format Set". 6-digit colours are now opaque.
• No more crash on workbooks created elsewhere. Adding a rule to a workbook that lacked a styles <dxfs> element (e.g. some record-list-to-Excel output) threw a NullReferenceException on save. Opening such a workbook now repairs it automatically.
• Conditional formatting survives copying a sheet between workbooks. Workbook_AddSheet / AddCopyWorksheet kept the rule but dropped its format; the format is now carried over.
• ConditionalFormatting_GetAllRules now returns each rule's style (fill, font, borders, number format) instead of default values.

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