Change File Name without losing formatting for excel sheet with many tabs.

[javiwood]

Using a template to append data to multiple tabs with formatting. Is it possible when it finishing writing that I can change the file name? The WF does not have to be connected, it can be a separate process.

Formula tool has not done it for me. CMD tool, I don’t believe I can send a rename-item script to rename.

Directory tool maybe, I haven't been able to figure this tool out.  

[Qiu · Accepted solution]

@javiwood 
I think we can use Run Command to change the file name after output.

[Maskell_Rascal]

Hey @javiwood 

I think that @Qiu already has you covered, but here is a similar scenario I answered awhile ago. This solution uses a dynamic input and list of filenames to be generated, copies and saves each file to an output folder, and finally runs the workflow and outputs the data to each newly created file. 

Solution: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outputting-multiple-excel-files-using-...

Thanks!

Phil

[javiwood]

This works too. Thanks. 

[javiwood]

Quick and short solution that I can easily attach to any workflow. Perfect!!

[Qiu]

@javiwood 

Glad to helo and thank you for the accept mark. 😁

[sanketkatoch05]

Hi all, 
Even I'm trying to apply this solution to my workflow, but I'm getting an error: The file "C:\Users\........\Temp\11\RunCommand.bat" is not a known format. 

Can you guys please help. 
Thanks, 

[sanketkatoch05]

Found out the reason why for my above query. 

[raghusrealm]

@Qiu 

Thank you for sharing the above post and I tried your workflow and steps. But, I'm getting the below two errors.

I pulled the path using the  "FileGetDir()" formula in the formula tool.

On the 2nd error, the excel file is not open but i'm still getting this error.

Any suggestions.

Regards,

Raghu

[Qiu]

@raghusrealm 
if possible, can you upload your modified version? 😂