Can't run xlsread on Ubuntu Machine

Hi all,

I'm using MATLAB R2019a on my Ubuntu(20.04) pc and I'm having some issues when I try running xlsread command. I created files with both .ods and .xlsx extensions (LibreOffice and Excel extensions) but I couldn't see the table I inserted in those files. But for those files, I got different errors. The errors are given below. Please note that I created the Excel file by changing the file extension of LibreOffice sheet. I'd appreciate any help.

Cheers,

Ozan

For Excel sheet:

>> data = xlsread('Sensors_excel')
Error using xlsread (line 257)
Could not open file /tmp/tp5a312b2b_fa72_4df9_a63a_38678b95f907/xl/_rels/workbook.xml.rels. No such file or
directory.

For LibreOffice sheet:

>> data = xlsread('Sensors')
Error using xlsread (line 136)
XLSREAD unable to open file 'Sensors'.
File 'Sensors' not found.

Answer 1

[Cris LaPierre]

The error seems to suggest either the name of your file is wrong, or the file is not in your current folder. If you need help changing the current folder, see my reply here.

I do recommend using readtable instead.

[Ozan Can Sahin]

Neither with xlsread nor with readtable I couldn't open the .ods files, but I managed to open Excel files with the help of the reply you sent to me. When trying to open .ods files, I am getting the errors below.

Xlsread:

>> xlsread('Sensors.ods')
Error using xlsread (line 257)
File contains unexpected record length.  Try saving as Excel 98.

Readtable:

>> readtable('Sensors.ods')
Error using readtable (line 216)
File extension 'ods' is not supported on computers without Excel for Windows or when 'UseExcel' is set to
false.

[Cris LaPierre]

I've always used a Windows System that has Excel. While those errors are likely descriptive enough, I did find additional info on supported file types here.

If it is numeric data you want to import, consider looking into this File Exchange submission.