23.2.3 Sending and Receiving Worksheet Data

You can send and receive data between an Origin worksheet and Mathematica by using the Column tab of the tool. This tab provides controls that allow you to specify the Mathematica variable and the Origin worksheet column for sending and receiving data, as well as the range of data to be exchanged. An Origin worksheet column, or a specific range of rows in a worksheet column, will thus correspond to a user-defined variable in Mathematica.

Sending and Receiving Worksheet Data .png

The Send Column Group:

The Mathematica Variable text box should contain the name of the variable that will receive the worksheet data sent from Origin. The variable name is user-defined and should not start with a number. It should also not contain operators or periods.

The Origin Dataset text box should contain the name of the Origin dataset to be sent to Mathematica. Note that the new data range notation such as [Book1]Sheet1!Col(B) which allows addressing a specific column in a specific sheet in a specific book can be used to point to the desired worksheet column. This new range notation is recommended instead of the old dataset name notation such as Book1_B supported in previous versions. Note further that if you have an Origin worksheet active, you can refer to columns of the active worksheet by simply specifying only column information such as Col(1), Col(Pressure) etc.

The First Row and Last Row text boxes can be used to specify a range of indices or rows for the Origin dataset column. The default values are 0 and if left unchanged, the entire dataset will be transferred.

The Send button sends the data from the Origin worksheet column and assigns it to the Mathematica variable.

The Receive Column Group:

The Mathematica Variable text box should contain the name of the Mathematica variable to be transferred to Origin.

The Origin Dataset text box should contain the name of the Origin worksheet column that will receive the data from Mathematica. The column must exist in Origin and will not be created.

The First Row text box is used to specify the first row index of the Origin data column starting from which the inserted data will be placed. The default value is 0 which would insert the data from the first row.

The Receive button sends the data from the Mathematica variable and stores it in the Origin worksheet column.