How to delete excel rows using logics

[Abubakkar (vnrabu)]

Dear Experts,

How can i delete excel column using if conditions
could you help me plz

Thanks in Advance
Abu

[SathishCodes (Sathish Kumar)]

Do you want to remove the row or column? If you want to remove a row, use Filter Data Table and add the condition “ColumnName” = “Value”.

Where,
ColumnName should be the actual header name of that particular column.
Value should be the comparison value. Ex: In your case, it is TodatDate (Quoting the variable you’ve used)

[AnandKumar26 (Anand Kumar)]

Hi @Abubakkar - You can use Insert/Delete columns activity which is available in UiPath under Excel .

Thanks,
AK

[Abubakkar (vnrabu)]

Thanks @SathishCodes

yes, but it’s not performing

for your references

[Abubakkar (vnrabu)]

[gulab (Gulab Kazi)]

Hi,

If you want to remove columns,from filter wizard you should select output columns and click remove option and give the column name you want to eleminate.You can multiple columns by using +.

Hope this help!

[AshwinS2 (Ashwin S)]

Hi @Abubakkar

Do One thing why dont you use

Invoke Method
and use Dt.Columns Target type and target is RemoveAt

Thanks
Ashwin S

[Abubakkar (vnrabu)]

Thanks @AshwinS2

could you help me plz what should I change ?

[Abubakkar (vnrabu)]

Thanks @gulab

[gulab (Gulab Kazi)]

Please attach you xaml file here.

[Abubakkar (vnrabu)]

Main.xaml (39.4 KB)
please find the attached xaml

[Abubakkar (vnrabu)]

countexcel2.xlsx (12.0 KB)
excel input file

[Abubakkar (vnrabu)]

if today’s date (12) and excel column name date (12) is same then i should delete columns with today from end of the month till.

[AshwinS2 (Ashwin S)]

Hi @Abubakkar

Set Target type as null and set target object as Case1.Columns(“Column Name”)
and Method Name is RemoveAt

Thanks
Ashwin S

[Abubakkar (vnrabu)]

should i mention this Case1.Columns(“col_index”)

[AshwinS2 (Ashwin S)]

Hi @Abubakkar

Check this

Delete column of the sheet

@James90, Please find the attached file for your reference. Main.xaml (11.0 KB)

Thanks
Ashwin S

[AnandKumar26 (Anand Kumar)]

@Abubakkar

if today’s date (12) and excel column name date (12) is same then i should delete columns with today from end of the month till.

Hi @Abubakkar - Please see the attached workflow file, this gets the date and deletes the column of that particular date.

Main (3).xaml (9.2 KB)

Thanks,
AK

[Abubakkar (vnrabu)]

Thanks @AnandKumar26

But, it’s deleting only today date column only …
i want to delete today from end of the month till
is it possible?

what should i mension here?

[AnandKumar26 (Anand Kumar)]

Hi @Abubakkar - It requires simple logic. That can be done. Not an issue. Will finish it and share it with you.

Thanks,
AK

[AnandKumar26 (Anand Kumar)]

Main (3).xaml (13.5 KB)

Hi @Abubakkar - Please see the attached workflow.

Thanks,
AK