SendResultsToExcel

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	number	If 1, NeuroExplorer will ignore cellName parameter and add the results to the first row where the cell in column A is empty. If 2, NeuroExplorer will ignore cellName parameter and add the results to the first column where the cell in row 1 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	number	If 1, NeuroExplorer will paste column names.
includeFileName	number	If 1, NeuroExplorer will add a column with the data file name.

Return

None.

Note

See Specifying Windows file paths in Python for details on specifying file paths with backslashes in Python.

Examples

Python

import nex
doc = nex.GetActiveDocument()
nex.ApplyTemplate(doc, "Autocorrelograms")
nex.SendResultsToExcel(doc, "C:\\Data\\NexResults.xlsx", "Nex", 0, "A1", 1, 0)

NexScript

doc = GetActiveDocument()
ApplyTemplate(doc, "Autocorrelograms")
SendResultsToExcel(doc, "C:\Data\NexResults.xlsx", "Nex", 0, "A1", 1, 0)