I was instructed to submit a feature request for adding a LoadOptions setting for the Spreadsheet component that would allow me to remove empty rows in an Excel file when loading, so that those rows are removed when I resave as CSV or Excel.
I was provided with a code sample for this, but it would be much easier if I could just set RemoveEmptyRows = true.