[BUG] Posting Pass Fail Assignments Sometimes Fails

[gregbell26]

Description

Issue

When posting a pass / fail assignment, if the excel sheet containing the responses is online and not downloaded by the owner, then reading the file will fail.

Currently, the file appears to be encrypted (only one hashed column name was shown when initially debugging this issue).

Copying the data from the bad excel sheet to a new locally created sheet will also fail, it appears due to special characters in the column names.

The root cause is still unknown at this point and needs further investigation.

Steps to recreate

Create a Microsoft form and have it enter data into an excel sheet. Then from a different account download the shared file.
Attempt to load the file into the script.

Solution

The program should be able to read the file.

Acceptance Criteria

• Program should be able to read the file.

[gregbell26]

Further investigation is needed and acceptance criteria will be updated as the scope of work is determined.

This is important to resolve as this functionality saves a lot of time.