Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Retrieve and load Excel binary (XLSB) file

I have a million-plus row Excel Binary (XLSB) file just under 100 MB that I am trying to add to the repository and then retrieve/load into my process as an example set.

Unfortunately... I can't get it to work.

If I convert the file to XLSX (Excel XML) file, it works fine, but the file size is larger (~300 MB). I am writing an Excel file at the end of my process, so I need to open that up and convert back to XLSB anyway but I was just curious what I should be doing to retrieve this binary file.

Is the XLSB file format not fully supported?

Find more posts tagged with

AI Studio

Excel

Getting Started

Accepted answers

All comments

Thomas_Ott

It is my understanding that XLSB is not supported in RapidMiner Studio.

sgenzer

hello @mas077 - yes XLSB is not supported directly as @Thomas_Ott said. When I have these issues, I usually send it to a REST API document converter. My usual go-to converters, Zamzar and Convertio.co, don't do XLSB. However a quick google search revealed several others that seem like they will do the job, like this one: http://www.filezigzag.com/api

Scott

mas077

Thanks! There’s technically nothing wrong with me using an XLSX file and anyone can easily convert XLSB to XLSX within Excel 2013 and higher.

But, if an excel file is going to be my example set, it likely has several hundred thousand rows. If so, XLSB is the best way to store the data since it’s typically 40-50% smaller than the same data saved as XLSX.

I’m brand new to this so I don’t know how often people are using Excel as a data source, but I would love to see XLSB as a fully supported data source some day.

Thanks!

sgenzer

sure. You are welcome to repost in the Ideas -> Product Ideas forum.

Scott