Page Comparison

• Connect to a web file, or a file on your local PC or network
• File types supported: CSV, Excel, ASCII/Binary (using Import Wizard filters), HTML, JSON, MATLAB, and Origin Projects
• Select data to be imported, such as specific node in XML, table in HTML, or Sheet in Origin Project
• Connection and data selection information is saved in worksheet/workbook
• Add connectors of same type to multiple worksheets in a workbook, and different connector types to multiple workbooks
• When saving the Origin project, you can opt to leave out the imported data associated with all connectors, or specific connectors. This can help reduce project file size. All calculated results and graphs from results will not be cleared.
• Re-import data from the source file any time. Make changes to source or to data selection at any time.
• More data connectors available for download from the App Center or from Data menu.
• With OPJU, user can bring in one entire sheet from the source OPJU file/webfile.
• Relative data source path and common data path for all connections in project. 

• Accessible from the new Data menu (Data→Connect to File and Data→Connect to Web)
• Also accessible from Connectors tab of Apps Gallary, which is docked on right side of the interface
• Need to have a workbook/Matrix active

For Data→Connect to Web..., there are sample URLs for various connectors. Click on the Recent URLs menu in the Connect to Web dialog to pick a sample URL.

We have several blogs on data connectors:

http://blog.originlab.com/category/origin-2019b

CSV connect

• can import both CSV and ASCII data with better auto detection of main header and subheader lines. 

Relative Data Source Path and Common Data Path:

• If your data are stored under relative folders of project file: Set Data Source relative to Project path. If you move project and data sources together, their relative path is the same. So no update needed in project file. 
• If there are many data sources under some common path: Set Data Source relative to Common Data Path. The Common Data Path needs to be set only in one Workbook.

LabTalk Access: 

• wks.HasDC
  • 0 = no connector in book
  • 1 = connector using sheet as destination
  • 2 = connector not using sheet as destination
• wks.DC.Source$: relative path, web source path
• wks.DC.Path$: empty if not File path, absolute path
• wks.DC.Sel$
• wks.DC.Valid
• wks.DC.SType: source type
  • 0 = absolute file path, this is the only value that is read-write
  • 1 = project relative file path
  • 2 = common data relative file path
  • 3 = web
• wks.DC.Allow()
• wks.DC.Reset(2)  //reset last imported data and label. Final released build will support wks.DC.Reset()
• wks.DC.Import(): import active sheet, and this is what the Import context menu used, which is now calling to File.ogs [DCImport]
  

Book Level Import Command:

• wbook.dc.import() or wbook.dc.import(0) : import all sheets, and this is what the Import All Sheets context menu used, which is now calling to File.OGS [DCImportAll]
  
• wbook.dc.Import(1) : for the active sheet, open Select... dialog and then do the import.
  
• wks.dc.Import

"doc -e LBC" to loop all sheets on book with Data Connector

• Example: Loop all sheets with DC and convert data source to Absolute path, books not having connector will be skipped. This will save time since project may have some books with many sheets.
  doc -e LBC { %H=; page.Active=; wks.dc.SType=0; }

Adding DC to workbook using LabTalk:

newbook;
wbook.dc.add("CSV");
wks.dc.source$="C:\temp\T275K.csv";
wks.dc.import();

wbook.dc.add("CSV");
wks.dc.source$=FromURL("http://www.sidc.be/silso/INFO/snmtotcsv.php")$;
wks.dc.import();

Import Filter Connector and LT support: 
wbook.dc.add("Import Filter");
wks.dc.source$="C:\2016\Samples\Import and Export\S15-125-03.dat";
wks.dc.sel$="test1.oif"; //filter in same folder as data. If in uff\filters, then use wks.dc.sel$="%YFilters\test1.oif";
wks.dc.import();

• • Use Origin's Notes window to create the report
  • Use Markdown or HTML syntax
  • Copy and paste-link metadata, analysis results, and graphs
  • Support for Placeholder sheet to copy and pre-format results for placement in report
  • Report can be embedded in workbook for use as Analysis Template for batch analysis
  • Report can be printed, or exported as web page with all associated images.

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

With Notes window active, go to HTML→Load Samples menu. You will find both HTML and Markdown samples.

NOTE: If you plan to write your own Markdown syntax, after opening a new Notes window, you need to right-click on title and select the Syntax→Markdown menu item. To switch between HTML and Markdown syntax, you need to first set to Text and then change to the other.

When in Markdown mode, you include html syntax, such as for setting styles, or for advanced formatting not supported by Markdown.

To view a sample OPJU showing HTML+Markdown reports:
Press F11 to open Learning Center. Then select "Analysis Samples" on left, then set the drop-down on right to "General Analysis"
Then select and open the file "Earthquakes - JSON Connector and HTML Report".
This gets data for last week's quakes from USGS and the updated data and graph are put into HTML and Markdown reports.

System variable to control using HTML or Markdown when pressing Ctrl+M

@NPS=0; /// 0 means HTML, 1 means Markdown

• Clone the current project by clearing data or clearing both data and operation
• Maintain Data Connector link to current project from the cloned project
• After cloning, you can further modify project and then save it for future use.

Menu: File→Clone current Project

This new menu replaces the old menu items File→Save Project without Data... and File→Duplicate Project without Data...

The cloned project can optionally maintain Origin Data Connector connections to the original file.

• 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

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. 

• From Plot → Statistics or Plot: 2D, there are 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

• Context menu on axis or rugs to copy and paste format
• Negative size to show rugs plot within axis frame with axis tick labels still stays with axis

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.

ORG-18180

This is supported in many tools that supports multi-sheet range.

E.g. if user wants to do statistics in same range of data on multiple sheets, user can specify the input as [book1](1:5)!1[89]:17[95]

• If it's not consecutive sheets, then what should be the syntax, (1, 3:5)!
•  together with options in Input node "Combined as Single Dataset", user can get statistics of same range in different sheets easily.

ORG-19433

• Fixed if(C=0,A,"") and C==0? A:"" issue of only filling 1st occurance of true condition.
• Default else to blank. E.g. fill column A with 1, 2, 3 and enter if(A=2,100) in column B's F(X), row 1 and 3 should be blank values instead of missing.
• IF() supports both numeric and string return. E.g. if(A<5,"small","big") works. In 2019, user needs to type if(A<5,"small","big")$

ORG-19284

ORG-19715

• IsEmpty() will give 1 for range out of bound. E.g. column A has text in 1st 4 rows only. In column B, enter formula IsEmpty(A) for rows from 1 to 10. row 5-10 will be filled with 1.
• When concatenating two string columns, use longest data to set the range. E.g. if there are 5 rows of data in column A, while 10 rows of data in column B. Set column C's formula as A$+B$.  Origin uses the 1st vector to decide the calculation range so only 1st 5 rows was conconcated. Origin 2019b, usea the longest rwo to decide range. To go back to old behavior, which used the first vector i2, set @VAS=0

• doc -rn: Make current project as Untitled and new project
• doc -e WM: Execute for all workbooks and matrix books in the project
• doc -e LBC: Execute for all sheets on book with Data Connector

del -di: Delete imported data in current sheet

ORG-19198

• Context menus to exclude files and load dependents at App Folder level
• Context menu on OGS file to run its Main section.
• Context menu on file level to load dependent files to TEMP folder

ORG-18480

ORG-19831

Added the optional argument lowbound to the COM server's method Worksheet::GetData():

OODL_PREFIX_METHOD(ODISPID_WKS_GETDATA)	HRESULT GetData([in, optional] VARIANT nRowStart, [in, optional] VARIANT nColStart, [in, optional] VARIANT nRowEnd, [in, optional] VARIANT nColEnd, [in, optional] VARIANT format, [in, optional] VARIANT lowbound, [out, retval] VARIANT * RHS);