cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-42842%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ECrear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42842%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EQuiero%20crear%20un%20archivo%20jmp%20con%20una%20hoja%20de%20c%C3%A1lculo%20simple%20como%20la%20siguiente%20usando%20C%23.%20%C2%BFC%C3%B3mo%20puedo%20lograr%20eso%3FAgradecer%C3%A9%20cualquier%20sugerencia%20o%20c%C3%B3digo%20de%20muestra.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENombre%20Salario%3C%2FP%3E%3CP%3EJuan%2070000%3C%2FP%3E%3CP%3Emicro%2080000%3C%2FP%3E%3CP%3Emichelle%2090000%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGracias%2C%3CBR%20%2F%3E%20Shrish%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71318%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71318%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Ebueno%3C%2FP%3E%3CP%3ELo%20encontr%C3%A9%20en%20la%20carpeta%3A%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF6600%22%3E%3CEM%3ED%3A%5CArchivos%20de%20programa%5CSAS%5CJMP%5C13%5CSamples%5CAutomation%5CVisual%20CSharp%20Sample%5CJMPStarter%5Cobj%5CDebug%5CInterop.JMP.dll%3C%2FEM%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71317%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71317%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CSPAN%3Egracias%20.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%20Y%20s%C3%A9%20c%C3%B3mo%20agregar%20pero%20no%20puedo%20encontrar%20d%C3%B3nde%20est%C3%A1%20el%20archivo%20JMP.dll%2C%20%C2%BFpuedes%20por%20favor%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71316%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71316%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3Egracias%20.%3CBR%20%2F%3E%20Y%20s%C3%A9%20c%C3%B3mo%20agregar%20pero%20no%20puedo%20encontrar%20d%C3%B3nde%20est%C3%A1%20el%20archivo%20JMP.dll%2C%20%C2%BFpuedes%20por%20favor%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71198%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71198%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20debe%20agregarse%20como%20referencia%20a%20su%20proyecto%2C%20despu%C3%A9s%20de%20ubicar%20el%20archivo%20jmp.tlb%20que%20est%C3%A1%20instalado%20(c%3A%5Carchivos%20de%20programa%5Csas%5Cjmp%5C14).El%20Automation%20Reference.pdf%20que%20se%20proporciona%20con%20la%20documentaci%C3%B3n%20de%20JMP%20contiene%20los%20pasos%20para%20hacerlo.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBrian%20Corcor%C3%A1n%3C%2FP%3E%0A%3CP%3EDesarrollo%20JMP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-71151%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-71151%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGracias.%3C%2FP%3E%3CP%3EPero%20el%20proyecto%20de%20muestra%20tiene%20una%20referencia%20llamada%20%22JMP%22%2C%20entonces%2C%20%C2%BFd%C3%B3nde%20puedo%20obtenerlo%2C%20por%20favor%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20style%3D%22width%3A%20360px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20style%3D%22width%3A%20360px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20style%3D%22width%3A%20360px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20style%3D%22width%3A%20360px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20style%3D%22width%3A%20360px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20style%3D%22width%3A%20360px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20style%3D%22width%3A%20360px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F12290i4D6E02BA691430D6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20alt%3D%22%E6%88%AA%E5%9B%BE.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42859%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42859%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EO%2C%20si%20realmente%20desea%20que%20C%23%20emita%20una%20tabla%20de%20datos%2C%20intente%20esto%3A%3C%2FP%3E%0A%3CP%3EEn%20JMP%2C%20cree%20una%20tabla%20que%20se%20parezca%20a%20lo%20que%20desea%2C%20incluidas%20algunas%20filas%20de%20datos%20y%20con%20columnas%20del%20tipo%20correcto%20(car%C3%A1cter%2C%20num%C3%A9rico).%20Use%20el%20tri%C3%A1ngulo%20rojo%20para%20copiar%20el%20script%20y%20pegarlo%20en%20un%20editor.%20Si%20estudia%20la%20secuencia%20de%20comandos%2C%20ver%C3%A1%20c%C3%B3mo%20podr%C3%ADa%20escribir%20una%20secuencia%20de%20comandos%20similar%20de%20C%23%20a%20un%20archivo%20.JSL%2C%20con%20sus%20datos%20sustituidos.%20Ejecutar%20ese%20archivo%20.JSL%20crear%C3%A1%20la%20tabla%20de%20datos%20en%20JMP.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42854%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42854%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20proporciona%20un%20ejemplo%20de%20C%23%20en%20el%20c%C3%B3digo%20de%20muestra%20que%20se%20instala%20cuando%20instala%20JMP.%20Aqu%C3%AD%20est%C3%A1%20la%20ruta%20a%20la%20versi%C3%B3n%20JMP%2013%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC%3A%5CArchivos%20de%20programa%5CSAS%5CJMPPRO%5C13%5CSamples%5CAutomation%5CVisual%20CSharp%20Sample%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42853%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42853%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESu%20instalaci%C3%B3n%20de%20JMP%20contiene%20un%20ejemplo%20de%20C%23%20que%20describe%20c%C3%B3mo%20automatizar%20JMP.%20Por%20lo%20general%2C%20se%20encuentra%20en%20la%20carpeta%20C%3A%5CProgram%20Files%5CSAS%5CJMP%5C13%5CSamples%5CAutomation%5CVisual%20C%23%20Sample%5CJMPStarter.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBrian%20Corcor%C3%A1n%3C%2FP%3E%0A%3CP%3EDesarrollo%20JMP%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-657625%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-657625%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESin%20JMP%20instalado%2C%20no%20puede%20crear%20una%20tabla%20de%20datos%20.JMP%20(que%20es%20un%20formato%20binario).%3C%2FP%3E%0A%3CP%3EPuede%20crear%20un%20archivo%20.JSL%20(texto)%20que%20se%20abrir%C3%A1%20como%20una%20tabla%20de%20datos.%20Tambi%C3%A9n%20puede%20crear%20otros%20formatos%20que%20JMP%20abrir%C3%A1%2C%20incluidos%20.CSV%2C%20.JSON%2C%20etc.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Some%20of%20these%20formats%20are%20for%20data.%22%20style%3D%22width%3A%20604px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Some%20of%20these%20formats%20are%20for%20data.%22%20style%3D%22width%3A%20604px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Some%20of%20these%20formats%20are%20for%20data.%22%20style%3D%22width%3A%20604px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Some%20of%20these%20formats%20are%20for%20data.%22%20style%3D%22width%3A%20604px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54592i48C6ECA2958D9C81%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22capture.png%22%20alt%3D%22Some%20of%20these%20formats%20are%20for%20data.%22%20%2F%3E%3Cspan%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESome%20of%20these%20formats%20are%20for%20data.%3C%2Fspan%3E%3C%2Fspan%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESome%20of%20these%20formats%20are%20for%20data.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESome%20of%20these%20formats%20are%20for%20data.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EAlgunos%20de%20estos%20formatos%20son%20para%20datos.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-657511%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Crear%20archivo%20Jmp%20desde%20C%23%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-657511%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Es%C3%AD%2C%20tambi%C3%A9n%20me%20encuentro%20con%20este%20problema%3B%3C%2FP%3E%3CP%3ESi%20no%20instal%C3%A9%20el%20software%20JMP%2C%20pero%20quiero%20usar%20el%20archivo%20C%23%20Create%20JMP%2C%20%C2%BFc%C3%B3mo%20puedo%20hacerlo%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
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

10 REPLIES 10
Craige_Hales
Super User

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

Recommended Articles