How to read .xlsb file in Knime

can anyone tell me how to read .xlsb file in Knime ?

As far as I know you would need to resave the file in Excel as .xlsx… OR you could use an R package and the R Snippet node to read in the file. (It looks like there is an R package called “readxlsb”.) I’ve done something similar when needing to read in SPSS files into KNIME.

3 Likes

@nmajidkh welcome to the KNIME forum.

You will have to use R or Python. I set up an example. You could see if it works or you could try the package @Snowy has suggested.

3 Likes

Hi @nmajidkh and welcome to the forum. This question comes up periodically - here’s a bit more detail from a previous topic below.

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.

Hi all,

just writing to let you know that with the latest release of KNIME Analytics Platform 4.4 the reading of xlsb files is supported by the Excel Reader. Thanks for all the feedback and let us know if you have any other feature requests!

Best,
Simon

4 Likes