Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Keep the Excel borders when using table tool

BautistaC888
8 - Asteroid

Hello,
I wanted to know if there is a way to remove the borders and keep the default excel borders when using the table tool.
For example:

BautistaC888_0-1758410623389.png

This is what im getting:

BautistaC888_1-1758410669107.png
Thank you.

 

6 REPLIES 6
Gaurav_Dhama_
12 - Quasar

Do you mean the width of columns?

if so then you can increase the paper size by using custom size inside the render tool under Report style.

try 20 inches.

OTrieger
14 - Magnetar

@BautistaC888 

Why are you using the Table Tool? The minute that you are using it there are formats assigned to the output file. If you just output it with a normal Output tool it will write the data to excel without any formatting.

BautistaC888
8 - Asteroid

I require the headers with bold letters. That is why I used the table format.
Can you do it with the output tool?
Thank you

dreldrel
8 - Asteroid

You can preserve the formatting by clicking the option on your output tool

BautistaC888
8 - Asteroid

Hello @dreldrel ,
This is a new file that is created and I need the bold letters in the header

Gaurav_Dhama_
12 - Quasar

I don't think you can remove that border and keep excel standard grid, but what you can do is make it look like there is no formatting.

Use RGB 217 217 217.

 

Gaurav_Dhama__0-1758526600855.png

 

Gaurav_Dhama__1-1758526611330.png

 

No one would ever know that there was formatting.

Labels
Top Solution Authors