nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

13379_en-US

liliconcom

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

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.

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.

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

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.