topic Re: Execute &quot;paste with column names&quot; in JSL in Discussions https://community.jmp.com/t5/Discussions/Execute-quot-paste-with-column-names-quot-in-JSL/m-p/8727#M8715 <HTML><HEAD></HEAD><BODY><P>Assuming the data is already in the OS clip board, this code should paste it with column names into a new, empty data table.</P><P></P><P style="font-size: 15px; font-family: Courier; color: #942193;"><SPAN style="color: #000000;">dt</SPAN><SPAN style="color: #011993;">=</SPAN><SPAN style="color: #032ce4;">new table</SPAN><SPAN style="color: #000000;"><STRONG>(</STRONG></SPAN>"Paste here"<SPAN style="color: #000000;"><STRONG>)</STRONG></SPAN><SPAN style="color: #011993;">;</SPAN></P><P style="font-size: 15px; font-family: Courier; color: #942193;"><SPAN style="color: #032ce4;">main menu</SPAN><SPAN style="color: #000000;"><STRONG>(</STRONG></SPAN>"Paste With Column Names"<SPAN style="color: #000000;"><STRONG>)</STRONG></SPAN><SPAN style="color: #011993;">;</SPAN></P></BODY></HTML> Wed, 18 Jun 2014 10:43:12 GMT ms 2014-06-18T10:43:12Z Execute "paste with column names" in JSL https://community.jmp.com/t5/Discussions/Execute-quot-paste-with-column-names-quot-in-JSL/m-p/8726#M8714 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>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&nbsp; and then use the open() command.</P><P></P><P>Have any of you guys been able to do this?</P><P></P><P>Thanks </P><P>PB</P></BODY></HTML> Wed, 18 Jun 2014 01:45:58 GMT https://community.jmp.com/t5/Discussions/Execute-quot-paste-with-column-names-quot-in-JSL/m-p/8726#M8714 patrickbrown94 2014-06-18T01:45:58Z Re: Execute "paste with column names" in JSL https://community.jmp.com/t5/Discussions/Execute-quot-paste-with-column-names-quot-in-JSL/m-p/8727#M8715 <HTML><HEAD></HEAD><BODY><P>Assuming the data is already in the OS clip board, this code should paste it with column names into a new, empty data table.</P><P></P><P style="font-size: 15px; font-family: Courier; color: #942193;"><SPAN style="color: #000000;">dt</SPAN><SPAN style="color: #011993;">=</SPAN><SPAN style="color: #032ce4;">new table</SPAN><SPAN style="color: #000000;"><STRONG>(</STRONG></SPAN>"Paste here"<SPAN style="color: #000000;"><STRONG>)</STRONG></SPAN><SPAN style="color: #011993;">;</SPAN></P><P style="font-size: 15px; font-family: Courier; color: #942193;"><SPAN style="color: #032ce4;">main menu</SPAN><SPAN style="color: #000000;"><STRONG>(</STRONG></SPAN>"Paste With Column Names"<SPAN style="color: #000000;"><STRONG>)</STRONG></SPAN><SPAN style="color: #011993;">;</SPAN></P></BODY></HTML> Wed, 18 Jun 2014 10:43:12 GMT https://community.jmp.com/t5/Discussions/Execute-quot-paste-with-column-names-quot-in-JSL/m-p/8727#M8715 ms 2014-06-18T10:43:12Z