ReportCell

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