Sendresultstoexcel function – Multichannel Systems NeuroExplorer User Manual

Page 221

Advertising
background image

5.5.7.5. SendResultsToExcel Function

SendResultsToExcel Function


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

Syntax


SendResultsToExcel(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 copy the data starting with
the cell specified in cellName.

cellName

string

Excel cell where to copy 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, NeuroExplorer will paste column names.

includeFileName

double

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

Returns


None

Comments


None

Usage

NexScript

doc = GetActiveDocument()

SendResultsToExcel(doc, "C:\NexResults.xls", "Nex", 0, "A1", 1, 0)

See Also

Introduction to NexScript Programming

NexScript Function Categories

Page 219

Advertising