Matlab read/write excel

23 次查看（过去 30 天）
Omar Amodi
Omar Amodi 2018-11-28
回答： Omar Amodi 2018-11-28
this is the code:
entrants = get(handles.entrantspopup, 'Value');
switch entrants
case 1
cla;
fname = {'*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*'};
x = [1:21]; y = [0,30,680,7,55,7,88,9,53,34,56,21,45,66,44,22,1,34,45,56,32];
bar (x,y)
set(gca, 'XTick', 1:length(fname),'XTickLabel',fname);
xtickangle(90)
title('********')
instead of typing the excel numbers individually : "y = [0,30,680,7,55,7,88,9,53,34,56,21,45,66,44,22,1,34,45,56,32];"
how do i get excel to read and write these from the spreadsheet, i just want the y values.
12.png
  1 个评论
Omar Amodi
Omar Amodi 2018-11-28
also how would i do this data--------------
I want this data in: Sheet2, Teaching institution type (AP), Category (Asian or Asian British)
I want to present "the percentage for that institution type".
create1.png

请先登录，再进行评论。

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

回答（2 个）

Luna
Luna 2018-11-28
Hi,
check the link xlsread below. also look at the xlswrite.
xlsread
Omar Amodi
Omar Amodi 2018-11-28
bump

类别

在 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