Can't run xlsread on Ubuntu Machine

6 次查看（过去 30 天）
Ozan Can Sahin
Ozan Can Sahin 2020-6-1
评论： Cris LaPierre 2020-6-3
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.

请先登录，再回答此问题。

回答（1 个）

Cris LaPierre
Cris LaPierre 2020-6-1
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.
  2 个评论
Ozan Can Sahin
Ozan Can Sahin 2020-6-3
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
Cris LaPierre 2020-6-3
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by