例一：将数据写入默认的工作表中

《Simulink与信号处理》

将一七元素向量写入testdata.xls中。默认格式下，数据将写入文件中第一个工作表的A1至G1单元格。

《Simulink与信号处理》

xlswrite('testdata.xls', [12.7 5.02 -98 63.9 0 -.2

56])

Matlab中文论坛

例二：将混合数据写入制定工作表中

www.iLoveMatlab.cn

d = {'Time', 'Temp'; 12 98; 13 99; 14 97};

Matlab中文论坛

s = xlswrite('tempdata.xls', d, 'Temperatures',

'E1')

s =

1

www.iLoveMatlab.cn

Time Temp

12 98

13 99

14 97 Matlab中文论坛

例三：向文件中添加新的工作表 Matlab中文论坛

现将上例中的数据写入tempdata.xls中并不存在的一个工作表中，在这种情况下，xlswrite会添加一个新的工作表，名称由用户指定，此时xlswrite会显示警告提示添加了新的工作表。

《Simulink与信号处理》

xlswrite('tempdata.xls', d, 'NewTemp', 'E1')

Warning: Added specified worksheet.

《Simulink与信号处理》

如果不想看到这些警告，可以输入下列命令。

Matlab中文论坛

warning off MATLAB:xlswrite:AddSheet

《Simulink与信号处理》

再一次输入写入命令，这次创建另外一个新的工作表NewTemp2，此时不再显示提示信息，但仍可以用msg命令提取该信息。

book.iLoveMatlab.cn

[stat msg] = xlswrite('tempdata.xls', d, 'NewTemp2',

'E1');

msg

msg =

message: 'Added specified worksheet.'

identifier: 'MATLAB:xlswrite:AddSheet' book.iLoveMatlab.cn

excel数据读取函数：

[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 62 73 84 95 10

To read this data into MATLAB, use this command:

A = xlsread("testdata1.xls")A =1 62 73 84 95 10

Example 2 — Handling Text Data

The Microsoft Excel spreadsheet file testdata2.xls contains a mix of numeric and text data:

1 62 73 84 95 text

xlsread puts a NaN in place of the text data in the result:

A = xlsread("testdata2.xls")A =1 62 73 84 95 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 95 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 Temp12 9813 9914 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 9813 9914 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 9813 9914 97headertext ="Time" "Temp"+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Examples

Example 1 — Writing Numeric Data to the Default Worksheet

Write 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 Worksheet

This example writes the following mixed text and numeric data to the file tempdata.xls:

d = {"Time", "Temp"; 12 98; 13 99; 14 97};

Call xlswrite, specifying the worksheet labeled Temperatures, and the region within the worksheet to write the data to. xlswrite writes the 4-by-2 matrix to the rectangular region that starts at cell E1 in its upper left corner:

s = xlswrite("tempdata.xls", d, "Temperatures", "E1")s =1

The output status s shows that the write operation succeeded. The data appears as shown here in the output file:

Time Temp12 9813 9914 97

Example 3 — Appending a New Worksheet to the File

Now write the same data to a worksheet that doesn’t yet exist in tempdata.xls. In this case, xlswrite appends a new sheet to the workbook, calling it by the name you supplied in the sheets input argument, "NewTemp". xlswrite displays 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 don’t want to see these warnings, you can turn them off with this command:

warning off MATLAB:xlswrite:AddSheet

Now 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 the second output argument, msg:

[stat msg] = xlswrite("tempdata.xls", d, "NewTemp2", "E1");msgmsg =message: "Added specified worksheet."identifier: "MATLAB:xlswrite:AddSheet"

No Related Post

fromhttp://www.ariszheng.com/?p=274