QtiPlot

Interoperability with OriginLab

QtiPlot can import *.opj project files created with OriginLab versions ranging from 2.0 to 10.0 (Origin 2023). The new project format (*.opju) introduced in Origin 2018 is only supported on Windows operating systems. On Windows, *.opju projects can also be converted to *.opj files, that can be afterwards imported directly by QtiPlot on macOS and Linux operating systems.

QtiPlot can also export individual project windows, projects folders or entire projects as Origin C files that can be compiled and imported by OriginLab, please watch this video available in our YouTube channel for a quick example.

Import of old OriginLab version format files (*.org).

Example showing that old OriginLab version format files (*.org) can be easily imported in QtiPlot.

QtiPlot can also import the different types of OriginLab individual window files: workbooks (*.ogw files), matrices (*.ogg files) and graphs (*.ogg files). Please watch this video available in our YouTube channel for a quick example.

Microsoft Excel

Embedding Excel workbooks into QtiPlot as OLE objects.

QtiPlot can import data from workbooks stored in binary *.xls or *xlsx files, as well as from Microsoft Excel *.xml files, using different methods. On Windows operating systems where Microsoft Excel is locally installed, QtiPlot can also import the charts from workbooks. Please watch this video available in our YouTube channel for a quick example.

QtiPlot can export data from table and matrix windows as binary *.xls files.

Working with Excel workbooks in QtiPlot.

Excel workbooks can be embedded into QtiPlot as OLE instances on Windows operating systems where Microsoft Excel is locally available.

When an Excel workbook is created or imported in QtiPlot as an OLE instance, a new menu becomes available in the menu bar of the application. From this menu you can perform various operations with the data in the workbook: you can convert a data selection or entire worksheets to QtiPlot tables or export data to ASCII files. You can also convert Excel charts to QtiPlot graph windows or export them as image files.

LibreOffice & OpenOffice

Import data from spreadsheets stored in binary *.ods files.

QtiPlot can import both data and charts from spreadsheets stored in binary *.ods files as well as from flat XML *.fods files. Please watch this video available in our YouTube channel for a quick example.

QtiPlot can export data from worksheets as binary *.ods files if either LibreOffice or Apache OpenOffice are installed on your computer.

Import of LabVIEW TDMS files

The import TDMS file dialog allows easy preview of raw data.

When importing LabVIEW TDMS files QtiPlot opens a dialog that gives the possibility to preview the raw data.

The dialog displays the structure of the TDMS file in a tree widget allowing the selection of the groups and channels to be imported.

It is possible to enable/disable the import of an entire group or of individual channels by checking/unchecking the corresponding box situated on the right side of the selection tree.

The import TDMS file dialog allows easy preview of channel properties.

A double-click on the name of a channel opens an information message box displaing the number of data values in this channel toghether with the list of its properties.

Database Import

SQL database table/view selection with query dialog.

QtiPlot can import SQL databases (MySQL, PostgreSQL or SQLite). It is also possible to perform an SQL query on the database, prior to the import operation.

Database table/view selection dialog on a macOS systems.

QtiPlot can import Microsoft Access databases (.mdb) on all supported operating systems (Windows, Linux and macOS). This example shows the database table/view selection dialog on a macOS system.

Serial port

QtiPlot provides a serial port monitor which makes possible to both read and write data through a serial port.

Using this QtiPlot feature data acquisition from serial port devices like Arduino boards, for example, is straightforward. Please watch this video available in our YouTube channel for a quick example.

The communication with the serial port devices can be fully customized via a user friendly dialog.

Import of Matlab files (*.mat)

When importing Matlab format files (*.mat) QtiPlot opens a user friendly dialog that allows total control over the import process.

The dialog displays the structure of the Matlab file in a tree widget allowing the selection of the variables to be imported. QtiPlot creates a new table for each variable imported from the Matlab file.