XLSB File Type Continued

Jon_Taylor

Hi , I have looked through similar threads and was unsure if we should create a new thread or if I should be replying within the thread.

Anyway, in regards to .xlsb files. it is possible to have Alteryx read in a .xlsx file and out put that file to a share-point list as a .xlsb file? 

Or create a macro that can change the file type from .xlsx to .xlsb., any advice is greatly appreciated?

Thanks,

Jon

danilang

Hi @Jon_Taylor 

There is no easy way to convert a multi-sheet workbook from one format directly to another.  You could do it with a workflow/macro combination like this 

1. Main workflow reads the list of sheet names from the input workbook as passes them one by one to a batch macro

2. The batch macro read each sheet in turn and writes the data to a new .xlsb workbook

When it comes to writing the result to SharePoint, Alteryx doesn't support writing directly to SharePoint libraries.  The connector that are provided only interface with SharePoint lists.  One work around is to sync the SharePoint library to OneDrive and then read/write to your local OneDrive.  

Dan