Work book activity doubt

Help
1

how to copy only some particular columns. for example i have to copy column A1,B1 and D1 to another sheet. How to do it?

regards vishal

1 Like
2

column or row A1?

Thanks and Regards,
Parvati

3

oh sorry. corrected it… the columns

4

@vishal.kp

Read the excel and using Filter Datatable remove the unwanted column and write the Datatable in another sheet.

Thanks,
Suresh J

5

Testing_Columns.zip (16.5 KB)

Please refer the workflow
i have stored the data in one datatabel and used filter datatable for moving the data

Thanks
Parvati

1 Like
6

but it dosent help, i cant give only the column name to filter it. It is having some conditons

7

Hi
yah thats possible
–use a excel application scope and pass the file path as input
–use read range activity and get the output with a variable of type datatable named outdt
–use a assign activity like this
finaldt = outdt.DefaultView.ToTable(False,“column A”,“columnB”,“columnD”)

Where finaldt is a variable of type datatable which will be having the columns A,B and D alone in it
–now use a write range activity and pass the variable finaldt as input and mention the sheetname and make sure that ADD HEADERS property is enabled

hope this would help you buddy
Cheers @vishal.kp

1 Like
8

This helped. Thank you. :slight_smile:

9

@vishal.kp
Column name enough for the filter datatable.
Could you elaborate on the condition?

Thanks,
Suresh J

10

copied.xlsx (23.3 KB) filter this to show only name and workdoneinhours

11

@vishal.kp

Filter datatable will not work with duplicate column name,
instead we can rename it with other name using write cell.

Thanks,
Suresh J

12

remove one “workdone in hour” column

1 Like
13

got it. ty

14

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