save data table as excel xlsb

Question

Need to save a data table (4.5M rows) as an Excel file xlsb format. I see no error message in the log file and I see no file saved in Excel

Thanks

txnelson · Answer

@lwx228

I have a suggestion.  It sure would be nice if you or some other VBA user to develop a JMP Addin that probably uses the "Run Program()" function in JSL to take an XLSX and converts it into an XSLB.  And then to add the JMP Addin to the JMP File Exchange.

lwx228 · Answer

I also use XLSB a lot, save, open quickly, and can store VBA.
It is easy to convert XLSX into XLSB using VBA batch.

Georg · Answer

Dear Jeff and all,

I'm missing capability of JMP to read xlsb files, many colleagues of mine are using this format.

Is it still true, that JMP does not support reading and writing of xlsb (because there is no documentation)?

Thanks and best regards,

Georg

PS: using JMP 14.0.0 @Windows10 Enterprise both 64 bit versions