topic Re: Save xlsx to csv file in Discussions

Save xlsx to csv file

blue1994 — Mon, 06 Mar 2017 01:50:21 GMT

Hi,

anyone know how to save .xlsx to csv file with jsl? Is it possible to make it?

thanks.

Re: Save xlsx to csv file

txnelson — Mon, 06 Mar 2017 02:21:11 GMT

names default to here(1);

dt=Open("path to the file.xlsx");

dt<<save as("path to new file.csv");

Details can be found at:

Help==>Scripting Index==>Data Table==>Save As

Here is the example from the Scripting Index

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Save( "C:\Big Class.jmp" );
dt << Save( "C:\Big Class.csv" );

Re: Save xlsx to csv file

nikles — Mon, 23 Nov 2020 01:23:05 GMT

Hi @txnelson . I'm curious if you happen to know of a method to convert an xlsx file to csv or text that does not require opening the xlsx as a JMP table first. I have a few reasons, but the biggest reason is speed. I've found that I can open a csv as a text string and perform a lot of preprocessing on it before creating the jmp table. This seems to greatly improve speed, especially when opening multiple dozens of files at once. My thinking is if I could convert excel tables to csv first, I could use the same script that I already use for opening our csv files into JMP.

I've been looking at the possibility of incorporating a python script into my jsl script, but I'm reluctant to require users to have the right python version and libraries on their machines. Would be nice if there were a way to do it directly.

Any thoughts on this are greatly appreciated. Thanks.

Re: Save xlsx to csv file

txnelson — Mon, 23 Nov 2020 02:29:04 GMT

There may be a 3rd party shareware product out there that converts xlsx to csv, but there is nothing in native JMP to do that without reading it in as a JMP file first.

Re: Save xlsx to csv file

nikles — Mon, 23 Nov 2020 16:49:13 GMT

Got it. Thanks Jim.