Investigate reading from xls

[NeilMacMullen]

Perhaps we could read from openxml excel files rather than forcing a conversion to CSV?

[ADefWebserver]

What is the issue? If its Excel files I am having no issues with ExcelDataReader.DataSet

[NeilMacMullen]

thanks - that's a good suggestion. No technical issue; just that it hasn't been my priority to implement a suitable ITableLoader since I tend to work with csv/parquet/json. Plus there are lots of policy decisions to make around excel since you have multiple sheets. formatting, formulae etc so for a complicated spreadsheet you can't just say "read the data in the file"

[ADefWebserver]

for a complicated spreadsheet you can't just say "read the data in the file"

Uhhh that's what I'm doing 😉🙏🏽🤣

[ADefWebserver]

Tha advantage of using Excel at all is that it will provide column headers and "some" field types (Text, DateTime, Integer... ok basically that's it).

Otherwise, the only advantage is that: the data is already in excel format so why make them go any extra steps 😊