matlab与excel xlsread、xlswrite实用方法.doc

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名、范围ExamplesExample 1 Reading Numeric DataThe Microsoft Excel spreadsheet filetestdata1.xlscontains this data: 1 6 2 7 3 8 4 9 5 10To read this data into MATLAB, use this command:A = xlsread(testdata1.xls)A = 1 6 2 7 3 8 4 9 5 10Example 2 Handling Text DataThe Microsoft Excel spreadsheet filetestdata2.xlscontains a mix of numeric and text data: 1 6 2 7 3 8 4 9 5 textxlsreadputs aNaNin place of the text data in the result:A = xlsread(testdata2.xls)A = 1 6 2 7 3 8 4 9 5 NaNExample 3 Selecting a Range of DataTo import only rows4and5from worksheet1, specify the range asA4:B5:A = xlsread(testdata2.xls, 1, A4:B5)A = 4 9 5 NaNExample 4 Handling Files with Row or Column HeadersA Microsoft Excel spreadsheet labeledTemperaturesin filetempdata.xlscontains two columns of numeric data with text headers for each column:Time Temp12 9813 9914 97If you want to import only the numeric data, usexlsreadwith a single return argument. Specify the filename and sheet name as inputs.xlsreadignores any leading row or column of text in the numeric result.ndata = xlsread(tempdata.xls, Temperatures)ndata = 12 98 13 99 14 97To import both the numeric data and the text data, specify two return values forxlsread:ndata, headertext = xlsread(tempdata.xls, Temperatures)ndata = 12 98 13 99 14 97headertext = Time Temp+ExamplesExample 1 Writing Numeric Data to the Default WorksheetWrite a 7-element vector to Microsoft Excel file testdata.xls. By default, xlswrite writes the data to cells A1 through G1 in the first worksheet in the file:xlswrite(testdata.xls, 12.7 5.02 -98 63.9 0 -.2 56)Example 2 Writing Mixed Data to a Specific WorksheetThis example writes the following mixed text and numeric data to the filetempdata.xls:d = Time, Temp; 12 98; 13 99; 14 97;Callxlswrite, specifying the worksheet labeledTemperatures, and the region within the worksheet to write the data to.xlswritewrites the 4-by-2 matrix to the rectangular region that starts at cellE1in its upper left corner:s = xlswrite(tempdata.xls, d, Temperatures, E1)s = 1The output statussshows that the write operation succeeded. The data appears as shown here in the output file:Time Temp 12 98 13 99 14 97Example 3 Appending a New Worksheet to the FileNow write the same data to a worksheet that doesnt yet exist intempdata.xls. In this case,xlswriteappends a new sheet to the workbook, calling it by the name you supplied in thesheetsinput argument,NewTemp.xlswritedisplays a warning indicating that it has added a new worksheet to the file:xlswrite(tempdata.xls, d, NewTemp, E1)Warning: Added specified worksheet.If you dont want to see these warnings, you can turn them off with this command:warning off MATLAB:xlswrite:AddSheetNow try the write command again, this time creating another new worksheet,NewTemp2. Although the message does not appear this time, you can still retrieve it and its identifier from