I want to convert the contents of sheet1 into a new Excel file. I have tried many methods but failed. Can anyone help me, please?

Help Studio
1

test1.xlsx (14.2 KB)

02
021199×459 42.3 KB

03
031142×464 28 KB

I have attached a file. Please take a look. I want to convert the contents of sheet1 into sheet2. I’m not sure how to do it conveniently in UiPath or with code. Could you please give me some suggestions?

2

Hi @shenyu

Please try this

image

3

@shenyu

  1. Use read range and give the range as D2 or D67 depending on from Where you need to read data
  2. Now you have only those columns which are needed in destination sheet…use write range directly

Cheers