Render Tool - Output to Dynamically Named Excel File

Question

I am using a 'Basic Table' tool to format an excel table with coloured headings etc.

I'd like to output this table into a dynamically named excel file.

The file path for the output file is saved in 'Outputfilelocation' column as seen below. I've included screen prints of my tool configurations.

In the current state, the workflow is not able to output the result. My excel output is working perfectly. What exactly am I doing wrong?

Ady2308 · Answer

Is there a way to exclude Filename, I don't want Filename in my data as the path to the network drive is quite long and would like to exclude it, couldn't find any option in Render Tool to exclude FileName.

Thanks,

Ady

Prasenjeet · Answer

The render tool layout settings should be changed to custom to accommodate the width of your file , start with 100x100 and then trim it down.

Jes · Answer

@afv2688

Thank you for your help!

I realized what I was doing wrong after comparing my workflow to yours.

My file path name contained the worksheet name as well. After removing the worksheet name, I am now able to output the file with a dynamic name into an excel format...but the file looks broken when I open it. Some characters are dropped off from column headings, etc.