Trying to run validation on a spreadsheet that includes searching for headers that contain a space (" ") or an empty string beyond the final valid header. When the spreadsheet is parsed it doesn't include these headers in the returned list of values.
If they are found within a list of valid rows it is found but trims the value to an empty string ("").