How to get the excel data in correct format using oo (455 Views)
Reply
Established Member
Posts: 2
Registered: ‎01-21-2013
Message 1 of 5 (455 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
Posts: 91
Registered: ‎09-18-2011
Message 2 of 5 (435 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
Posts: 2
Registered: ‎01-21-2013
Message 3 of 5 (434 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
Posts: 91
Registered: ‎09-18-2011
Message 4 of 5 (415 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
Frequent Advisor
Posts: 45
Registered: ‎02-12-2013
Message 5 of 5 (398 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.