Skip to main content
A
Abisha Gopalan
Cadet | Tier 2
December 4, 2025
Solved

Deleting the rows from excel

  • December 4, 2025
  • 11 replies
  • 326 views

Hi,

 

Is there any easy way to delete the excel rows based on certain condition.

currently i m following the method of filtering the excel rows by lopping and check the if condition is yes then adding to list and again looping the list to delete row by row. though this case works correctly i still don't find it effective as it takes a lot of time. since our excel very huge it take 5 to 10min to delete this data

    Best answer by Padmakumar

    Hi ​@Abisha Gopalan,

     

    Sorry, my previous comment got removed due to some unknown reason. Considering the amount of data you need to handle, I would recommend 3 options here.

     

    1. Connect to your Excel as DB and remove the required rows based on your criteria using the Delete query.
    2. Convert your Excel data into a Data Table and use the Data Table package to handle the filtering and removal part.

              (Both of these are much faster than the typical Excel operations through AA.)

    1. Use any inline scripts like VB or Python to handle your filtering & deletion part.

    11 replies

    Show previous replies
    Aaron.Gleason
    Automation Anywhere Team
    Aaron.Gleason
    Automation Anywhere Team
    December 9, 2025

    To be frank, I haven't even seen an Excel file more than 10 MB in size in my life. However, since the ask was to work with a larger data set (the actual size is unknown), I was giving a heads-up.

    ​@Padmakumar Okay, the docs say the max is 30GB, but I created a 100MB XLSX file and Excel Basic opened the file! Just make sure you have enough RAM as opening that file caused a big RAM usage spike.

    This is exactly why databases are a better choice for large datasets. They’re designed for this! Excel is not.

    By the way, you can also open an Excel file in Access. That links to the original Excel file and doesn’t use as much RAM. You can then save the Access database and use standard Database package commands to query and manipulate the data. Much easier than the XLSX > JET > ODBC bridge of trying to use Excel as a database.

    Terms & ConditionsAccessibility statement