1)首先先建立xlsx文件:
2)里面书写如下:
3)在命令窗口输入下列代码:
>> [num,name,raw]=xlsread('student.xlsx','sheet1','a2:d3')
num =
82 98 85
95 67 87
name =
'张三'
'李四'
raw =
'张三' [82] [98] [85]
'李四' [95] [67] [87]
>> total=num(:,1)+num(:,2)+num(:,3)
total =
265
249
>> xlswrite('student.xlsx',total,'sheet1','e2:e3') %写入文件