Choose Language Hide Translation Bar
Highlighted
Jain
Level I

Create Jmp file from C#

I want to create a jmp file with a simple spreadsheet like below using C#. How can I achieve that? I will appreciate any pointers or sample code.

 

Name    Salary

John    70000

Mike     80000

Michelle 90000

 

Thanks,
Shrish

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Create Jmp file from C#

Your JMP install contains a C# example that describes how to automate JMP.  It is typically found under the folder C:\Program Files\SAS\JMP\13\Samples\Automation\Visual C# Sample\JMPStarter .

 

Brian Corcoran

JMP Development

View solution in original post

8 REPLIES 8
Highlighted

Re: Create Jmp file from C#

Your JMP install contains a C# example that describes how to automate JMP.  It is typically found under the folder C:\Program Files\SAS\JMP\13\Samples\Automation\Visual C# Sample\JMPStarter .

 

Brian Corcoran

JMP Development

View solution in original post

Highlighted
Jumper2Jmp
Level I

Re: Create Jmp file from C#

Thank you.

But The sample project has an reference named ''JMP", so where can i get it please?

 


截图.PNG

 

Highlighted

Re: Create Jmp file from C#

JMP must be added as a reference to your project, after you locate the jmp.tlb file that is installed (c:\program files\sas\jmp\14).  The Automation Reference.pdf that is supplied with the JMP Documentation contains the steps to do this.

 

Brian Corcoran

JMP Development

Highlighted
Jumper2Jmp
Level I

Re: Create Jmp file from C#

thank you .
And I know how to add but I can not find where is JMP.dll file, can you please?
Highlighted
Jumper2Jmp
Level I

Re: Create Jmp file from C#

thank you .
And I know how to add but I can not find where is JMP.dll file, can you please?

Highlighted
Jumper2Jmp
Level I

Re: Create Jmp file from C#

okay

I found it in folder:

D:\Program Files\SAS\JMP\13\Samples\Automation\Visual CSharp Sample\JMPStarter\obj\Debug\Interop.JMP.dll

Highlighted
txnelson
Super User

Re: Create Jmp file from C#

JMP provides a C# example in the sample code that is installed when you install JMP.  Here is the path to the JMP 13 version

 

C:\Program Files\SAS\JMPPRO\13\Samples\Automation\Visual CSharp Sample

Jim
Highlighted
Craige_Hales
Staff (Retired)

Re: Create Jmp file from C#

Or, if you really want C# to emit a data table, try this: 

In JMP, make a table that looks like what you want, including a few rows of data, and with columns of the right type (character, numeric). Use the red triangle to copy the script, and paste into an editor. If you study the script, you'll see how you could write a similar script from C# to a .JSL file, with your data substituted in. Running that .JSL file will make the data table in JMP.

 

Craige
Article Labels

    There are no labels assigned to this post.