
cibien
Novice
Jul 25, 2012, 1:22 AM
Post #2 of 2
(2741 views)
|
Re: [cibien] Help me to modify perl 'excel to xml'
[In reply to]
|
Can't Post
|
|
example: how is now: excel ___________________________________ ---------|pr_family|___pr1___|___pr2___| ___________________________________ item 1 |___1,2__|__value 1_|_value 2_| item 2 |___1,2__|__value 3_|_value 3_| item 3 |___1,2__|__value 5_|_value 4_| convert to XML: item 1 - pr_family: 1 - pr_1: value 1 - pr_2: value 2 - item 1 - pr_family: 2 - pr_1: value 1 - pr_2: value 2 - item 2 - pr_family: 1 - pr_1: value 3 - pr_2: value 3 - item 2 - pr_family: 2 - pr_1: value 3 - pr_2: value 3 - item 3 - pr_family: 1 - pr_1: value 5 - pr_2: value 4 - item 3 - pr_family: 2 - pr_1: value 5 - pr_2: value 4 - _________________________________________________________ how must be result, with split (',') in pr1,pr2: excel ________________________________________________ ---------|_pr_family_|____pr1________|____pr2________| ________________________________________________ item 1 |___1,2____|_value 1,value 5_|____value 2_____| item 2 |___1,2____|_____value 3____|_value 3,value 4_| item 3 |___1,2____|_____value 5____|____value 4_____| convert to XML: item 1 - pr_family: 1 - pr_1: value 1 - pr_2: value 2 - item 1 - pr_family: 2 - pr_1: value 1 - pr_2: value 2 - item 1 - pr_family: 1 - pr_1: value 5 - pr_2: value 2 - item 1 - pr_family: 2 - pr_1: value 5 - pr_2: value 2 - item 2 - pr_family: 1 - pr_1: value 3 - pr_2: value 3 - item 2 - pr_family: 2 - pr_1: value 3 - pr_2: value 3 - item 2 - pr_family: 1 - pr_1: value 3 - pr_2: value 4 - item 2 - pr_family: 2 - pr_1: value 3 - pr_2: value 4 - item 3 - pr_family: 1 - pr_1: value 5 - pr_2: value 4 - item 3 - pr_family: 2 - pr_1: value 5 - pr_2: value 4 - _________________________________________________________
(This post was edited by cibien on Jul 25, 2012, 1:47 AM)
|