Excel Read range issue. pls help me

Help
, ,
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
image1425×171 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
image997×186 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: