Excel Reading and Processing

Question

Unnikrishnan PC 2011-9-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/14974-excel-reading-and-processing

I need to read marks one by one from one excel sheet (for eg: Marks for Maths & Chem arranged column wise for 100 students)calculate their grade (For eg: If Marks Above 50 Grade A else Grade B)and write it to another sheet in the corresponding cells. Can someone help me out this using actxserver.Thanks in advance.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Fangjun Jiang 2011-9-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/14974-excel-reading-and-processing#answer_20407

在 MATLAB Online 中打开

Do you have to use actxserver? If not, why not use xlsread?

[Num,Txt,Raw]=xslread('StudentMark.xls')

For example, if

Num=[90 40;70 80;30 60;60 20;20 80]
Grade=repmat({'B'},size(Num))
Grade(Num>50)={'A'}
xlswrite('StudentGrade.xls',Grade)

2 个评论
显示无隐藏无

Unnikrishnan PC 2011-9-3

Thanks for your suggestion. As I understand xlsread and xlswrite read the whole data on a sheet as a vector and then after manipulation write it to another sheet.

In my problem, I need to read marks one by one manipulate it and then writing too depends on contents on the destination cell.(For example the StudentGrade.xls already contains grades of previous exams and the program should write only if the current grade is more than the earlier else discard)

Hope you can help me complete this project.

Thanks

U.K.

Fangjun Jiang 2011-9-3

You can use more input arguments of the xlsread and xlswrite function. xlsread(File, Sheet, Range) xlswrite(File,Data,Sheet, Range). However, I believe it's more efficient for you to read in all the data once, process it and then write it back. If the sheet is huge and you don't have enough RAM to hold all the data at once, you might want to considering reading/writing multiple times. xlsread() and xlswrite() have lots of overhead. It will be slow if you want to do read and write for each student.

请先登录，再进行评论。