The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 import worksheets from another opj project
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

k_fadz

France
11 Posts

Posted - 11/14/2017 :  07:17:25 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello

I want to import 3 worksheets (wks1 wks 2 and wks3, part of book1) and put them in [book3] (in my current project) from a different opj project.

I am actually using this :


dlgfile group:=*.* multi:=1;

impOPJ info.wkspage:=Book1 info.wks:=Sheet1 info.cols:={0:104} orng:=[Book3]sheet1;
impOPJ info.wkspage:=Book1 info.wks:=Sheet2 info.cols:={0,2} orng:=[Book3]sheet2;
impOPJ info.wkspage:=Book1 info.wks:=Sheet3 info.cols:={0:104} orng:=[Book3]sheet3;


It takes a lot of time. And doesn't work every time.

Is there any other solution ? Thank you in advance

K.F

yuki_wu

896 Posts

Posted - 11/15/2017 :  12:43:18 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi K.F,

I think you could try to append the workbook that you want to import to the current project, and then copy the sheet to the new workbook. It may take less time.

doc -afa could use to append the contents of a folder to the current folder:
https://www.originlab.com/doc/LabTalk/ref/Document-cmd#-afa_projectName_.5BfolderName.5D.3B_Append_the_contents_of_a_folder_to_the_current_folder

Regards,
Yuki
OriginLab
Go to Top of Page

n/a

6 Posts

Posted - 12/14/2017 :  10:11:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
A worksheet is a sheet of paper with questions for students and places to record answers. A worksheet may also be an informal piece of paper that an accountant uses to record information, or a single array of data in spreadsheet software.

:)
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000