Upload excel file

[Liandra]

Narrative

As a Finance guy I want to upload an excel file So That it can be used to create financial graphs

Acceptance Criteria

I am on the Finance Dashboard

• [ ] There is a file uploader button called "Upload Excel File" The excel file uploaded contains the following four sheets
• [ ] IS-ZA-Actuals
• [ ] IS-UG-Actuals
• [ ] Q2-ZA Plan
• [ ] Q2-UG Plan If the file
• [ ] Contains all four sheets you get a message " Succesfully uploaded file"
• [ ] Does not contain the four sheets an error is displayed to the user is " The excel file uploaded does not contain IS-ZA-Actuals, IS-UG-Actuals, Q2-ZA Plan and Q2-UG Plan, please try again "
• [ ] Is not an excel file " Please uploaded an excel spreadsheet"

[simphiwes]

Product owner agreed that on successful upload no message will display, instead user will be directed to the dashboard.

[simphiwes]

Non excel files are not uploadable.

[simphiwes]

Please open the excel spreadsheet to be uploaded to the internal finance dashboard and edit the column names to be different from what is expected (see expected list above). Go to the Internal finance dashboard and upload this edited file. Currently the excel uploads without errors. The expected behavior is that the upload will fail as stated above "The excel file uploaded does not contain IS-ZA-Actuals, IS-UG-Actuals, Q2-ZA Plan and Q2-UG Plan, please try again ".

Please check and advise.