How to get the excel data in correct format using oo (175 Views)
Reply
Established Member
varalakshmi123
Posts: 2
Registered: ‎01-21-2013
Message 1 of 5 (175 Views)

How to get the excel data in correct format using oo

Hi All,

 

    While adding data to the excel sheet using "Add Excel" operation, we are unable to get the data in correct format.

 

Issue:Whole data is coming in single  cell, need to come in all cells.Please find the attachment for your reference.

 

Please solve the issue.

 

Thanks

Sita. 

Please use plain text.
Trusted Contributor
ntt00015
Posts: 91
Registered: ‎09-18-2011
Message 2 of 5 (155 Views)

Re: How to get the excel data in correct format using oo

Hi,

What is your OO version? Which content pack is applied? Can you give a sample input values for the operation? Be sure adding Column and Row delimiter inputs to the operation and your excel content input.

Best Regards.

Please use plain text.
Established Member
varalakshmi123
Posts: 2
Registered: ‎01-21-2013
Message 3 of 5 (154 Views)

Re: How to get the excel data in correct format using oo

Hi,

 

   My OO version is 9.05 and  content pack 11 is applied.  I have given  rows delimiter as "|" and column delimmiter as ",".

 

 

Thanks in advance

Please use plain text.
Trusted Contributor
ntt00015
Posts: 91
Registered: ‎09-18-2011
Message 4 of 5 (135 Views)

Re: How to get the excel data in correct format using oo

What is your headerData and rowData inputs ? (There is no attachment seen in your first post. )

Sample :

headerData : 1a${yourColumnDelimiter}1b${yourColumnDelimiter}1c${yourColumnDelimiter}1d

rowData : 2a${yourColumnDelimiter}2b${yourColumnDelimiter}2c${yourColumnDelimiter}2d${yourRowDelimiter}3a${yourColumnDelimiter}3b${yourColumnDelimiter}3c${yourColumnDelimiter}3d
Please use plain text.
Advisor
wdomerac
Posts: 20
Registered: ‎02-12-2013
Message 5 of 5 (118 Views)

Re: How to get the excel data in correct format using oo

Add attachment and your flow here.

 

Cheers

 

--
Wojciech Domeracki
wojciech.domeracki@steria.com
ITPA Development Team | gsc.stars.itpa.l3@steria.com
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation