BookmarkSubscribe
Choose Language Hide Translation Bar
vinkane
Community Trekker

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

0 Kudos
4 REPLIES 4
Jeff_Perkinson
Community Manager Community Manager

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
0 Kudos
Georg
Community Trekker

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

 

0 Kudos
lwx228
Community Trekker

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.
0 Kudos
txnelson
Super User

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