How to specifiy sheet name in server output tool

[wonka1234]

Hi,

I am trying to output a file to a location of the users choosing.

anyone have any tips on how to make this work or make this process better?

[AngelosPachis]

Hi @wonka1234 ,

Can you provide a screenshot of the action tool please?

[wonka1234]

[AngelosPachis]

@wonka1234 your filepath should end with :

filepath/filename.xlsx|||Sheetname

Can you click on the output tool and make sure that it's configured properly so a sheet is specified?

This is what I can see from my side, and I believe that's the way to configure the action tool so it only replaces the filepath but leave the filename intact

[wonka1234]

thanks, but then how do you configure this part in the server?

the user will have to do C:/Users/me/desktop/file.xlsx|||sheetname   ?

[AngelosPachis]

@wonka1234 If you want to allow your users the flexibility to change the filename and tab name then I presume yes. If you don't want those to change, you have to make it clear that they should only type something equivalent to "C:/Users/me/desktop/"

However, that filepath should be somewhere that your server has access to like a shared drive I believe. If you want to save the file on the desktop of your local machine then that's probably not possible as the server won't be able to access that filepath. If that's the case, your users can download the output instead after your workflow has finished running

[wonka1234]

thanks, but is there a way where a user wont have to define  a tab name? I just need a default tab name.. I want to make it as easy as possible.

[AngelosPachis]

@wonka1234 , of course. So all you have to do is to configure your action tool so you change the filepath (and the filename) if that's what you want.

So check the replace specific string checkbox and then in the text box below just add 

filepath/filename

That will create an xlsx with the given filename at that filepath with the tab name you have defined when the workflow was built. Does that kind of makes sense in a way?