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
SOLVED

is there a limit to number of columns for xlsb file input?

Meteor

the file I want to use has ~460 columns in but only 255 are currently being input.  Is there a way of inputting all 460 for an xlsb file?

THanks

Highlighted
Moderator
Moderator

Hi @Kate

 

 

Looking at the Alteryx Excel help documentation under the "lengths and limits" section:

 

ExcelHelp.png

 

 

While this documentation is for xlsx files, the binary files are read using the Legacy Driver for Microsoft Excel, putting a limit at 255 columns. You can get around this by converting the file to xlsx if possible. 

 

 

Jake

Labels