Setexcelcell function – Multichannel Systems NeuroExplorer User Manual
Page 271
5.5.10.1. SetExcelCell Function
SetExcelCell Function
Sets the text value of the specified cell in Excel.
Syntax
SetExcelCell(worksheet, cell, text, excelFilePath)
Parameters
Parameter
Type
Description
worksheet
string
The name of the worksheet.
cell
string
Excel cell specification, 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.
text
string
The text to be copied to the cell.
excelFilePath
string
Full path of the Excel file. This parameter is optional.
See Usage below.
Returns
None
Comments
None
Usage
NexScript
% this call will open Excel, Excel will create
% a new workbook (Excel file) and paste the text to the specified cell
SetExcelCell("fromNex", "A1", "cell text")
% this call will set the cell in the specified Excel file
SetExcelCell("fromNex", "A1", "cell text", "C:\Data\Results.xls")
See Also
Introduction to NexScript Programming
Page 269