Need to copy the whole column value

Help Activities
, ,
1

Hi everyone,

I need to copy Column B & Column F or need to delete all the columns except the Column B & Column F from the excel.

Note: Copy/Paste range is taking more time.

Sample.xlsx (8.9 KB)

Could you help me to solve this?
Regards
Gokul

2

@lakshman @Palaniyappan @NIVED_NAMBIAR @postwick @prasath_S @ppr

Can anybody help?

1 Like
3

@Gokul001

Try below steps.

  1. First use Read Range activity to read the entire file and it will give output as DataTable. Let’s say ‘InputDT’.

  2. And then use multiple Delete Range activities to delete the data and pass Range as below.

    "A2:A"+(InputDT.Rows.Count+1).ToString
"C2:E"+(InputDT.Rows.Count+1).ToString
 "G2:Z"+(InputDT.Rows.Count+1).ToString

Note: Replace Z with end column.

1 Like
4

Hi @lakshman

  • I attached only the sample xlsx file.
  • There are more columns in excel, so I want to delete all the columns after Column F.

Regards
Gokul

5

Hi

Did we try with custom component on this scenario

Cheers @Gokul001

2 Likes
6

@Gokul001

You can also try with Filter Datatable

Use Read range to read excel into Datatable

Later use Filter Datatable and in the outputColumns keep and use only required column names

image
image915×633 65.7 KB

This will remove remaining columns

Hope this may help you

Thanks

1 Like
7

Hi @Palaniyappan

I will look into it

1 Like
8

Hi @Srini84

I had tried to use Filter DataTable, but No Luck

Regards
Gokul

9

@Gokul001

Can you check what column names you are getting using output Datatable activity?

and use those column Names

Hope this may help you

Thanks

10

Hi @Srini84

Could you refer to the sample xlsx file?

Regards
Gokul

11

@Gokul001

Sorry I thought till F only. Take one more Delete Range activity and pass range as “G2”.

12

@lakshman

I will check it and come back

13

Sure @Gokul001

14

Hi @lakshman

Using “G2” is not working.

Regards
Gokul

15

@Gokul001

Do you know end column ? If yes then specify as below.

        "G2:Z"+(InputDT.Rows.Count+1).ToString

Note: Replace Z with end column.

1 Like
16

Hi,

Can you try to use DeleteRange and Insert/Delete Columns as the following?

img20211011-2
img20211011-2827×969 25 KB

Range property of DeleteRange will be

"G1:"+Uipath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(dt.Columns.Count)+dt.Rows.Count.ToString

Change mode of Insert/Delete activity should be Remove.

Regards,

3 Likes
17

Hi @Gokul001

Try this approach

  1. Read the excel and store in dt1

  2. Then use

dt2= dt1.DefaultView.ToTable(False,{“Column B”,“ColumnF”})

  1. Then write dt2 in another sheet

Hope this helps you

Regards

Nived N :robot:

2 Likes
18

Dear Gokul,

You can look into the attached xaml for your requirement.
The xaml copies Column B and F and writes it into sheet2

ForumDivisionQuery.xaml (7.2 KB)

Thanks,
Geetishree Rao

1 Like
19

Thank You @Yoichi @Palaniyappan @geetishree.rao @NIVED_NAMBIAR @Srini84
@lakshman It’s Working for me.

Happy automation
Regards
Gokul

2 Likes
20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.