Excel file cannot be uploaded if contains empty list validation

[mbechev]

Description

When importing an Excel file that has a list validation for some cells, but the list actually has no values, the following error is thrown and the file isn't uploaded to the Spreadsheet.

TypeError: Cannot read properties of undefined (reading 'charAt')
at peek (index.js:2834:26)
at eof (index.js:2837:20)
at readWhile (index.js:2883:21)
at peek (index.js:5103:17)
at Object.eof (index.js:5137:20)
at Object.parseSqref (index.js:5264:23)
at eval (index.js:21506:41)
at Object.leave (index.js:21536:23)
at call (index.js:20878:19)
at xmlTag (index.js:20775:21)
bt.forEach.console. @ preview-587cd39a5889a.js:2Understand this error
run/?file=src%2Fapp%2Fapp.component.ts:1

Steps To Reproduce

Upload the following file in this demo.

test-excel.xlsx.zip

Notice the ListValues sheet is empty. This causes the issue.

Actual Behavior

The file is not uploaded to the Spreadsheet.

Expected Behavior

The file should be uploaded correctly to the Spreadsheet and behave like in Excel (showing an empty dropdown when the cell is clicked).

[SanmanChavan05]

Also, there are some columns in the uploaded excel which have values but upon selecting that cell after import, you will find #REF and #VALUE instead of original value

Please take this into consideration as well

Thanks