what should I include in the code that read the data from specific sheet of excel file

2 次查看（过去 30 天）
muhammad choudhry
muhammad choudhry 2021-7-22
评论： muhammad choudhry 2021-7-22
Hi,
I have excel file with around 12 sheet basically 12 experimental data and I would like to make my life easier by putting the line of code into the existing code that it will read the sheet name and plot the data from that sheet, with code below it is only reading the data from the first sheet..... I am googling from last hour but I couldnt't find something relevant coming. It be a great time saving help if you guys can help.
Current code:
a=readmatrix('Head_Pressure_all.ods');
% I want to add a sort of code line here where the code can into file 'Head_Pressure_all.ods' and read the data from that sheet
x=a(:,4);
y=a(:,8);
figure(1)
plot(x,y,'x','LineWidth',0.5);
hold on

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

采纳的回答

KSSV
KSSV 2021-7-22
T = readtable('myfile.xlsx','Sheet','1');
  1 个评论
muhammad choudhry
muhammad choudhry 2021-7-22
hi, thanks for help...... I got it sorted your line works but with readmatrix, getting the error below by using readtable.
Error:
Warning: Column headers from the file were modified to make them valid MATLAB identifiers
before creating variable names for the table. The original column headers are saved in the
VariableDescriptions property.
Set 'PreserveVariableNames' to true to use the original column headers as table variable
names.
Error using tabular/plot (line 216)
Tables and timetables do not have a plot method. To plot a table or a timetable, use the
stackedplot function. As an alternative, extract table or timetable variables using dot or
brace subscripting, and then pass the variables as input arguments to the plot function.
Error in pressure_head_all (line 7)
plot(x,y,'x','LineWidth',0.5);

请先登录，再进行评论。

更多回答（0 个）

类别

在 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