matLAB Gui Query Excel
显示 更早的评论
filename = 'HE_Data.xlsx';
sheet = 1;
xlRange = 'H10:AB10';
num = xlsread(filename,sheet,xlRange,'basic');
fname = {'Agriculture and related subjects','Architecture Building and Planning','Biological Sciences','Business and Administrative studies','Computer Science','Creative Arts and Design','Education','Engineering and Technology','Geographical Studies','Historical and Philosophical studies','Initial Teacher Training','Languages','Law','Mass Communications and Documentation','Mathematical Sciences','Medicine and Dentistry','Social Studies','Physical Sciences','Subjects allied to Medicine','Veterinary Sciences','Combined'};
x = 1:21; y = (num);
bar(x,y)
set(gca, 'XTick', 1:length(fname),'XTickLabel',fname);
xtickangle(90)
title('Aston University - Entrants in Each Field of Study')
6 个评论
Image Analyst
2018-11-29
Try this link
John Smith
2018-11-29
编辑：Guillaume
2018-11-29
wow thanks here it is:
this is the error im recieving. I tried the code from https://uk.mathworks.com/help/matlab/ref/xlsread.html
this is the error im recieving. I tried the code from https://uk.mathworks.com/help/matlab/ref/xlsread.html
Geoff Hayes
2018-11-29
John - what is the error that you are receiving? Or is it the error that your bar graph looks like the above? What should it look like? What can you tell us about the
num = xlsread(filename,sheet,xlRange,'basic');
data?
John Smith
2018-11-29
编辑：John Smith
2018-11-29
Geoff Hayes
2018-11-29
so it should be similar to the above data, but what are you really reading in?
John Smith
2018-11-30
编辑：John Smith
2018-11-30
these numbers from cell H10 to Ab10. some are blank aka 0. ive attached document have a look (HE_Data.xlsx)
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Text Data Preparation 的更多信息
2018-11-29
2018-11-30
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
