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
 Origin Forum
 impMSExcel: import from template renames wks		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1205 Posts
Posted - 06/02/2022 :  06:07:13 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64

Greetings!

I use impMSExcel to import using a template with multiple sheets: 1st is data sheet and the others are linear and non-linear fit reports.
I noticed that after import impMSExcel replaces the original sheet names present in the template to Sheet1, Sheet2, etc.

Is there a way to change the behavior and keep the template's original sheet names?

Thank you.

---
Andrey

snowli

USA
1411 Posts
Posted - 07/06/2022 :  10:37:30 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Sorry that we missed this.

For most import tools, there is an
Import Options -> Rename Sheets and Books node.

Could you check if setting "Rename Sheet with" to "None" works.


Thanks, Snow
Go to Top of Page

AKazak

Russia
1205 Posts
Posted - 07/07/2022 :  05:51:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Sorry that we missed this.

For most import tools, there is an
Import Options -> Rename Sheets and Books node.

Could you check if setting "Rename Sheet with" to "None" works.

Thanks, Snow


Setting "Rename Sheet with" to "None" does not work in impMSExcel OriginPro 2022b (64-bit) SR1 9.9.5.167.

---
Andrey
Go to Top of Page

snowli

USA
1411 Posts
Posted - 07/07/2022 :  09:28:59 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Could you share your template?

Thanks, Snow
Go to Top of Page

AKazak

Russia
1205 Posts
Posted - 07/08/2022 :  01:52:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Could you share your template?

Thanks, Snow


Dear Snow,

It seems to be working now.
I will keep an eye on this and report if I manage to reproduce the issue.

---
Andrey
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