how to read .XLSB file in designer
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi there, just like you would normally do with a xlsx file. I personally like to drag from the folder directly to the Canva.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No , it's not working, throwing error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Make sure you change #2 to .xlsb
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
there .xlsb is not an option
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It could be a version issue. What version are you using?
You can check this post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-xlsb-Files-in-2018-1/m-p...
I attached what it looks like in version 2023.2, for you reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am using 2021.4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try this link to download the Access Drivers you need - https://www.microsoft.com/en-us/download/details.aspx?id=39358
It's the recommended version based on this KB article - https://knowledge.alteryx.com/index/s/article/How-to-Enable-Microsoft-Excel-Binary-Excel-Legacy-Acce...
