Spreadsheet parsers do not handle blank rows gracefully

[collinss-jpl]

🐛 Describe the bug

Providing a spreadsheet file (CSV or XLS) as input with one or more blank rows can cause unhelpful exceptions to be raised. The service should be able to process or skip blank rows without raising an error.

📜 To Reproduce

Steps to reproduce the behavior:

1. Submit the attached XLS spreadsheet to the service via the reserve action
2. Observe that the following exception is raised: pds_doi_service.core.input.exceptions.CriticalDOIException: 'NaTType' object has no attribute 'lower'

🕵️ Expected behavior

Service should process the spreadsheet with blank rows without raising an exception.

📚 Version of Software Used

v2.1.0

🩺 Test Data / Additional context

DOI_reserve_M2020_IMG_Release2_v2.xlsx

🏞Screenshots

🖥 System Info

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

---

🦄 Related requirements

⚙️ Engineering Details