Excel Reading and Processing

3 次查看（过去 30 天）
Unnikrishnan PC
Unnikrishnan PC 2011-9-2
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.

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

回答（1 个）

Fangjun Jiang
Fangjun Jiang 2011-9-2
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
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
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.

请先登录，再进行评论。

类别

在 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