Excel Read range issue. pls help me

excel
activities
studio
#1

hi everybody

I have an error when using Read range activity. If input specified range is ok, can get Headers.
But if input dynamic range Exam (“A” + range.toString) I cannot get Headers though I chose Add Headers It automatically creates new headers that are not headers in the first row.

EX:
STT Name Age
1 Test1 20
2 Test2 20

If using dynamic variable

Col1 Col2 Col3
STT Name Age
1 Test1 20
2 Test2 20

I want the heades is STT Name Age

Do you have any such errors? please help me. Many thanks!

#2

@duynd9 In the read range property check add headers

#3

thank you for a reply. I checked but I chose Add Headers It automatically creates new headers that are not headers in the first row.

#4

Intialize range value to 0 or 1 and see

#5

Using String.Format(“A{0}”,variable.ToString)
this is the same: String.Concat(“A”, variable.ToString)
but can’t get headers, It automatically creates new headers

#6

can you attach your workflow and excel file

#7

demoGetReport.zip (15.7 KB)
thank you so much

#8

can you explain what exactly you need from your xaml file

#9

I need to get data from A35 with headers but data from A5 is dynamic data it, not just 20 row or 25 row. so I need the dynamic range with data from A35 or A37…with headers. Because of I need use Select activity. But if use dynamic range cannot get Data with headers in row A35 It automatically creates new headers. Sorry, my English so bad !

#10

Is a bug of UIpath. so sad :frowning:

#11

Hi @duynd9,

I think. It is not a bug in the activity. To get data you have to use the Read Cell activity to specify in the property Cell.

Regards
Balamurugan.S

#12

hi @balupad14
Thanks for a reply.
I tried it, but I want to use headers to select.
Read Cell activity cant set the first row into headers. so sad :frowning:

#13

Hi @duynd9,

I am not able to understand your situation. Can you please share your xaml to see?

Regards
Balamurugan.S

#14

is here. Sorry it is my problem please excuse me for disturbing you. thanks you

Regards

#15

Hi @duynd9,
You want the total of TransCount,debit,credit and payment ? is it…

Regards
Balamurugan.S

#16

Hi @duynd9,

Always you will have only 2 rows gap between the 2 datas

image
image.png1425x171 10.2 KB

Regards
Balamurugan

#17

Hi @balupad14

No. I want data from A35 with headers but if use dynamics range with a variable cant add the firt row into headers.

Thank you.

#18

Hi @balupad14

You can run demo. So i think you will understand my mean.

Regards

#19

Hi @duynd9,

Is this ur expected result ?

image
image.png997x186 5.12 KB

Regards
Balamurugan.S

#20

Yes. Firt row cant set into headers. So i cant use select method in Datatable.
I need to filter and process data before writing to the excel. :frowning: