cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-8726%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9C%A8%20JSL%20%E4%B8%AD%E5%9F%B7%E8%A1%8C%E2%80%9C%E4%BD%BF%E7%94%A8%E5%88%97%E5%90%8D%E8%B2%BC%E4%B8%8A%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8726%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CP%3E%E4%BD%A0%E5%A5%BD%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%E6%88%91%E6%AD%A3%E5%9C%A8%E5%B0%8B%E6%89%BE%E4%B8%80%E7%A8%AE%E6%96%B9%E6%B3%95%E4%BE%86%E5%BE%9E%20JSL%20%E8%85%B3%E6%9C%AC%E5%9F%B7%E8%A1%8C%E2%80%9C%E4%BD%BF%E7%94%A8%E5%88%97%E5%90%8D%E7%A8%B1%E8%B2%BC%E4%B8%8A%E2%80%9D(CTRL%2BShift%2BV)%20%E5%91%BD%E4%BB%A4%E3%80%82%20%E6%88%91%E6%AD%A3%E5%9C%A8%E5%BE%9E%20Excel%20%E8%A1%A8%E5%B0%8E%E5%85%A5%E6%A0%BC%E5%BC%8F%E5%8C%96%E6%95%B8%E6%93%9A%EF%BC%8C%E4%BD%86%E4%B8%8D%E6%83%B3%E5%8F%A6%E5%AD%98%E7%82%BA%20.csv%20%E6%88%96%20.xls%EF%BC%8C%E7%84%B6%E5%BE%8C%E4%BD%BF%E7%94%A8%20open()%20%E5%91%BD%E4%BB%A4%E3%80%82%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%E4%BD%A0%E5%80%91%E6%9C%89%E4%BA%BA%E8%83%BD%E5%A4%A0%E5%81%9A%E5%88%B0%E9%80%99%E4%B8%80%E9%BB%9E%E5%97%8E%EF%BC%9F%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%E8%AC%9D%E8%AC%9D%3C%2FP%3E%3CP%3EPB%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8727%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%9C%A8%20JSL%20%E4%B8%AD%E5%9F%B7%E8%A1%8C%E2%80%9C%E4%BD%BF%E7%94%A8%E5%88%97%E5%90%8D%E7%A8%B1%E8%B2%BC%E4%B8%8A%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8727%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%81%87%E8%A8%AD%E8%B3%87%E6%96%99%E5%B7%B2%E7%B6%93%E5%9C%A8%E4%BD%9C%E6%A5%AD%E7%B3%BB%E7%B5%B1%E5%89%AA%E8%B2%BC%E7%B0%BF%E4%B8%AD%EF%BC%8C%E6%AD%A4%E7%A8%8B%E5%BC%8F%E7%A2%BC%E6%87%89%E5%B0%87%E5%85%B6%E8%88%87%E5%88%97%E5%90%8D%E7%A8%B1%E4%B8%80%E8%B5%B7%E8%B2%BC%E4%B8%8A%E5%88%B0%E6%96%B0%E7%9A%84%E7%A9%BA%E8%B3%87%E6%96%99%E8%A1%A8%E4%B8%AD%E3%80%82%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%20style%3D%22font-size%3A%2015px%3B%20font-family%3A%20Courier%3B%20color%3A%20%23942193%3B%22%3E%3CSPAN%20style%3D%22color%3A%20%23000000%3B%22%3Edt%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23011993%3B%22%3E%20%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23032ce4%3B%22%3E%E6%96%B0%E8%A1%A8%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000000%3B%22%3E%3CSTRONG%3E(%3C%2FSTRONG%3E%3C%2FSPAN%3E%20%E2%80%9C%E8%B2%BC%E5%88%B0%E9%80%99%E8%A3%A1%E2%80%9D%3CSPAN%20style%3D%22color%3A%20%23000000%3B%22%3E%3CSTRONG%3E%20%EF%BC%89%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23011993%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%20style%3D%22font-size%3A%2015px%3B%20font-family%3A%20Courier%3B%20color%3A%20%23942193%3B%22%3E%3CSPAN%20style%3D%22color%3A%20%23032ce4%3B%22%3E%E4%B8%BB%E9%81%B8%E5%96%AE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23000000%3B%22%3E%3CSTRONG%3E%EF%BC%88%3C%2FSTRONG%3E%3C%2FSPAN%3E%20%E2%80%9C%E8%B2%BC%E4%B8%8A%E5%88%97%E5%90%8D%E2%80%9D%3CSPAN%20style%3D%22color%3A%20%23000000%3B%22%3E%3CSTRONG%3E%20%EF%BC%89%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23011993%3B%22%3E%20%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Execute "paste with column names" in JSL

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 1
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Execute "paste with column names" in JSL

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

Recommended Articles