Is there a way to setup Excel cells height and width through Alteryx?

The Excel worksheet is setup correctly through Alteryx. But, some cells do not have enough room to give full number. Is there a setting on Alteryx so that on Excel, it does not show #########?

This is just an example in what I am seeing on Excel. The whole number does appear on the Formula bar.

Cells showing ######## not full number.PNG

Topic of Interest

Accepted answers

AngelosPachis

Hi @bmay10 ,

One workaround that I can think of is exploiting the functionality of the report tools. Stick a table tool and clear up any formatting.

Then after the table tool, use a render tool and set it to output an excel file.

If the provided report style/paper size at the bottom of the configuration window is set to be wide enough, then you should not see any ####### values.

Let me know if that worked for you.

Regards,

Angelos

All comments

AngelosPachis

Hi @bmay10 ,

One workaround that I can think of is exploiting the functionality of the report tools. Stick a table tool and clear up any formatting.

Then after the table tool, use a render tool and set it to output an excel file.

If the provided report style/paper size at the bottom of the configuration window is set to be wide enough, then you should not see any ####### values.

Let me know if that worked for you.

Regards,

Angelos

bmay10

I do appreciate for the example.

I have tried using those steps. I do have a table and render on the canvas, I checked the settings. I tried by changing the default table settings on the Table. Also, on the table, I looked at each column's width, alignment, and so on.

I am still trying to fix it so that it shows numbers, not #### on Excel.

DanielG

You could also create a template in Excel and instead of overwriting an entire sheet, you can just created a named range and overwrite that, thereby keeping the rest of the Excel sheet formatting intact.

bmay10

thank you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703