How to make the entire column in an excel with empty values

[Shivaraju (UipathLearner)]

Hi all,

Can anyone please explain how to make the entire column empty in an excel.

[Palaniyappan (Forum Leader)]

Buddy @Shivaraju
here is your xaml buddy

emptycol.zip (13.7 KB)

hope this would help you buddy
Cheers @Shivaraju

[Shivaraju (UipathLearner)]

Hi @Palaniyappan
Unable to open the xaml fil e.

[Palaniyappan (Forum Leader)]

Here you go buddy steps involved
1
2.

3.

4.

thats all buddy @Shivaraju
Cheers

[Spark_robot (Arun)]

Hi, pleaseTo_empty_entire_column.xaml (8.8 KB)
find the attachment.

[Shivaraju (UipathLearner)]

Thank you @Palaniyappan & @Spark_robot
Will check and update the result.

[Palaniyappan (Forum Leader)]

did that work buddy @Shivaraju

[Shivaraju (UipathLearner)]

no buddy @Palaniyappan & @Spark_robot
I didn’t get what I want actually to get.Emptycolumn.xlsx (85.7 KB)
I want to remove all the values present in Column"D"(Unwanted) without affecting any other columns.

[Spark_robot (Arun)]

In my script change row(0) to row(3) it may work i think so.

[Palaniyappan (Forum Leader)]

Here is your xaml buddy @Shivaraju
BlankProcess3.zip (71.2 KB)

Kindly try this and let know buddy
Cheers

[Palaniyappan (Forum Leader)]

did that work buddy @Shivaraju
Cheers

[Shivaraju (UipathLearner)]

Checking bro @Palaniyappan
Please wait for 5mins

[Shivaraju (UipathLearner)]

Thank you very much buddy @Palaniyappan and @Spark_robot for the support.

[Palaniyappan (Forum Leader)]

Fantastic
Cheers @Shivaraju
Keep going