I'm working on an interesting requirement for formatted Excel worksheets. The sheets need to contain multiple independent tables. In some cases, the tables are arranged horizontally, in others vertically, and some have a mix of both. I've been trying to get this working in the layout tool, but I can't get any horizontal spacing between tables. I've found some info on Community about arranging tables vertically, so my immediate need is to put two tables side by side separated by some white space.
I have been able to build this without reporting tools by treating the column names as data, inserting null rows above the tables, null columns between them, and using surrogate column names that I ignore when writing the data to the file. This works for the layout, but leaves me with default column widths and the numbers all squished together. The formatting is important, so I think I need to use reporting tools. I have seen one attempt to use a single table tool for both data sets with empty columns between the two sets. The problem with that is that we may have columns in each data set with the same name. In that case, we could have a set of dummy field names and treat the actual headers as data, but then we'd need to hide the dummy names.
I'm including the workflow I built without reporting tools just to give you some idea of what I'm trying to do. I'd appreciate any suggestions on how to build this with formatted columns and, if possible, how to extend this to a more complex layout.
