BookmarkSubscribeSubscribe to RSS Feed
vinkane

Community Trekker

Joined:

Dec 23, 2013

save data table as excel xlsb

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

4 REPLIES
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Re: save data table as excel xlsb

Unfortunately, JMP can't write the XLSB format. It's a binary format that Microsoft doesn't document well.

Sorry.

-Jeff

-Jeff
Georg

Community Trekker

Joined:

Sep 5, 2017

Re: save data table as excel xlsb

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

 

lwx228

Frequent Contributor

Joined:

Aug 14, 2018

Re: save data table as excel xlsb


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

Super User

Joined:

Jun 22, 2012

Re: save data table as excel xlsb

@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.

Jim