Using Render and output file tool to same excel workbook

[jchan58]

Am getting excel error when I try to open the output file generated by both render and excel output file, saying its corrupted and repaired.

The output file consists 2 worksheets, one of the worksheet using output file tool has large data set (30 columns x 300k rows), the other sheet with small data set is output from Render tool.

I could have used render tool for both sheets, but file size will be enormous.

I try to use parallel block until done to ensure both sheets wont override at the same time.

Weird the workflow complete with no issue but Getting that excel error message. The output file is showing empty data for one of the worksheet. Anyone encounter something similar?

[KasiaP]

I tried this solution too and it doesn't work. Sheet created by output tool is empty and excel gives an error message "we found a problem with some content..." .

[DavidP]

Could you send me your workflow to have a look?

[KasiaP]

Please check attached workflow.

Thanks!

[KasiaP]

I entered this topic because I am looking for the solution for below issue.

I am using reporting tools (table, layout, render) to create an excel report with multiple worksheets.

My problem is that I have to set up one page size for all worksheets when using render tool.

One of my worksheets has 2 columns of data and the other one has 50 columns. When I set the size to fit all 50 columns it is much too wide for the sheet with 2 coulmns, as table width adjusts to page width.

Does anyone found workaround for it?

Unfortunately solution posted below doesn't work: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Render-Multiple-Excel-Sheets-Different...

How to set multiple page sizes in one excel report?

Or how to prevent Alteryx from stretching the tables into the whole page?

Or is there a possibility to create formatted excel report using other than render tool?

Does anyone has any idea?

[DavidP]

@KasiaP , in answer to your questions:

The Render tool only has one page size that is used for all sheets.

Have a look at the attached workflow that shows how I've dealt with sheets with different widths using a render tool.

I basically insert empty blocks with report text tools either side of the table that has reduced width.

[DavidP]

The idea behind my original post was that you wrote to both tabs with the render tool (i.e. first and second in your example), but you then overwrite the second tab with the output data tool.

Here is our example implemented with my original workflow.

[KasiaP]

Thanks @DavidP, both solutions work well.
You're the master!

[DavidP]

Hi @papalow ,

I just noticed that I never replied to your post - sorry about that. 

Can you share your workflow so that I can take a look?

[jacob_kahn]

I have been trying to solve this for days. 

The reason I was using both a Render tool and an output tool is because one chart I am exporting is about 7 inches wide; the other chart I am exporting is 60 inches wide. I did not want the 7 inch chart to be 60 inches wide - that is a lot of scrolling. With your solution I am exporting the 60 inch chart into a normal excel export (which usually requires expanding), and exporting my 7 inch chart with the render tool.

Thank you @DavidP 

[cascreer]

I get the same issue. The block holds the output function (seemingly) correctly but when i open the excel it say there is a problem with the data and recovers it. All my rendered tabs are correct but the output tab is there correctly named but now with no data in it.