Hello! I am reading an Excel invoice and I am trying to extract the line item information using Read Range (Range: C24:N43 - 20 rows). When I do LineItem.Rows.Count, it always returns 20, even if the rows are empty. How would I get the correct row count in this situation?
Note: If any column in the rows contain a value, it should be considered a non-empty row