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