Dynamic File and Sheet Name with Render/Layout Tools

cmohyi

Hey there,

I know there are a few threads on this topic but I haven't found any that solve my issue. I have a workflow where I'm using the Render tool to output formatted Excel sheets with a dynamic filename into 4 different tabs. Everything works great except that the output gives me standard "sheet1", "sheet2", etc names without an option to rename them. I know that the Layout tool can accomplish this but then I can't use the dynamic filename. I need to keep the dynamic filename and can't compromise on any of the formatting. Any suggestions for how to accomplish this?

Thanks a ton in advance!!

Cameron

OTrieger

@Peter_Guirguis , @AbhilashR 

This is a perfect example why you should not share WFs with people. I know that you are trying to help, however it does not give the help that the person was looking for. Why?

Simply as he is lacking some knowledge in this area and despite of the fact that you shared with him a solution or partial solution he does not know what to do with it due to the lack of knowledge.

I keep getting responds why it will be fine to share WFs, focusing on the exception cases. If you want to help, really help, aid the person get the knowledge so he can work out the solution.

@DaveSchloat  shared an error that he got, I did not see any answer how to overcome it, which is super simple answer, that render does not use the same format of path as the Data output tool. The path for the render you will only need to define until the file type, xlsx etc. The sheet name will come from the setting of the Layout tool.

Knowledge is the ability to implement what you studied, if you cannot implement, well the fact is that there is something that you still do not understand. There are no exceptions for this rule. If you finding yourself that you cannot apply what you just learn, then there is something that you are not fully understand. Go back and find what you do not understand, normally, words, define them and study it again.