How to get the excel data in correct format using oo (373 Views)
Reply
Established Member
varalakshmi123
Posts: 2
Registered: ‎01-21-2013
Message 1 of 5 (373 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. 

Trusted Contributor
ntt00015
Posts: 91
Registered: ‎09-18-2011
Message 2 of 5 (353 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.

Established Member
varalakshmi123
Posts: 2
Registered: ‎01-21-2013
Message 3 of 5 (352 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

Trusted Contributor
ntt00015
Posts: 91
Registered: ‎09-18-2011
Message 4 of 5 (333 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
Advisor
wdomerac
Posts: 31
Registered: ‎02-12-2013
Message 5 of 5 (316 Views)

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

Add attachment and your flow here.

 

Cheers

 

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.