Error using readtable (line 245)

Question

Idris Phillips-Fry 2020-12-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/689409-error-using-readtable-line-245

评论： Idris Phillips-Fry 2020-12-10

采纳的回答： Jan

在 MATLAB Online 中打开

following error message when importing data from libre office using following code.

T = readtable ('trial_data.xlsx' , 'range' , 'A2:B18');

Error using readtable (line 245)

Unable to open file 'C:\Users\Owner\Documents\MATLAB\trial_data.xlsx' as a workbook.

Check that the file exists, read access is available, and the file is a valid

spreadsheet file.

Error in Project_example_data_script (line 1)

T = readtable ('trial_data.xlsx' , 'range' , 'A2:B18');

NOTE: i have imported from libre office using .xlsx files successfully before with exactly this syntax and have ensured file is accessible and in correct location

3 个评论
显示 1更早的评论隐藏 1更早的评论

Idris Phillips-Fry 2020-12-10

trial_data.xlsx

This is the data i'm attempting to import

Walter Roberson 2020-12-10

Darn, I forgot that I don't have Excel installed on this boot partition, and my Excel is too old to install in my new OS version.

请先登录，再进行评论。

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

Answer 1

Jan 2020-12-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/689409-error-using-readtable-line-245#answer_571189

Your file is destroyed. Neither readtable, nor xlsread not Excel can open it successfully. Some of its parts are valid, as you can see by opening it in 7zip, but some important parts are missing.

You have to recreate the file.