usdigitalresponse / arpa-reporter

Web app to aid government agencies in reporting on ARPA grants.
Apache License 2.0
3 stars 0 forks source link

Ignore hidden sheets when extracting records from uploads #466

Closed ajhyndman closed 2 years ago

ajhyndman commented 2 years ago

In one RI upload, there are some fields filled out in the EC 2 sheet, even though EC 1 was later selected.

https://ri-arpa-reporter-web.onrender.com/uploads/7566acc4-3485-4ecb-a846-7cf5f39f97fd

The EC 2 sheet is hidden, but we still read it when extracting records from the upload. This change explicitly ignores hidden sheets, to prevent this from happening in the future.

Fixes #453