KNOWLEDGEBASE - ARTICLE #1648

List of all script commands for GraphPad Prism

 You can also view this list within Prism, inside the script dialog.

 

[required argument]

<optional argument>

 

// comment

/* multiple

line

comments */

 

Simulations

ForEach [# of loops]

Regenerate

Next

Beep

In a loop, use %N to output the loop number.

 

Loops

ForEach [filespec]

ForEachSheet

Next

Beep

In any loop, use %N to output the loop number.

In a ForEach loop, use %F to output the file name and %X to output the extension.

In any loop, use %S to output the name of currently active sheet.

 

Data tables

SetYReplicates [#]

Copy [#rows] [#columns] [first row] [first col] <first subcol>

Paste [first row] [first col] <first subcol>

ClearTable <row>,<col>,<subcol>

DeleteAllDataSets <clear>

DuplicateDataTable <clear>

DuplicateFamily <prepend_text> <clear>

Import <filename> ,<row>, <col>

ImportLInk <filename> ,<row>, <col>

InsertData <row>, <col>, <subcol>

InsertDataLink <row>, <col>, <subcol>  

Inserts data contained within the script, between <data> and </data>.

ExportTable [filename] <ALL>

 

Graphs

ApplyColorScheme [scheme name]

SetAxisLimits [X Y Y2] <Segment #> [Bottom, Top, Interval #]

SetAxisTitle <X Y Y2> [Title]

SetGraphTitle [Title]

DuplicateFamily <prepend_text> <clear>

Print

 

Exporting (or copying) graphs and layouts

ExportBMP [filename] <resolution>

ExportEMF [filename] <background> <clear>

ExportJPG [filename] <resolution>

ExportPCX [filename]

ExportPICT [filename]  <resolution>      (Mac only)

ExportPNG [filename]

ExportTIF [filename] <resolution> <mode> <compress> <clear>

ExportWMF [filename] <background> <clear>

ExportPDF [filename]  <clear> <mode>

ExportEPS [filename] <mode> <nofonts> <clear>?

Copy

SendToWord

SendToPP

 

Outputting results into a table

Table Prism [#] <clear>

Table Text <&> <’delim’>

Table CSV <’delimiter’>

Table HTML <border #> <width #>

Table SQL [datasource] [Tablename] [Login] [Password] <clear>

Table XML [filename]

WTable [Column title] [row] [col] <subcol>

The first argument will become the column title in the new table. The next three arguments define the cell on the current results table that will be written to the new table.

EndTable

NextRow

 

Files

SetPath [pathname]

SetProjectName [projectname]

Save <filename>

Close

Open [Prism filename]

OpenOutput [filename], <clear>,<”delimiter”>

Import <filename> ,<row>, <col>

 

Writing to a text file

OpenOutput [filename], <clear>,<”delimiter”>

CloseOutput

WTitle, <;&>

WVersion <;&>

WText [text] , <;&>

 WDate

WCell [row], [col], <subcol>

WCol [row], [column]

WRow [row] , <col> , <subcol> , <;&>

WSheet [row] , <col> , <subcol>, <;&>

WTCol [row, col] , <;&>

WTRow [row] , <col> , <subcol>, <;&>

WTSheet [row] , <col> , <subcol>, <;&>

 

General

GoTo <section>, <sheet>, <view>

GoTo +

Print

SetSheetTitle [new_name] <K>

CloseScriptDialog

RecalcAll

SetInfo [value or text] <rownumber> <position>

SetScriptDialogTitle [dialog title]

CreateLog

Explore the Knowledgebase

Analyze, graph and present your scientific work easily with GraphPad Prism. No coding required.