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 Comments from and to
 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
1006 Posts

Posted - 05/27/2022 :  06:22:05 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!

How does the following settings work in impMSExcel?
My source Excel file has multiple lines I want to add to comments, but if I specify the from-to range I get duplicates in Comments after import.



Thank you.

---
Andrey

snowli

USA
1081 Posts

Posted - 05/27/2022 :  10:14:22 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I couldn't reproduce this either.
I made an excel file with 1st 3 rows as main headers.
4th to 9th rows with subheaders.
Then import them with same setting as users.

Comment only shows the contents from row 4 to 5.

Thanks, Snow
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 05/27/2022 :  10:37:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

I couldn't reproduce this either.
I made an excel file with 1st 3 rows as main headers.
4th to 9th rows with subheaders.
Then import them with same setting as users.

Comment only shows the contents from row 4 to 5.

Thanks, Snow



Dear Snow,

How do Header and Sub-Headers work in the case of impMSExcel?
Can you share your Excel worksheet, please?

---
Andrey
Go to Top of Page

snowli

USA
1081 Posts

Posted - 05/27/2022 :  10:50:46 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
See this file

https://my.originlab.com/ftp/forum_and_kbase/Images/mainheader3_subheader3_7columns.xlsx

Thanks, Snow
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 05/27/2022 :  11:13:30 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

See this file

https://my.originlab.com/ftp/forum_and_kbase/Images/mainheader3_subheader3_7columns.xlsx

Thanks, Snow



Dear Snow,

What does origin do with Header lines: skip it all or takes info to somewhere?

Please try importing the following modified file: https://my.originlab.com/ftp/forum_and_kbase/Images/mainheader3_subheader3_7columns_AK.xlsx

By the way, how do I set a separator for multi-line comments from import?

---
Andrey
Go to Top of Page

snowli

USA
1081 Posts

Posted - 05/27/2022 :  12:19:21 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

Is it mainly because u can't edit data if using data connector?

See https://www.originlab.com/doc/en/Origin-Help/Data-Connector
U can set @IPDC=0 so data isn't protected and u can edit on it.

Then try your data with data connector since we made some improvements in excel connector.
Check if the issues exists with data connector.

Regarding to separator in multi-line comments, could u give an example?

With your xlsx, i saw there are merged cells vertically in subheader area.
I set main header to 3.
subheader to 3.
Set comments to be 1 to 1
long name to 2
unit to 3

i can import them.

Thanks, Snow




Thanks, Snow
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 05/27/2022 :  1:17:13 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Hi Andrey,

Is it mainly because u can't edit data if using data connector?

See https://www.originlab.com/doc/en/Origin-Help/Data-Connector
U can set @IPDC=0 so data isn't protected and u can edit on it.

Then try your data with data connector since we made some improvements in excel connector.
Check if the issues exists with data connector.

Regarding to separator in multi-line comments, could u give an example?

With your xlsx, i saw there are merged cells vertically in subheader area.
I set main header to 3.
subheader to 3.
Set comments to be 1 to 1
long name to 2
unit to 3

i can import them.

Thanks, Snow



You are right.
However my data file has 3 lines of header and 5 lines of subheader (lines 1-3 to Comments, line 4 to Long Name and line 3 to Units).
Please try to import another example:
https://my.originlab.com/ftp/forum_and_kbase/Images/mainheader3_subheader3_7columns_AK_AK.xlsx

Set Header to 3, Subheader to 5, Long Name to 4, Units to 5, Comments From to 1, Comments To to 3.

Notice that content of vertically merged cells repeats in the import results.

---
Andrey
Go to Top of Page

snowli

USA
1081 Posts

Posted - 05/27/2022 :  2:12:05 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
https://my.originlab.com/beta/forum/topic.asp?TOPIC_ID=13466

this user requested merged cells put same value.

U also have t2, t5 merged in excel.

What would u expect them to show?


Thanks, Snow
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 05/27/2022 :  2:35:08 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

https://my.originlab.com/beta/forum/topic.asp?TOPIC_ID=13466

this user requested merged cells put same value.

U also have t2, t5 merged in excel.

What would u expect them to show?
Thanks, Snow



Hm...
I would like to have an option to remove the duplicates in case of merged cells (at least vertically.
Technically Excel when merging cell puts the value in the most top left cell of the merged range. Thus, it is logical to have just this single value.
Does it make sense?

What does origin do with Header lines: skip it all or takes info to somewhere?

By the way, how do I set a separator for multi-line comments from import?

---
Andrey
Go to Top of Page

snowli

USA
1081 Posts

Posted - 05/27/2022 :  2:50:18 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I jiraed your request not to unmerge the merged cells.

Since we have two types of users, we will add a system variable for this and CP thinks the default should be looking the same as Excel as you asked.
ORG-25113 S2

Right now when using ImpMSExcel, main header is no where to be seen.
This could be one reason to encourage you to use Data connector since data connector will put main header in a File Header row.

I don't understand "By the way, how do I set a separator for multi-line comments from import?" We don't have this option for sure.



Thanks, Snow



Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 05/27/2022 :  3:01:51 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

I don't understand "By the way, how do I set a separator for multi-line comments from import?" We don't have this option for sure.

Thanks, Snow



I ask about an additional option to specify separator (comma, semicolon, newline) to separate comments gathered from multiple lines. Currently the separator is space, which is not always a good solution. Since the comments themselves may contain white spaces it is almost impossible to separate using Search & Replace.

Another question is about User Parameters and System Parameters import: where do the go after import?

---
Andrey
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 05/27/2022 :  3:04:30 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli
Since we have two types of users, we will add a system variable for this and CP thinks the default should be looking the same as Excel as you asked.
ORG-25113 S2



I support the idea.
Alternative option is removing duplicate values came from multiple lines of the merged cells.

---
Andrey
Go to Top of Page

snowli

USA
1081 Posts

Posted - 05/27/2022 :  3:28:19 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I haven't heard of users using system parameters.
It seems weird that we don't show it after import but again, we are not fixing impMSExcel. U can set user parameter or system parameter rows after import. Then sheet will keep them when reimporting.

U can right click any column label row and choose "Edit Column Label Rows..." to check Parameter, Parameter 2, 3, ..... to make system parameters show.

Or left click any column label row header and choose the Properties button on mini toolbar to open Properties dialog.
On View tab, click Edit Column Label Rows...


Thanks, Snow



Go to Top of Page

snowli

USA
1081 Posts

Posted - 05/27/2022 :  4:25:25 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I don't think we use space as separator for multi-line comments.
E.g.


The excel has 3 main header, 3 subheader. The 1st row of subheader actually is multi-line.

When i import into Origin, i can specify accordingly.

Sorry that if i misunderstood your comment about this. Please use an example to let me know what the data is like and what u want it to be imported.

Thanks, Snow


Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 05/28/2022 :  01:24:18 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

I don't think we use space as separator for multi-line comments.

The excel has 3 main header, 3 subheader. The 1st row of subheader actually is multi-line.

When i import into Origin, i can specify accordingly.

Sorry that if i misunderstood your comment about this. Please use an example to let me know what the data is like and what u want it to be imported.

Thanks, Snow




By multi-line comments I mean comments that span across several rows in the source worksheet.
Please see the following multi-line comment example, reproducing my target table:
https://my.originlab.com/ftp/forum_and_kbase/Images/mainheader3_subheader3_7columns_AK_AK_AK.xlsx

Compare the contents of Merged and Unmerged sheets.

If comments are multiple lines in a single cell, then currently their import works correctly:


Currently I don't like repeats in the Comment in column A.
It would be great if import routine will remove these repeats.

Another question is about User Parameters and System Parameters import: where do the go after import?

---
Andrey
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 06/25/2022 :  05:00:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Can you share an update on the topic, please?

---
Andrey
Go to Top of Page

Cecilia_syy

46 Posts

Posted - 06/28/2022 :  05:53:58 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,
No parameter and user parameter with impMSExcel is bug, I added ORG-25438, we will fix it.

Thanks
Cecilia
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 06/28/2022 :  08:50:05 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by Cecilia_syy

Hi Andrey,
No parameter and user parameter with impMSExcel is bug, I added ORG-25438, we will fix it.

Thanks
Cecilia



Dear Cecilia,

Thank you.
What about removing/disabling repeats after duplicate import?

---
Andrey
Go to Top of Page

Cecilia_syy

46 Posts

Posted - 06/29/2022 :  01:15:53 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,
About removing duplicate import, developer is working on it.

Thanks
Cecilia
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 07/09/2022 :  04:11:24 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
OriginPro 2023 (64-bit) Beta 1 10.0.0.47 doesn't feature the improvement.

---
Andrey
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 08/14/2022 :  08:41:16 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
OriginPro 2023 (64-bit) Beta 4 10.0.0.83 doesn't feature the improvement.

---
Andrey
Go to Top of Page

AKazak

Russia
1006 Posts

Posted - 08/14/2022 :  11:30:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I attached two sample spreadsheets for testing purposes:
https://my.originlab.com/ftp/forum_and_kbase/Images/Merged%20Column%20Headers.xlsx
https://my.originlab.com/ftp/forum_and_kbase/Images/mainheader3_subheader3_7columns_AK_AK_AK_AK.xlsx

---
Andrey
Go to Top of Page

Cecilia_syy

46 Posts

Posted - 08/14/2022 :  11:06:07 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,
I tried beta4 with your samples, both duplicated comment issue and no system parameter and user parameter issue are fixed. Do you mean this is not work as expected?

Thanks
Cecilia
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