MATLAB 操作Excel

使用xlsread和xlswirte函数

This MATLAB function reads the first worksheet in the Microsoft Excel
    spreadsheet workbook named filename and returns the numeric data in a matrix.

    num = xlsread(filename)
    num = xlsread(filename,sheet)
    num = xlsread(filename,xlRange)
    num = xlsread(filename,sheet,xlRange)
    num = xlsread(filename,sheet,xlRange,'basic')
    [num,txt,raw] = xlsread(___)

我常用 num = xlsread(filename) 数据都位num矩阵中，然后一点点操作矩阵即可
参数 sheet 就是选择那个表。默认是第一个表。
xlRange 选择你读取的范围，默认全读
返回值 num是数值。
一般情况下，我们只操作数值。

xlswrite - Write Microsoft Excel spreadsheet file

    This MATLAB function writes matrix A to the first worksheet in the Microsoft
    Excel spreadsheet workbook filename starting at cell A1.

    xlswrite(filename,A)
    xlswrite(filename,A,sheet)
    xlswrite(filename,A,xlRange)
    xlswrite(filename,A,sheet,xlRange)
    status = xlswrite(___)
    [status,message] = xlswrite(___)

我常用xlswrite(filename, num, “Sheet1”, “p3”);
参数分别为 文件名 数据（是矩阵） 表名 位置