Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Output to Excel Named Range without destroying the Excel formatting

Hi GUI Gang

 

At the moment, I have a lovely formatted XLS with corporate branding, logos, filled cells, borders etc.  The data from the Alteryx output needs to start in cell B6.  I have tried the output tools to this named range, but Alteryx destroys all the Excel formatted cells in the data block.

 

As a workaround on the forums, many Alteryx users pump out to a hidden "Output" tab, and then code =OutputA1 in the formatted sheet.  This looks messy to the users who then go hunting for the hidden tab.  Personally I end up pumping the workflow out to a temporary CSV file.  Then opening that in Excel, selecting all, and then pasting values in the pretty Excel file.

 

This is fine for one file, but I need to split the output report block by a country field and do this 100s of time for each month end.

 

Please can we have a output tool that does the same as my workaround.  Outputs directly from a workflow to a range in Excel that doesnt destroy the workbook's formatting.

 

Jay

9 Comments
jpoz
Alteryx
Alteryx

Do you really mean XLS, or do you mean XLSX?

jay_hl
7 - Meteor

We have both formats, but I guess I would prefer .XLSX

Actuary_ASB
6 - Meteoroid

In the meantime, you could also consider writing up a short Macro in VBA in an excel file, which you can then call using VBScript called from Alteryx as an "Event" after the workflow completes successfully.

 

I had a report that was compiled on a year-to-date basis, so I used a macro in the file to prepare it for new data, then run my Alteryx workflow to populate new data, and then another macro to do the final re-formatting of the newly written data.

 

There is some community post about using this work-around, as that's how I learned you could call an Excel Macro from Alteryx.

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Under Review

Thank you for posting to the Alteryx Community. Your idea is currently being reviewed by the Alteryx Development Team for a possible future release. Please note that this review process can take some time, we’ll do our best to keep you up to date on the status of your idea.

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Coming Soon

Thank you for your idea! 

 

Our product team is currently finalizing this feature and it will likely be included in an upcoming release! We'll update this idea again once it's available.

jpoz
Alteryx
Alteryx
Status changed to: Implemented

Thank you for this suggestion! As of the 2020.1 release, you can utilize the 'Preserve Formatting on Overwrite' option in the Output Data tool when writing to a range in an Excel file. There are other Excel enhancements in the 2020.1 release as well. You can view the release notes here.

tdollin
5 - Atom

@jpoz You say this has been implemented? I don't see the option you're alluding to in the output tool configuration?

jpoz
Alteryx
Alteryx

@tdollin In the Output Tool, when using xlsx, you will see a check box option for 'Preserve Formatting on Overwrite (Range Required)'

mbmcdonald2
5 - Atom

Hi @jpoz I'm having a bit of trouble with the Preserve Formatting on Overwrite (Range Required) feature. I have it checked and while the formatting on my sheet stays preserved, when I re-configure the output to show a different list of items in a field, it still keeps the previous items in the list if my new list isn't long enough (i.e. it doesn't delete the old list). You'll see in the screenshot I included below the highlighted items are not supposed to be in that list but didn't get deleted once I updated the configuration. Any assistance would be greatly appreciated!

 

mbmcdonald2_0-1636989050781.png