Highlighted
Absent Member.. varalakshmi123 Absent Member..
Absent Member..
973 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. 

Labels (1)
0 Likes
4 Replies
Absent Member.. ntt00015 Absent Member..
Absent Member..

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.

0 Likes
Absent Member.. varalakshmi123 Absent Member..
Absent 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

0 Likes
Absent Member.. ntt00015 Absent Member..
Absent Member..

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

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

Add attachment and your flow here.

 

Cheers

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.