6.5.1 Connecting to File

Data Connector builds connection between Origin worksheet/matrix and a local data file. Many file types are supported. More file types can be added by Add New menu.

To open Data Connector

  1. With a worksheet/matrix active, choose Data: Connect to File.
  2. Select a desired data file from the opened browser.

CSV\Excel file

The Import Options dialog Will open, providing simple options to

  • specify the main header and the sub-header, including column Long Name, Units and Comments.
  • For CSV file, the dialog provides option to save the main header (meta data) to column labels or workbook Orgnizer.
  • For Excel file which has multiple sheets, the dialog provides option to specify which sheet to import.
CSV Excel
Csv import option dlg.png Excel import option dlg.png

JSON\Project\HDF\XML\MATLAB file

The Data Connector Browser dialog will open.

Project DC dialog.png

The upper panel loads the structure of the imported file. Click on one branch to view the meta data in the right panel. Choose the desired branch and click the down arrow to add it to the lower panel. Click OK button to import.

HTML Table

The Data Connector Browser dialog will open.

Json DC dialog.png

The upper panel loads all the tables on the web page. Choose the desired table and click the down arrow to add it to the lower panel. Click OK button to import.

Import a File with Filter

  1. With a worksheet/matrix active, choose Data: Connect to File: Import Filter.
  2. Select a desired data file from the opened browser.
  3. In the Select Filter dialog, select the desired filter. Click OK to import.
Select filter dialog.png

Other types added by Add New Menu

Add New menu will open the App Center dialog with all published Data Connector Apps listed. Choose the desired Apps to add to the Data menu.

Click on the App title to open a web browser to File Exchange page to see the detailed documents of that App.

Or,

Manually open the File Exchange field on OriginLab website. On the Apply Filter panel on the left, check Data Connector checkbox under Refine by Category. This will filter all Data Connector Apps. Click on the desired App to download that App and see the detailed documents on its own page.