Can the Continental XLS Formatter format as Table?

Community Extensions
1

Hi there,

I wonder if the XLS formatter is able to write an Excel table (I think Microsoft calls it a data table)?

Or would you recommend to mimic the behavior (especially the filters) as far as possible through the Continental nodes and then leave the “naming part” (so to say) in Excel?

Thanks in advance.

2

@kowisoft I think right now you would need something like Python openpyxl to do advanced manipulations like drop-down-menues (besides formats) in Excel. Since 4.5 you can write data to specific cells.

For the ‘named’ tables I have created two examples for in and out recently:

3

Awesome, really like the idea, that since 4.5 the application can write to a preformatted table.