Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Retrieve and load Excel binary (XLSB) file
Contributor II 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?
Tagged:
0
Answers
It is my understanding that XLSB is not supported in RapidMiner Studio.
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
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!
sure. You are welcome to repost in the Ideas -> Product Ideas forum.
Scott