3.5.8.19 ReportCellReportCell-func
Description
Accesses to report table cell and returns the content of the cell.
Syntax
ReportCell(string sBook$, string sSheet$, string sTable$, string sRowRef$, string sColRef$)
Parameters
sBook
- Book name you want to access. Active workbook will be used if empty.
sSheet
- Report sheet name you want to access
sTable
- Table name in the report sheet you want to access
sRowRef
- row reference of the report table cell you want to access
sColRef
- column reference of the report table cell you want to access
Return
Returns the content of the report table cell
Examples
Example 1
Suppose you performed a Gauss Nonlinear Curve Fit on columns in Book1 and generated a report sheet "NLFit".
ReportCell("Book1", "FitNL1", "Summary", "R1", "a_Value") =; //returns the fitted value of parameter "A"
ReportCell("Book1","FitNL1", "RegStats", "C1","FitStatus")$ = ; //returns fitting status
Example 2
If you performed One Way ANOVA on data in Book1 and generted report table "ANOVA1Way1", following formula returns the sum of squares.
ReportCell("Book1","ANOVA1Way1","ANOVAs.OvarallANOVA","Model1","SSq")
See Also
|