Sheets missing in output

[Vanessa_JWS]

Hi

I have 3 sheets which I would like to combine into a single excel file (output) in separate tabs (i.e. a total of 3 tabs). 

However, I noted that the details for the 3 sheets are all combined into a single sheet when I generated the output.

Can I ask what is causing this issue?

Attached are some screenshots for reference.

Thanks

Vanessa

[ShankerV · Accepted solution]

Hi @Vanessa_JWS 

I noticed that you have not selected the Check box in Group By as "Sheet".

I have gone through the remaining settings too and others seems quite good.

Could you please try selecting the Check Box with Sheet and run to get the desired output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Vanessa_JWS]

Thanks Shanker!

That's very helpful and I have managed to generate all the outputs!

Another quick question - the generated output is colored by default (see attached screenshot). 

Is there a way to remove this so that the cells are not colored?

Thanks

Vanessa

[ShankerV · Accepted solution]

Hi @Vanessa_JWS 

Before selecting the Check box for Sheet, I would also recommend to create the sheet names for 3 different sheets which you need to output.

This will help to overcome the issue.

Create the sheet name for all 3 sheets after the Basic table tool you have used in your workflow.

Layout tool configuration:

Render tool configuration:

Output: 

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @Vanessa_JWS 

If I understand your requirement, you want to remove the color of heading and alternate rows with light grey color right?

Many thanks

Shanker V

[Vanessa_JWS]

Hi @shanker - Yes that's right :)

[ShankerV · Accepted solution]

Hi @Vanessa_JWS 

Please follow the below steps:

Click the Basic Table

In the Configuration Pane select the Default Table Settings

You need to modify the below highlighted to White.

Click the ... button

Click on the Yellow highlighted in Custom colors and Select ok.

Here is the desired output for you.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Vanessa_JWS 

Post the above changes, it will also inherit in the final Render tool also.

But, if you need this to have inherited in all sheets, you need to change the settings in all 3 Basic Table tool used in your workflow.

Many thanks

Shanker V

[Vanessa_JWS]

Thanks @ShankerV ! Appreciate your help!

[ShankerV]

@Vanessa_JWS 

Welcome, happy to support anytime.