Connectivity in Origin and OriginPro
Origin can function as an automation server (or COM, Component Object Model) whereby other applications communicate with Origin using methods and properties exposed by Origin. Any application that supports COM programming, such as Visual Basic, Microsoft Excel, National Instruments LabVIEW, or similar can function as the client application that connects with Origin. Such applications can exchange data back and forth with Origin and can send commands to be executed by Origin.
Data can be copied from Excel with full accuracy and pasted into Origin. Files can be imported in XLS, XLSX, and XLSM formats. It is not necessary to install MS Excel to import these file types. Row numbers for column name, units, comments, and other metadata can be specified before import, and cell formatting can be retained (except cell formulas). When the external Excel file is updated, it is possible to quickly re-import data. In addition, Excel workbooks can also be opened and edited directly in Origin, allowing opportunities from both programs to be shared.
The Origin Link for Mathematica tool can easily connect Mathematica with Origin and then to exchange worksheet and matrix data between them. Other operations such as evaluating Mathematica expressions and creating Origin graphs using Mathematica functions are also allowed.
Origin provides a collection of custom LabVIEW sub-Vis that are included in the installation. LabVIEW users can incorporate these custom sub-VIs in their main LabVIEW application to communicate seamlessly with Origin. These sub-VIs take advantage of Origin's automation server classes and can be used for operations such as opening and closing communication with Origin, exchanging data between Origin and LabVIEW, and sending commands to Origin.
If a computer has access to R, users can execute R commands directly or an R file within Origin, as well as exchange data between Origin and R. In this way, they can benefit from the statistical computing power of R and combine it with Origin's advanced graphical functionality:
- Access R's statistical functionality (open source).
- Interactive exchange of data and results between Origin and R.
- Full compatibility with R's core data types such as matrix and data frames
- Local and remote access to R via R Console and Rserve Console, respectively
- Draw results obtained with R using Origin to obtain publication-ready ready to be published