2.17 FAQ-427 How to bring in data from another Origin project?

Last Update: 1/28/2019

There are several ways to combine data from separate Origin files.

Copying and Pasting Folder Across Origin

Right-click on a Project Explorer folder and choose Copy from context menu. Go to another Origin session, right click on a folder and choose Paste from the context menu. The whole folder including windows inside will be added as a subfolder.

Copy Folder Across Origin.gif

Importing Data from another Project or Worksheet Window

This allows import of selected columns of worksheet data from another project.

  1. With a workbook active, choose File: Import: Origin Project (OPJ)... to import selected columns from your OPJ file.
  2. Select a particular book in the OPJ file and all sheets are listed. If you then select a particular sheet, you get a list of columns from which to select.

This feature uses the X-Function impOPJ. For help with the impOPJ dialog box, see Importing an Origin Project.

Append All Data in Another Project

This option doesn't allow you to selectively bring in data. Rather, you will append the entire contents of another OPJ file, to the current (open) OPJ file.

  1. Choose File: Append or right-click on a Project Explorer folder and choose Append Project. A Reminder Message prompts you to create a folder for the appended file or append the file to the current folder. In either case, the subfolder structure of the appended file is preserved.

Opening an Origin Window File

This is a way to bring saved worksheet (OGW) or graph windows (OGG) into the current OPJ file.

  1. Choose File: Open (or File: Recent Books or Recent Graphs) and browse to your Origin Window file. You can also drag and drop window files.

Note that when you open a graph window file in this way, you bring in supporting data, as well. Right-click on your data plot and choose Create worksheet worksheetName; or double-click on the plot and at the bottom of Plot Details, click the Workbook button.

See FAQ-651 How do I merge two graphs that reside in separate Origin projects onto one graph window?



Keywords:Origin OPJ, import data, Window Files, Append, Project Explorer,