You can upload a file with an xls extension as a spreadsheet. But we can only handle the more modern .xlsx format. We should prevent people from uploading xls and if we happen to hit a file that is in the old format, we should produce a well worded error to let people know what is going on.
On the backend it bails out in build lookup table in lookup service- xls = ExcelFile(data_model.data, engine='openpyxl')
So track this down and get a try-catch --> workflowException around it.
And on the frontend, don't allow xls as a file format to upload maybe?
You can upload a file with an xls extension as a spreadsheet. But we can only handle the more modern .xlsx format. We should prevent people from uploading xls and if we happen to hit a file that is in the old format, we should produce a well worded error to let people know what is going on.
On the backend it bails out in build lookup table in lookup service- xls = ExcelFile(data_model.data, engine='openpyxl') So track this down and get a try-catch --> workflowException around it.
And on the frontend, don't allow xls as a file format to upload maybe?