read entire sheet in xlsread basic mode

3 次查看（过去 30 天）
Ryan Jones
Ryan Jones 2019-10-1
回答： Urmila Rajpurohith 2019-11-19
I would like to read in the data on an entire excel sheet in linux. The size of the data is variable. From what i've read xlsread only works with the 'basic' option on linux. Is there any way to read the entire sheet?
When I try:
[num,txt,raw] = xlsread('myfile.xlsx','mySheetName','','basic')
all I get is the contents of the A1 cell.
Im using 2018b.

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

回答（1 个）

Urmila Rajpurohith
Urmila Rajpurohith 2019-11-19
“xlsread” is not recommended instead you can use “readtable” function to read entire excel sheet.
You can refer to the below documentation for more information on “readtable” function.
https://www.mathworks.com/help/matlab/ref/readtable.html

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by