This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.