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

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

Meteoroid

Is there another workaround for this? I had to install the 2010 Access driver to have the ability to read in the .xlsb file in the first place. The binary file is 58MB, converting that to an .xlsx file will put it > 150MB, which will crush the resources on my machine.

Labels