Purpose
This App can be used to import worksheet data or matrix sheet data from an Origin project file (.opju/.opj) or a website. It can connect to the source file, when the source is changed, the imported data in Origin is also updated. Origin 2019b or later, required.
Installation
This App is pre-installed in Origin. You can launch it from the Data menu or from the App icon on the Connector tab of the Apps Gallery, located at the right-side of the Origin workspace. If you do not see the menu command or App icon, click Data: Connect to File: Add New.... The App Center opens listing only Connector Apps. Click the Download and Install button to install an App.
Operation
- With the worksheet or matrix sheet active, click on the Data menu. If you are connecting to a file on your PC or network, click Connect to File: Origin File and open your file. If you are connecting to a web file, choose Data: Connect to Web and enter a URL and click OK. All worksheets and matrix sheets in the file are listed as a tree. Select data to import and click OK.
- Once a connector is added, click the connector icon in the upper-left corner of the book to open a popup menu with various commands.
- By default, connector-imported data are NOT saved with the project file. To save a book's data with the project file, click the connector icon in the upper-left corner for that book and uncheck Exclude Imported When Saving. Note that each book has its own Exclude setting.
Notes
From Origin 2020, Origin Connector supports SQL query language to select desired data stored in an Origin project file. For more information, see SQL query in Origin Connector.