Page Comparison

• New way to import data from file or web page
• Connection details remembered in book/sheet
• Imported data is locked from accidental/intentional editing, for keeping data integrity
• When project is saved, imported data is cleared, but output from calculations
  such as set values to new columns, operations such as LR, NLFit, Stats etc are kept.
  This helps to reduce project file size. Simply re-import when need to do further new analysis.
• A given workbook can have only one type of connector, but each sheet can have a different data sources (such as multiple CSV files connected to multiple sheets of one book
• Currently the following file formats are supported;
  CSV, HTML, JSON, Origin OPJU and MATLAB
  With OPJU, user can bring in one entire sheet from the source OPJU file/webfile

• Based on Apps, so you will find new Apps in the App Bar
• Also accessible from the new Data menu
• Need to have a workbook active

Sample URLs for testing Data Connector with web-based file:

CSV: This blog has an example.
More links to online csv files available at bottom of the blog.

HTML: Try wikipedia page such as:
https://en.wikipedia.org/wiki/World_population

JSON: This blog has an example of importing web-based JSON file.

Origin OPJU: Try this url from our dropbox:
https://www.dropbox.com/s/2x1slshxtxdlu8r/SampleData.opju?dl=1
The sample project has both worksheets and matrices. To import a matrix, you need to first make a matrix window active and then open the connector.

MATLAB: Works with older version .MAT files. Supports both worksheet and matrix as active window.

NEW in Beta3: For importing from Web file: For ALL Data Connectors:

• There is a Recent menu item on top left of the From Web dialog, which has some sample URL(s) for you to quickly load and try some sample data for the various connector types.
• The URL now supports LabTalk string variables. Here is an example:
  • First, define LT string variable such as by typing the following into script window
    dtFrom$ = "2019-01-26";
    dtTo$ = "2019-02-01";
  • Then you can use the variables in your URL, such as this example for JSON Connector:
    https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=%(dtFrom$)&endtime=%(dtTo$)
    which will then resolve to:
    https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=2019-01-26&endtime=2019-02-01
     

• With ANY data import (not just Data Connectors), user can opt to clear the imported data when saving project.
• This allows for your "analysis project" to stay small in size. You simply re-import the data, when needed, to perform further analysis

• Right-click on Workbook, select Window Properties.
• There is a new check box named "Exclude imported data when saving project."

Blog: http://blog.originlab.com/data-import/exclude-imported-data-when-saving-project

• Origin Notes window now has "HTML Mode"
• Notes can be added to workbook in order to create HTML Report as part of your Analysis Template
• Support for Place Holders in HTML that can be linked to report sheet elements such as calculation results and graphs

Blog: http://blog.originlab.com/publishing/creating-html-reports-and-documents-in-origin-2019b

Copy-paste Folders

Copy-paste workbook

Copy an entire Origin Project Folder and paste it within the same project or even to another Origin session running on the same PC

Copy workbook and paste n same session or another session.

• To copy a folder, right-click on Folder/subfolder in Project Explorer (PE) and select Copy, or do CTRL-C and then CTRL-V
• To copy a workbook and paste, Right click a book in bottom panel of PE to copy, and right click in bottom panel  of PE to Paste. 

• Create graphs such as 2D Scatter, Histogram, Kernel Density Plot, Box Plot etc.
• Open Axes dialog. You will see a new "Rug" tab with options
  • Works for multiple plots in same layer

Added support for exporting multi-sheet workbook as a multi-sheet Excel file.

File: Export: Excel

Sheets can be excluded by right-clicking on tab and selecting "Exclude from Excel Export" context menu

More first level menus to avoid  too many entries in each menu

• All Data import related to Data menu.
• With Graph window active, there is Insert menu to insert all kind of things, such as plot, graphic objects, table, etc.

The Plot menu reorganization

• Recently Used category on top.
• Icons have been rearranged so user can see all plot types in same category at once.

Some context menu changes.