4.4 KiB
GraphPad Prism Script Commands - Quick Reference
All Commands
AnalyzeData - Execute analysis
ApplyColorScheme ["scheme name"]
Beep - Play alert sound
ClearTable ,,
Close - Close current file
CloseOutput - Close output file
CloseScriptDialog - Close script dialog
Copy - Copy entire sheet to clipboard Copy [#rows] [#columns] [first row] [first col]
CreateLayout [#rows] [#columns] <#StartingGraphIndex> <#Graphs>
CreateLog - Create log file
DeleteAllDataSets
DuplicateDataTable
DuplicateFamily [prepend_text]
EndTable - End table definition
Exit - Exit Prism (Windows only)
ExportAllPDF [filename]
ExportBMP [filename]
ExportEMF [filename] (Windows only)
ExportEPS [filename]
ExportJPG [filename]
ExportPDF [filename]
ExportPNG [filename]
ExportSVG [filename]
ExportTable [filename]
ExportTIF [filename]
ExportWMF [filename] (Windows only)
ForEach [# of loops] ForEach [filespec, i.e. "C:\data\DR*.txt"]
ForEachSheet - Loop over all sheets in current section
GoTo <section: D, I, R, G, or L>, <sheet#>, V<tab#> GoTo + (next sheet) GoTo - (previous sheet)
Import <"filename">, , ,
ImportLink <"filename">, , ,
InsertData , ,
InsertDataLink , ,
Next - End loop iteration
NextRow - Move to next table row
Open ["filename"]
OpenOutput ["filename"] ,, <"delimiter">
Paste - Paste from clipboard at current position Paste [first row] [first col]
Print - Print current sheet
RecalcAll - Recalculate all results
Regenerate - Regenerate random numbers (Monte Carlo)
Save <"filename">
SendToPP - Send to PowerPoint (Windows only)
SendToWord - Send to Word (Windows only)
SetAxisLimits [which axis: X, Y, or Y2] <segment #> [Top/Bottom/Interval] [value]
SetAxisTitle [which axis: X, Y, or Y2] ["new title"]
SetGraphTitle ["new title"]
SetInfo ["value"] [rownumber] <position: 0 (name) or 1 (value) or 2 (notes)>
SetPath ["drive and folder path"]
SetProjectName ["new name"]
SetScriptDialogTitle ["dialog title"]
SetSheetTitle [new_name]
SetValueToInfo [infotable #] [inforow#] [datarow] [datacol]
SetYReplicates [#]
Table Prism [datatable number] Table SQL [datasource] Table XML [filename]
WBlock [row(s)] [column(s)] <;>
WCell [row], [col], <;&>
WCol [row],
, <;&>WDate <;&>
WRow [row],
, <;&>WSheet <row, col, subcol><;&>
WTable [column title] [row] [col] WTable [column title] [text or %F or %N]
WText <"text"> <;&>
WTBlock [row(s)] [columns to include] <;>
WTCol [row, col] <, subcolumn><;&>
WTitle - Write sheet title
WTRow [row] <,col, subcol> <;&>
WTSheet <row, col, subcol><;&>
WVersion - Write Prism version
Variables
%N - Loop iteration number %F - Filename (without extension) %X - File extension %S - Sheet name %D - Date and time file was last saved %P - Prism project filename %% - Literal percent sign
Syntax Notation
[required] - Required parameter - Optional parameter <;&> - Optional semicolon (continue on same line with tab) or ampersand (continue without tab) <;> - Optional semicolon (joins text without delimiter) CLEAR - Keyword to clear existing content
Section Codes
D - Data tables I - Info tables R - Results tables G - Graphs L - Layouts
Column/Row Numbering
Columns: -1 (Row titles), 0 (X column), 1 (Column A), 2 (Column B)... Rows: 0 or -1 (Column titles), 1 (First data row), 2 (Second data row)...
Data Block Syntax
value1 value2 value3 value4 value5 value6Comments
// Single line comment /* Multi-line comment */