community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Render output (formatted) into Excel workbook and disable Gridlines (automatically)

Alteryx Partner

Hi - Is it possible, using the Render tool to create a multiple tab Excel Workbook and disable the gridlines upon output automatically?

Specifically, I want to remove the gridlines in the Excel file on all tabs upon output (similar to as if you open excel and go to > View > Show > gridlines (un-check) Screenshot below 

 

I've tried writing to a pre-formatted excel file, but due to the required formatting needs of the report, I believe I can only achieve this through the render tool - which only allows writing to a new Excel file (not into an existing one - please let me know if its possible to Render into an existing Excel file)

 

Additional information:

Not looking to format the background of a single table, but the entire Excel sheet as white i.e. remove gridlines

Using Excel 2013

The workflow exists as an App in the Alteryx Gallery

 

Thanks!

 

Screenshot of Excel option I want to alter:

Gridlinse.JPG

Hi Bgarden,

 

Were you able to find a solution for this? I am facing a similar problem.

Highlighted
Alteryx Partner

Hi Amritansha,

 

No, unfortunately not. Hopefully someone will respond, or this option will become available in a future release!

 

Have an awesome day!

Ben

Labels