This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Looks aren't everything... But the latest Community refresh looks darn good!
Hi guys,I'm trying to output the results from a WF to different sheets within the same excel sheet. I'm getting a strange error and I couldn't find any solution to this in the community.Error: QA LITE Write Calc Report (224): Tool #1: TableBase::DOMFinished: Column number mismatchTool 1 is a Render inside the last (Brown) Macro so I don't understand why is the column number relevant.
Could you please try to guide me trough a possible solution?Thanks !
This may not solve your exact problem, but here's how I render multiple sheets in the same Excel workbook. It is not necessary that the sheets have the same columns/structure.
1. Union your records so that you have a sheet name field and a single layout per unique sheet name. If you want multiple tables on the same sheet, that will require Layout tool up stream.
2. Use a Layout tool to Group By the sheet name field and add section breaks with the section name set to your sheet name field.
3. In the Render tool, set the separator to "Insert Section Breaks Between Records". Don't forget that the paper size, orientation, and margins affect your Excel cell formatting.
4. Enjoy your rendered file with multiple sheets with sheet name control.