SCExcel::Apply sub-object to Excell cells

Sometimes you need to output complex references or table rows to multiple columns in Excel. In previous versions, you had to set each column individually in the basic data map.

With the new plugin: “Apply sub-object to Excell cells” this is done in one step via the e.g. loop plugin.

Enclosed is a configuration example:

We want to output all rows of a table with defined columns:

For this we configure our basic data map by selecting the table attribute and the plugin “SCExcel::Apply sub-object to Excell cells”. Attention the plugin works only in the first level!

In the plugin you can first set the configuration of the data. In our case, the data comes through a loop of table rows.

In addition, you can set the behavior for “empty data” in the plugin. Either the whole object or the configuration line can be skipped. This would normally be done via condition plugins, but in this complex case it is not possible. Therefore the additional attribute.

As there could also be multilingual attributes in it, which are then extended e.g. via language keys (e.g. Label_ becomes Label_de and Label_en), the following must be entered in the lowest field (e.g. Label,Description)

The loop head is configured normally, as known from the loops.

So first the loop header with its table columns.

As a final transformation step, an array must be created that also contains the final column names of the Excel table.

The result is an Excel file containing all columns from the basic data map and the array.