2.7.55 impOPJ


Menu Information

Data: Import from File: Origin Project(OPJ, ORG, OGW)...

Brief Information

Import column(s) from Origin project file.

Command Line Usage

1. impOPJ fname:=D:\ImpOPJ.opj info.wkspage:=Book1 info.wks:=Sheet1 orng:=[Book1]Sheet1; //Import the first column in the sheet1 of book1

2. impOPJ fname:=D:\Book1.ogw info.wkspage:=Book2 info.wks:=Sheet1 info.cols:={0, 1} orng:=[Book1]Sheet1; //Import the column1 and column2 in the sheet1 of book2

3. #impOPJ fname:=D:\Alkanes.opj info.wkspage:=Book1 info.wks:=Sheet2 options.include.units:=0 options.include.comments:=0 orng:=[Book1]Sheet1; //Import the first column in the sheet2 of book1 excluding the Units and the Comments

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
OPJ File Name fname

Input

string

fname$
Filename (s) of the OPJ file (s) to be imported.
File Info and Data Selection info

TreeNode

<unassigned>
File Info and Data Selection
Import Options options

TreeNode

<unassigned>
This is mainly used in the dialog, for tweaking the import options. Please see the Descriptions section for details.
Output orng

Input

Range

<active>
This is used to specify the output range.

See the syntax here.

Repeat Import reimp

Input

int

1
Repeat Import

Description

This function will import the column(s) in Origin Project file by setting the options in the dialog. It can be accessed from menu or command window.

  • Menu: Select Data: Import from File: Origin Project(OPJ, ORG, OGW)....
  • Command window: type impopj -d in command window.

Details on Some Dialog Options

  • Import Options(options)
Please see this page for more details.

Examples

This example will show you how to import the specified columns in a Origin Project file.

  1. Create a new workbook and activate it.
  2. From the Origin main menu, select Data: Import from File: Origin Project(OPJ, ORG, OGW)....
  3. In the OriginImport dialog, choose Workbooks(*.ogw) as file type, and browse to \Samples\Graphing\BoxChartExample.ogw. Make sure to check the Show Options Dialog checkbox and click the Open button to open the impOPJ dialog.
  4. In the impOPJ dialog, select B:Jan, C:Mar and D:Apr in the Column list under File Info and Data Selection section. Then click the User-Defined Labels checkbox under the Import Options section.
    ImpOPJ 01.png
  5. Click the OK button. The files will be imported as:
    ImpOPJ 02.png