Saving and preserving Excel sheet formats
When working with Excel files, we often have to report using existing templates that have already been formatted, and we need to respect those formats.
Alteryx allows you to preserve the existing formatting, and we’ll go through the process of getting this done within Alteryx Designer.
Getting ready
To follow along with this recipe, you can download our test set from here:
https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch1/Recipe4
If you decide to try it with your data, make sure you define ranges on which the data must be saved.
To make this recipe work, we need to have a range defined within the Excel file.
Our sample set contains a pre-formatted Excel worksheet, with explicit and conditional formats:
Figure 1.31: Excel template
How to do it…
We are going to tackle this recipe in two phases:
- Grabbing the template
- Writing to the template...
