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.
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 .
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
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.