Problem about --use activity 'Read Range' read excel

excel
activities

#1

I use activity ‘Read Range’ read excel,but my excel have the same colum,I also want to choose the property ‘Add heads’. How can I solve it?

thanks!


#2

for example :there are three column:
column1: A,1,2,3
colunm2:A,1,2,3
column3:B,6,6,6

I want to get the dataTable with: A,1,2,3 and B,6,6,6

thank you very much


#3

@jmy Check attached file

ExlExample.zip (12.1 KB)


#4

sorry
not like this


#5

image
this is the material

I want to use the “read range” output a datable like this:
image


#6

in read range specify the rage eg. B1:D5

Please refer the attachment.Read Excel data.zip (7.7 KB)


#7

@jmy You needs to remove duplicate column?


#8

@jmy I am attaching a workflow that performs the activity specified by you.

RemoveDuplicateCols.zip (9.3 KB)

Please let me know if you have any queries


#9

Hi @nivedita,
I tested your project . But out put is different.

Input excel sheet

image

OutPut…

image

Regards
Balamurugan.S


#10

@balupad14 I tried to replicate your test case but my output is

Please share your excel


#11

HI @nivedita,

This is the excel file : New Microsoft Excel Worksheet.xlsx (7.9 KB)

Regards
Balamruugan


#12

Hi @nivedita,

It is really nice approach. It is nice.

image

Regards
Balamurugan


#13

yes ,
but there isn’t any property to solve this problem


#14

I tried executing my workflow using the specified excel file. My output is


#15

Thank you @balupad14