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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
Alteryx
Alteryx

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