How write in A2:A13 in excel sheet

Help Activities
, , ,
1

When I am extracting the data how to write in A2:A13,values of the cell is name of the sheets.so how to extract it?

2

Hi,
Can’t Understand your issue Exactly.
Could u please Share your .xaml for more Reference.

Regards,
Harivishnu

3

Hi @guptasweb

You can write only in that cells by giving those values in the cell properties in the write range activity

How can you extract ? Means can you elaborate your task

You extract using data scrapping or table extraction

Regards
Sudharsan

1 Like
4

Actually, in the datatable their is one cell ,the data in that cell is the name of the spreadsheet and in the other columns I’m transposing the data from the file

5

@guptasweb can you share us some sample input and output?

Regards
Sudharsan

1 Like
6

this is my input file

image
image893×249 9.16 KB

7

output- file-

image
image751×376 14.2 KB

8

Hi @guptasweb

You can use write range activity and pass the Range “A12”

Regards
Gokul

9

Why range “A12”?

10

@guptasweb

Checkout this video

Regards
Sudharsan

1 Like
11

i have tried this but i m getting error

12

Can you share the error screenshot? @guptasweb

13

image
image733×316 9.93 KB

14

How to write driveline in Plant column From A2:A13 in spreadsheet
image

15

HI @guptasweb

Just Use Write Range activity And Set the Range → “A2”

It will write the data from A2

Regards
Gokul

16

Duplicate Topic : How write in A2:A13 in excel sheet

1 Like
17

image
I am getting this type of output

18

HI @guptasweb

You can Uncheck the Header in the Add Header and try it

image
image886×252 15.7 KB

Regards
Gokul

19

image
After uncheckinh the headers it gave me this output

20

Check out this thread @guptasweb

Regards
Gokul