topic Re: Create Jmp file from C# in Discussions

Create Jmp file from C#

Jain — Fri, 04 Aug 2017 04:18:08 GMT

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

Re: Create Jmp file from C#

briancorcoran — Fri, 04 Aug 2017 12:09:49 GMT

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

Re: Create Jmp file from C#

txnelson — Fri, 04 Aug 2017 12:11:48 GMT

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

Re: Create Jmp file from C#

Craige_Hales — Fri, 04 Aug 2017 14:13:36 GMT

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.

Re: Create Jmp file from C#

Jumper2Jmp — Tue, 04 Sep 2018 07:20:15 GMT

Thank you.

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

Re: Create Jmp file from C#

briancorcoran — Tue, 04 Sep 2018 11:29:16 GMT

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

Re: Create Jmp file from C#

Jumper2Jmp — Wed, 05 Sep 2018 01:23:19 GMT

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

Re: Create Jmp file from C#

Jumper2Jmp — Wed, 05 Sep 2018 01:24:45 GMT

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

Re: Create Jmp file from C#

Jumper2Jmp — Wed, 05 Sep 2018 01:31:48 GMT

okay

I found it in folder:

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

Re: Create Jmp file from C#

Pony — Wed, 12 Jul 2023 03:13:10 GMT

yes , i also meet this issue;

if i didnot install JMP software ,but i want use C# Creat JMP file，how can I do ?

Re: Create Jmp file from C#

Craige_Hales — Wed, 12 Jul 2023 09:44:22 GMT

Without JMP installed you can't create a .JMP data table (which is a binary format.)

You can create a .JSL file (text) that will open as a data table. You can also create other formats JMP will open, including .CSV, .JSON, etc

Some of these formats are for data.