How to delete rows in excel

Help
,
1

Hi guys,

I am trying to delete particular rows in the excel sheet but in a simple way because I am getting an error about the index.

May I please ask if I can get some assistance. Thank You.

remove gl accounts
remove gl accounts837×610 44.4 KB

This is the code:

remove rows
remove rows385×564 21.4 KB

And below I have the rows I want deleted that contain numbers 100420,100410 and 100400 under the GL Account column and that have the contain CORE under Object Key column:

gl account table

2

@wendy What is List? I think it Should be rowsToDelete instead of List if the naming of variable is related to the actual data :sweat_smile: Also the error that you get is with the Assign - Remove GL Accounts, Can you Show us the expression used in it, and also tell us why are you doing that?

3

Hi @supermanPunch

I am not sure if these screenshots could help with the requested expression:

logic expression 1
logic expression 1934×536 39.6 KB
logic expression 2
logic expression 2871×748 44.8 KB
logic expression 3
logic expression 3971×755 47.8 KB
logic expression 5
logic expression 5869×836 55.7 KB

5

The intention was to delete the rows that have GL Account numbers (100400,100410 and 100420) and rows that contain the word CORE.

6

To avoid gaps, I usually do this:

  1. read spreadsheet
  2. filter datatable
  3. archive old spreadsheet
  4. create new from filtered table
7

@wendy I actually have to see the whole workflow to understand it better, the variables data, dtDataToBeDeleted are Datatables right ? If so, What is the difference between these Two DT’s.

If possible can you provide the workflow?