Subscribe Bookmark RSS Feed

Execute "paste with column names" in JSL

patrickbrown94

Community Trekker

Joined:

Jun 17, 2014

Hi

i am looking for a way to execute the "paste with column names" (CTRL+Shift+V) command from a JSL script. I am importing formatted data from an excel table and I don't want to save as .csv or .xls  and then use the open() command.

Have any of you guys been able to do this?

Thanks

PB

1 REPLY
ms

Super User

Joined:

Jun 23, 2011

Assuming the data is already in the OS clip board, this code should paste it with column names into a new, empty data table.

dt=new table("Paste here");

main menu("Paste With Column Names");