Hi @tsv_ml_f21 , this is a strange one!
Firstly, the “log”, I think refers to the Console window (via View - Console) menu. That’s the only place I’m seeing messages for these nodes unless its writing to a file somewhere. The messages aren’t always obvious (to me at least) about what they mean.
For your specific issue, I’d first written here to say that I had also managed to hit the problem, and I saw the following error messages in the log:
WARN XLS Control Table Generator 0:108 Cells of a XLS Formatter Control Table shall contain comma-separated lists of tags. Tags are typically user chosen and speaking names, e.g. 'header' or 'totals'. Valid tags do not contain any of the letters ';*|+&?!'. This warning can be ignored for some special features, e.g. the 'applies to all tags' option of the XLS Border Formatter node.
WARN XLS Control Table Generator 0:108 Warning: The generated table is not a fully valid XLS Formatter Control Table as it contains invalid characters in tags. See log for details.
INFO XLS Control Table Generator 0:108 XLS Control Table Generator 0:108 End execute (0 secs)
INFO XLS Control Table from Cell Range 0:136 XLS Control Table from Cell Range 0:136 End execute (0 secs)
WARN XLS Formatter (apply) 0:109 The output file already exists and will be overwritten.
WARN XLS Font Formatter 0:140 Xls Formatting Control Table check failed at rowID "10", column "D": Comma-separated tag list contains invalid character(s), i.e. ;*|+&?!
ERROR XLS Font Formatter 0:140 Execute failed: The provided input table is not a valid XLS control table. See log for details.
Originally I hadn’t been able to work out what was going on because the error appeared to “clear” and I couldn’t make it return. It turns out that I had during my investigation accidentally removed a column that was causing the issue. The column contained certain characters that the XLS formatter doesn’t like
Basically, the XLS formatting nodes don’t appear to like it when there are any cells presented to them that contain any of the following characters:
When you pass your table to the XLS Control Table Generator, it must not have those values. That’s fine though because you don’t need to pass your actual data to these nodes, you simply need to pass “place-holder” values to it.
So prior to the call to the XLS Control Table Generator, put in a node that replaces any (or all) of your data, but specifically data that might cause problems, with some other value.
Hopefully then you’ll be good to go.