File Exchange > Data Connector >    CSV Connector

Author:
OriginLab Technical Support
Date Added:
1/10/2019
Last Update:
5/6/2019
Downloads (90 Days):
421
Total Ratings:
0
File Size:
19 KB
Average Rating:
File Name:
CSV Connector.opx
File Version:
1.1
Minimum Versions:
License:
Free
Summary:

Import CSV from a file or website.

Screen Shot and Video:
Description:

This App connects the Origin project to a CSV file from a file or web site. 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.

Features
  • Meta data
    Meta data, including header, column name, units and comment, can be imported automatically. You can specify the settings manually as well.
    • Main header lines: number of lines that should be considered as file header. You can save it to either worksheet label area or workbook organizer.
    • Data has column name: if checked, it will read the first row next to header lines (if there's any) and import them as Long Name in the worksheet.
    • Data has units: if checked, it will read the row next to column name and import them as Units in the worksheet.
    • Comment lines after names/units: this is available if Data has column name/units is checked. You can specify the comment location either by lines after names or lines after units. There's no comment row if set to 0.
  • Data Type Detection
    This app is capable of detecting data types automatically. For example, ISO formatted date-time data (e.g. "2019-01-01 02:21:34.234") will be imported in date format. You can set the system variable @IPR = 0 in case of exceptions.
    If the data type detection does not work as expected, you may correct it before re-importing the data.
Basic Usage
  1. With the worksheet active, click on the Data menu. If you are connecting to a file on your PC or network, click Connect to File: CSV and open your file. If you are connecting to a web file, choose Data: Connect to Web and enter a URL and click OK. Check your CSV Import Options and click OK.
  2. Once a connector is added, click the connector icon in the upper-left corner of the workbook for a popup menu with various commands.
  3. By default, connector-imported data are NOT saved with the project file. To save a workbook's data with the project file, click the connector icon in the upper-left corner for that workbook and uncheck Exclude Imported When Saving. Note that each workbook has its own Exclude setting.

N.B.

  • More features of Origin Data Connector are described here.

Updates:

v1.1 4/26/2019 Fixed a bug when using LabTalk the file header like units will not be detected. For example, using script like:

wbook.dc.Add(csv);
wks.dc.source$=System.path.program$+"Samples\Batch Processing\T275K.csv";
wks.dc.import();

Reviews and Comments:

Be the first to review this File Exchange submission.