Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesCurrently we are able to write data to an .xlsb file if the Access Driver 2010 is installed. What we are not able to do is, write data to a specific cell location the way we can do in the case of .xlsx files for example:
C:\Users\kk\Downloads\Testfile.xlsx|||'Sheet1$A2:C4' (This works)
C:\Users\kk\Downloads\Testfile.xlsb|||'Sheet1$A2:C4' (This doesn't work currently in Alteryx)
C:\Users\kk\Downloads\Testfile.xlsb|||Sheet1 (This too works)
The problem is that in the case of xlsb files it uses the access database engine, if we are able to find the correct input to parse to the database engine the way we do in case of vba scripts then all the BFSI sector individuals have a highly space optimized pixel perfect reporting possible in Alteryx itself.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.