How to delete first empty row in excel sheet


#1

I have one excel sheet, it contain one empty row in the starting of the excel file, means the first row is empty. i need to delete that row, when i use read range and write range activity with writing form first row the last row in the excel file is getting duplicated. Can anyone help me regarding this.

Thanks and Regards,
Ananthaeswar.


#2

Hi,

Well you can do this a couple ways.

  • If you use Read Range / Write Range you need to clear the sheet first or delete the file so it’s empty. The Read Range is not counting the first empty row, so when you write it, it’s essentially shifting it up.
  • You could also just change the Range in the Write Range so it writes it on the second row, but in this case you wouldn’t actually delete the empty row.
  • To simply use the Delete Row feature of Excel, you can do “Select Range” A1 then use a TypeInto “[k(alt)]hdr” . You will need to use another Write Cell or Write Range to update the file though.

Hope these pointers help you out.

Thanks.


#3

@ClaytonM Hi, I have the same issue and was looking through the forum.

I tried this. I deleted the file and run but still the same.

Do you mean something like this? Coz it’s not working
image


#4

Hi @sangasangasanga
Not exactly. The Select Range activity selects specific cells or range that you want, so you need to put the range of a cell in that range like “A1” for example. After the range is selected, then that is when you use the TypeInto activity with the “k(lalt)hdr” like you have there, which performs a delete row I believe.
(use lalt instead of alt, because alt has been known to get stuck in a down press so lalt or ralt works better)