Sendresultssummarytoexcel function – Multichannel Systems NeuroExplorer User Manual

Page 226

Advertising
background image

5.5.7.10. SendResultsSummaryToExcel Function

SendResultsSummaryToExcel Function


Sends summary of numerical results (of the first graphics window of the document) to Excel.

Syntax


SendResultsSummaryToExcel(doc, fileName, worksheetName, useFirstEmptyRow, cellName,
includeHeader, includeFileName)

Parameters

Parameter

Type

Description

doc

documentReference Reference to the document.

fileName

string

Excel file path.

worksheetName

string

Excel worksheet name.

useFirstEmptyRow

double

If 1, NeuroExplorer will ignore cellName parameter
and add the results to the first row where the cell in
column A is empty.
If 0, NeuroExplorer will paste data starting with the
cell specified in cellName.

cellName

string

Excel cell where to paste the results. Should be in
the form CR where C is Excel column name, R is
the row number. For example, A1 is the top-left cell
in the worksheet.

includeHeader

double

If 1, will paste column names.

includeFileName

double

If 1, will add a column with the data file name.

Returns


None

Comments


None

Usage

NexScript

doc = GetActiveDocument()

SendResultsSummaryToExcel(doc, "C:\results\res.xls", "FromNex", 0, "A1", 1, 0)

See Also

Introduction to NexScript Programming

NexScript Function Categories

Page 224

Advertising