This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Good evening. I want to create a report in the output file, the template is a pre-designed excel template. I like the result of the workflow saved in the excel template based on date. I have attached the Screenshot of the template. I want the template to stay as it is. Every day, the new refresh data results will populate on this template as a new file based on the date the Output file is- Sales Report 082222.I have attached the template and workflow for your information.
You can use the Preserve Formatting option to update an existing spreadsheet that has the formatting that you want. The trouble that you have is that the file you're updating needs to exist first. See the attached workflow, which creates a .bat file that copies your Sales Template to your new filename, then the workflow updates that file you've just copied.
Hope that helps, it's using files in C:\Temp\ so you'll need to update that for it to work for you.