Operations Orchestration Practitioners Forum
cancel

How to get the excel data in correct format using oo

Highlighted
varalakshmi123
New Member.

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. 

4 REPLIES
ntt00015
Honored Contributor.

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.

varalakshmi123
New Member.

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

ntt00015
Honored Contributor.

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
wdomerac
Super Contributor.

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

Add attachment and your flow here.

 

Cheers