Excel row deletion

[Champak]

Is there a simple function that will delete excess rows from an excel file?

[water]

Please define “excess rows“. 

[Champak]

I really don't know how to define it. I have a web application that imports a list. If I don't right click and delete all rows after the last product I get an error on importing. I suspect they are "empty ACTIVE rows"...I guess that's how I'd define "excess rows".

[Andreik]

In Excel you don't really delete rows but data in a specific range. For this you can use _Excel_RangeDelete() but no matter how many rows you delete a worksheet will always have the same number of rows and columns.

[Champak]

I get technically the rows are "never ending". The point is to delete everything that select all would get. That's what I have to do to prevent the error that I get. I hit select all, unselect the rows with the actual data, right click and hit delete. How can I do something like that within autoit. Or maybe I can find the last row with actual data, and from there on (I'm assuming like select all) delete.

Edited October 18, 2023 by Champak

[Andreik]

1 hour ago, Champak said:

Or maybe I can find the last row with actual data, and from there on (I'm assuming like select all) delete.

That's exactly what I was think. Or you can use _Excel_RangeFind() or _Excel_RangeRead() to get empty cells or whatever is not valid data according to your definition and then _Excel_RangeDelete() to delete the content of these cells/rows/columns.

Edited October 18, 2023 by Andreik

[water]

Please have a look at the wiki about Excel Ranges. 
Select the needed Range and loop from the end to the first row holding valid data. Delete all rows holding no/ invalid data. 

[Champak]

thanks