Sheets missing in output

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

Screenshots.docx

Workflow

Output

Accepted answers

ShankerV

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

ShankerV

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

Sample for Vanessa_JWS .yxmd

ShankerV

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

Remove color Vanessa_JWS .yxmd

ShankerV

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

All comments

ShankerV

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

Screenshot 2022-12-18 151812 (2).jpg

ShankerV

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

Sample for Vanessa_JWS .yxmd

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

ShankerV

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!!!!