I want to delete columns in Excel starting from F

Help Activities
, , , ,
1

Hi everyone,

I have a scenario in Excel, i want to delete columns in Excel starting from F column and i don’t know how many columns will be . I want to delete columns starting from F to till end.

Can anyone help me how can I do this.

I want solution except Macro and VBA code.

2

@Learner007

you can use Read range activity by mentioning the range

image

cheers

3

Hey @Learner007 ,

Yourdatatablename = Yourdatatablename.DefaultView.ToTable(False,"columnnameA", "columnnameB", "columnnameC","columnnameD","columnnameE").copytodatatable()

Replace those with Your column name till e
And it will not write other than mentioned columns

Hope it helps you out!

4

Hi @Shiva_Nikhil if I want to use delete range means i need end column but I don’t know how many columns i will be getting in that excel

5

Hi @Vikas_M I’m getting error like copytodatatable is not a member of datatable

Actually I can’t specify the column names because in between few columns are empty how to handle that

6

@Learner007

try to make use of readrange activity and make the range upto which you want

7

hey @Learner007 , My bad
copytoDatatable was not required

image
image1894×461 20.1 KB

This above works

Also if you don’t want to specify column names, then while reading from excel specify the range
Refer below image
image

8

Thanks @Vikas_M it worked. Read range only.

1 Like
9

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