topic Re: [resolved] Can I Process xlsb files in Talend? in Talend Studio

[resolved] Can I Process xlsb files in Talend?

Anonymous — Sat, 16 Nov 2024 12:45:47 GMT

Hi,
.xlsb files which open in microsoft excel by default having data in rows and columns cells.
Can you please tell me some way in processing those files.
FileExcel under the metadata only allows me to choose the files with extension .xls and .xlsx

Re: [resolved] Can I Process xlsb files in Talend?

_AnonymousUser — Mon, 16 Jan 2012 06:04:17 GMT

Hi
even i have the same problem can anyone plzzz help

Re: [resolved] Can I Process xlsb files in Talend?

Anonymous — Mon, 16 Jan 2012 06:20:26 GMT

Hi
Sorry. There isn't any component to deal with xlsb files.
You can create issue at BugTracker for this new feature.
Regards,
Pedro

Re: [resolved] Can I Process xlsb files in Talend?

Anonymous — Wed, 19 Dec 2012 14:58:39 GMT

Sorry to revive this thread, but my search on this topic gave me no answers.
Has the status about input of xlsb changed?
Thanks for any answers.

Re: [resolved] Can I Process xlsb files in Talend?

Anonymous — Tue, 30 Apr 2013 16:12:59 GMT

Am also interested in this - i tried a simple copy and rename to .xlsx but that makes the file unstable... any ideas welcome.
Thanks

Re: [resolved] Can I Process xlsb files in Talend?

Anonymous — Wed, 01 May 2013 20:28:36 GMT

The Excel components in Talend (and mostly in Talend Exchange) are based on Apache POI. This project has not been planned to support this format. The only advantage of this format is less file size but it is not documented well enough by Microsoft. You should consider converting them to the XML based format xlsx (or xlsm in case of macros).

Re: [resolved] Can I Process xlsb files in Talend?

Anonymous — Thu, 02 May 2013 09:12:39 GMT

Thanks jlolling - unfortunately I don't have control over the source file as it's also used by others. i think by best option is to find a command line converter that I can call with Talend and then proceed from there.

Re: [resolved] Can I Process xlsb files in Talend?

Anonymous — Tue, 09 Aug 2016 11:44:29 GMT