Hello, team.
I need so help about loader one excel file.
I ´ve seen on several topic´s about xls file and so any troubles.
My necessity about attach file is open only sheet - "Físicos_Web".
Somboby help me with tip´s or one solution ?
(It´s not necessary to use xls reader node. I don´t know use javascript or python to this issue).
Regard´s
Demetrius.
Your report is in Excel binary format, which as far as I know KNIME cannot (yet) read. Your best option is to open it in Excel and save it back as regular XLSX or CSV. Then you can use the XLS Reader or CSV Reader node to read it into KNIME.
Cheers,
Marco.
Hello Demetrius,
Marco is absolutely right. I just want to add that KNIME uses Apache POI to work with Excel, and POI does not (and probably never will) support xlsb (They even have an exception for this). Sorry.
Best,
Ferry
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