Disable Wrap Text for Table Render

Have a workflow that generates a table render into an Excel sheet. This includes a column with a long list of manufacturing operations that still need to be completed, however when the table is generated the rows have "Wrap Text" enabled and it creates a very messy looking table. I want the rows to be the default height in excel without losing any of the operation data, I just want it to get cut off by the following column if it would overflow. I cannot find an option to change the wrap text and assume some sort of Row Rule Formula is required, whether it be something to disable wrap text or something to lock the height of a row to a specific size. I have tried a few options and researched extensively but cannot find anything or get it to work. If anyone has experience with changing some of these settings or what a formula code would look like I would appreciate any help/direction. Thanks.

Output

Expression

Accepted answers

All comments

binu_acs

@MattReif_SE try to change the Render tool paper size to custom and increase the size

MattReif_SE

I did try that but there are too many operations, and I don't need them all displayed as it stretches everything very far. I would like to have a set column size to show only the next 5 or so operations without just cutting the remaining ones off in case they need to be looked at. I have attached a reference photo so that you can have an idea of the desired output.

Operations Example for Alteryx Forum.png

binu_acs

@MattReif_SE I don't think the Render tool support specific column width for specific columns,

MattReif_SE

That function is supported by the Table tool if this is what you are referring to, I have set a custom fixed width of my operations column using column rules but due to the forced wrap text it extends my row height to be gigantic to try and fit everything.

Alteryx Column Width Example.png

BenTote

I'm also trying to work out how to disable wrap-text when using the Table tool - were you able to do it?

dreldrel

I don't think the reporting tools have a function to disable wrap-text. Alternatively, I usually use an additional Python tool to unwrap the texts after the render tool. Give it a try!

from ayx import Alteryx
import openpyxl
from openpyxl.styles import Alignment

FileInfo = Alteryx.read("#1")

# Load the Excel workbook
file_path = FileInfo['FilePath'][0]
file_name = FileInfo['SheetName'][0]
workbook = openpyxl.load_workbook(file_path, data_only=True)
worksheet = workbook[file_name]

# Turn off wrap text for all cells in the sheet
for row in worksheet.iter_rows():
    for cell in row:
        # Disable wrap text for each cell
        cell.alignment = Alignment(wrap_text=False)
        
# Save the changes to the workbook
workbook.save(file_path)

LindonB

I don't know of a way to disable text wrap, but you can expand the cell size in the table tool per field.

BenTote

Thanks for your reply! Are you able to attach an example workflow?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703