matlab和excelxlsread、xlswrite实用方法.docxVIP

matlab与excel xlsread、xlswrite实用方法 [num, txt, raw, X] =?xlsread(filename, sheet, range) filename, sheet, range 文件名，sheet名、范围 num, txt, raw, X 输出 excel数据写入函数： [status, message] =xlswrite(filename, M, sheet, range) filename, M, sheet, range 文件名，数据、sheet名、范围 Examples Example 1— Reading Numeric Data The Microsoft Excel spreadsheet file?testdata1.xls?contains this data: 1 6 2 7 3 8 4 9 5 10 To read this data into MATLAB, use this command: A = xlsread(testdata1.xls) A = 1 6 2 7 3 8 4 9 5 10 Example 2 — Handling Text Data The Microsoft Excel spreadsheet file?testdata2.xls?contains a mix of numeric and text data: 1 6 2 7 3 8 4 9 5 text xlsread?puts a?NaN?in place of the text data in the result: A = xlsread(testdata2.xls) A = 1 6 2 7 3 8 4 9 5 NaN Example 3 — Selecting a Range of Data To import only rows?4?and?5?from worksheet?1, specify the range as?A4:B5: A = xlsread(testdata2.xls, 1, A4:B5) A = 4 9 5 NaN Example 4 — Handling Files with Row or Column Headers A Microsoft Excel spreadsheet labeled?Temperatures?in file?tempdata.xls?contains two columns of numeric data with text headers for each column: Time Temp 12 98 13 99 14 97 If you want to import only the numeric data, use?xlsread?with a single return argument. Specify the filename and sheet name as inputs. xlsread?ignores any leading row or column of text in the numeric result. ndata = xlsread(tempdata.xls, Temperatures) ndata = 12 98 13 99 14 97 To import both the numeric data and the text data, specify two return values for?xlsread: [ndata, headertext] = xlsread(tempdata.xls, Temperatures) ndata = 12 98 13 99 14 97 headertext = Time Temp +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Examples Example 1 — Writing Numeric Data to the Default Worksheet Write a 7-element vector to Microsoft