Deleting rows and sorting in Excel with StudioX

[bert.vandermade]

I want to delete several rows (five) in an excel sheet and sort the the dates in a column, which steps I have to take?

Could you please add screen shots from the activaties?

THX!

[oriolsolani (Oriol)]

Hi @bert.vandermade, have you taken a look at this post? There is a response, marked as solution, which shows how to delete rows with Studio X, screenshot included.

Delete rows from spreadsheet using StudioX

Hi, I have an excel file where the headers start from row #10 of the file. It has 8 column headers at row #10. Out of the first 9 rows, 2 rows are merged and has some title like text data describing the file purpose. The rest 7 rows are just empty rows (not merged). I need to delete all the 9 rows using StudioX so that the header comes to row #1 from row #10 that presently it is at. I’m reading the Excel rows using For each row and then adding a condition 'Currentrow" column 1 is empty, then del…

To sort, there is an action called “Sort Range”. Add this inside a “Use Excel” resource and specify what range you want to sort. Afterwards, you can set the column to sort and the direction.