Writing output to the same Excel worksheet in different ranges and colorize cells

Question

I have built a single workflow with three streams that would give three outputs. I need to write these outputs to the same Excel worksheet in different ranges. For example, the first output should start at A1, the second should start at H1, and the third should start at O1 -- all in Sheet 1 of the workbook. I would also want to color the ranges in different colors. I have managed to write the outputs to different sheets, but have not figured out a way to write to the SAME sheet starting a different columns and color the cells that contain the outputs. Any idea?

Yoshiro_Fujimori · Answer

@45179902 ,

The orientation of the contents can be configured in Layout tool.

As I added a Text for each Table, I had to put them together with Layout tool first, and then merge them horizontally like below.

Output

You can also check the example of Layout tool.

Good luck.

WriteColoredCellToExcel.yxmd

lizhaozhi · Answer

Hi @Yoshiro_Fujimori, thanks for your solution. Is there a way to put these outputs side by side by specifying ranges instead of stacking on top of each other using the reporting tools?

Yoshiro_Fujimori · Answer

Hi @45179902 ,

You may consider using Reporting tools.

To change cell colors, use "Default Table Settings" in Table Tool configuration.

Here is a sample setting to change the Header Color.

Output Image

As I did not take time for table setting, the above table is not so pretty.

For further details, I recommend the pages of

* Interactive Lessons "Reporting in Designer" and
* Reporting tools in Tool Mastery, especially Table tools

Good luck.

WriteColoredCellToExcel.yxmd