Skip to main content
Question

Excel

  • 21 August 2024
  • 1 reply
  • 14 views

if you must filter and move data from one excel file with 5000 to 6000 browse to another , how will you do that efficiently in automation anywhere a360

Basically like this (assuming Excel is installed):

  1. Open the file.
  2. Get multiple cells to read the cells to a table. (Make sure you have enough RAM to hold everything in memory.)
  3. Close the file.
  4. Open the new file.
  5. Write the table to the new file.
  6. Save/Close the file.

Any filtering can be done at the table level between steps 3 and 4. There are Data Table actions that will do some filtering, such as removing duplicate rows or sorting. Other types of filtering (value filtering for example) would have to be done in a loop using some counters.

That’s the fewest number of actions and the least amount of window switching (that takes time).


Reply