Sending the Layuot ouput to Excel

[ferha_jafri]

Hello Experts,

I have a workflow in which I want to send the output of Render tool or Layout tool  to Excel through output tool.

Thanks in advance

Ferha

[mceleavey]

Hi @ferha_jafri ,

I've built both output methods for you. You will need to change the output paths.

M

[ferha_jafri]

To mceleavey,

But it is not giving me the table, PFA with the result I got. I want to get the table in excel visible in browse.

[mceleavey]

Hi @ferha_jafri ,

I'm not sure what you mean.

I've attached the workflow which changes how the straight Excel output is handled but the render output should be exactly the same.

I've attached the outputs I get. This is the the browse tool:

and this is the rendered output (Excel Output):

This is the straight Excel output (Excel Output 2(:

M.

[ferha_jafri]

Not sure as I ran the workflow you attached and change the path. I am attaching the workflow and excel output as I am not getting the desired output. Please check.

[mceleavey]

Hi @ferha_jafri ,

I can't replicate the problem.

I've deleted the Excel output and I'm only using the render, which is the one you need.

I ran it again and I get the correct output:

M.

[ferha_jafri]

Thanks mceleavey,

My business scenario is that I have tp update the same excel with 2 output, so in case if I move the render output to excel, it did not give me the option to save it to a particular sheet so i want to send the Layout out put to excel through output tool, could you please help me on this. Do not generate it through render tool , instead the same output I want through output tool so that same excel can have multiple tabs.

Thanks

[mceleavey]

Hi @ferha_jafri ,

You simply add the sheet name to be |||sheet 1 or whatever onto the filename.

Also, if you want to do that dynamically you simply create the filename in a formulae tool, for example "FileName"+".xlsx"+"|||"+datetimetoday()

This will create a file called FileName.xlsx with a sheet name of 2021-05-06.

You then configure the render to be as follows:

M.

[ferha_jafri]

Got the error while adding a sheet PFA with the error.