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

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.

Macros

Run Command

Accepted answers

Qiu

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

0420-javiwood.yxmd

All comments

Qiu

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

0420-javiwood.yxmd

Maskell_Rascal

Hey @Warcry

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-different-cuts-of-raw-data/m-p/596335#M132786

Thanks!

Phil

Warcry

This works too. Thanks.

Warcry

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

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167