Filter Data Table and get only specific columns data

Help Studio
, ,
1

Hi , I have a scenario where There is a excel file with many columns for Ex: ColumnA to ColumnCD
In that I want to filter on one column lets say column D,
and get the filtered data from Excel (Only specific columns data Ex: Column A, ColumnD, ColumnR Etc)
and I need to paste this range of data to a word file…

Please help me on this

2

one of many options:

  • filter DataTable Activity - output: dtFiltered

  • Assign Activity:
    arrCols | DataType: String Array =
    new String(){“ColumnA”,“ColumnD”,“ColumnR”}

  • Assign Activity:
    dtSmall = dtFiltered.DefaultView.ToTable(false, arrCols )

3

Hi @MEGHA_cs

Use filter DataTable activity, apply filter on column D, in Output Rows section.

In output Columns, keep only Column A, Column D, Column R.

4

Thanks @adiijaiin ,

How to paste this data range into word document?

5

Hi @MEGHA_cs

You can install UiPath.Word.Activities:
in there you will find an activity to insert DataTable:
image

Thanks,
Happy Automation

6

Thanks @adiijaiin ,

If I want to copy the same range in PDF?

7

You Can use the Save Doucment as PDF activity.
image

8

Put a filter in the excel itself and use preserve format to read filtered values and then insert datatable in word should do the trick

9

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