2.7.55 impOPJ

1 Menu Information
2 Brief Information
3 Command Line Usage
4 X-Function Execution Options
5 Variables
6 Description
- 6.1 Details on Some Dialog Options
7 Examples

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.

Create a new workbook and activate it.
From the Origin main menu, select Data: Import from File: Origin Project(OPJ, ORG, OGW)....
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.
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.
Click the OK button. The files will be imported as: