Subscribe Bookmark RSS Feed

Save xlsx to csv file

blue1994

Contributor

Joined:

Feb 27, 2017

Hi,

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

thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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" );
Jim
1 REPLY
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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" );
Jim