Writing output in multiple tabs of a spreadsheet

Question

In my WF, with output tool, I am writing my output in multiple tabs of a spreadsheet. Also, in some cases, writing chunks of data in different cells of  a single tab. For instance, in tab "Segment", writing data on A1:G1, A10:G10 and M1:Q2.

Please suggest that how I can achieve the same by using macros.

Emmanuel_G · Answer

@Vikas038

Find in attachement a way of export data in same tab but different ranges.

To my knowledge, you will find it difficult to specify cell numbers in an interface output tool.

That said, the best in my opinion is to work on the macro before and then with the output data of this macro, you can specify your ranges in a formula tool and do some changes in output tool to adapt as in the attached workflow and the excel export that you can see in the screenshot.

Let me know if there is any issue and please, do not hesitate to mark this answer as solution if it helped. 🙂

Writing output in multiple tabs of a spreadsheet.yxmd

Qiu · Answer

@Vikas038 
For writing data on different sheet or Tab, we use the specify output fullpath, which contains the workbook and worksheet names.

But different Cells,  I thinkt it will be difficult.