Interoperability with other scientific software

QtiPlot can import and export data from and to several scientific programs: OriginLab, Excel and other major office suites like LibreOffice and Apache OpenOffice. It can also import Matlab files, LabVIEW TDMS files, dBase, MySQL, SQLite and Microsoft Access databases. Last but not least easy integration with LaTeX typesetting system is also available.

OriginLab

Import of OriginLab projects

QtiPlot can import *.opj project files created with OriginLab versions ranging from 4.1 to 9.3 (Origin 2016). QtiPlot can also import individual workbooks (*.ogw files), matrices (*.ogg files) and graphs (*.ogg files). Since not all of OriginLab features are available in QtiPlot sometimes the formating of the data tables or of the plot windows might look different from the original projects.

Export QtiPlot projects to OriginLab

Starting with version 0.9.9.1 QtiPlot can also export individual project windows, projects folders or entire projects as Origin C files that can be compiled and executed by OriginLab. Again, since not all of OriginLab features are available in QtiPlot the data tables and especially the plot windows might look different when opened into OriginLab.

Saving QtiPlot projects to Origin C files is straightforward: open the File menu, select the Save Window as... or Save Project as... command and choose the file type Origin project (*.c) from the file dialog.

If you export projects containing 2D graph windows that display images or LaTeX equations QtiPlot will save all these images into a folder with the -images suffix appended to the base name of the exported Origin C file. Therefore if you send the .c file to someone else don't forget to also attach this folder.

Figure 1-11. Export QtiPlot windows/projects as Origin C files

There are a few preparatory steps that should be undertaken into OriginLab in order to easily open the C files generated by QtiPlot. First of all you should create a new menu using the OriginLab Custom Menu Organizer wizard from the Tools menu:

Figure 1-12. OriginLab - Create new custom menu

In the Custom Menu Organizerdialog you need to right click into the left panel in order to add a new menu, that was renamed to CustomImportin the example screenshot bellow:

Figure 1-13. OriginLab - New custom menu

Next you need to right click on this new menu and from the popup menu select the option Add Item:

Figure 1-14. OriginLab - New custom menu item

Once the menu item is created you need to select it with the mouse. A new dialog page appears and you can customize it like in the following screenshot, where we changed the default name to Open QtiPlotand added a Status Bar Text:

Figure 1-15. OriginLab - Import script

In the LabTalk Script editor you must copy/paste the following code lines:


run.LoadOC(Originlab\\image_utils.c);
getfile *.c;
if (run.LoadOC(%A) == 0) importQtiPlot;

Once this is done click the Close button of the dialog and press the Yes button when asked to save the changes.

In order to be successfully compiled by OriginLab the C files generated by QtiPlot must be copied into the OriginC folder of your OriginLab installation directory, like shown in the screenshot bellow:

Figure 1-16. OriginLab - Select C file generated by QtiPlot

After the compilation process OriginLab will create a new folder having the base name of the imported C file.

Microsoft Excel

Import of Excel files

QtiPlot can import data from spreadsheets stored in binary *.xls, *xlsx files as well as from *.xml Microsoft Excel files, using different methods. For more details see the Open Excel command.

On Windows operating systems, if Microsoft Excel is installed on your computer, QtiPlot can also import the charts from Excel files or even embed Excel workbooks (New Excel command).

Export QtiPlot data to Excel

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

LibreOffice and Apache OpenOffice

Import

QtiPlot can import data from spreadsheets stored in binary *.ods files as well as from flat XML *.fods files (see Open ODF Spreadsheet command).

Export

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