文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > 计算机软件及应用 > matlab读取excel
侵权投诉

matlab读取excel

matlab读取excel数据方法

text 读取函数csvread

XLSREAD Get data and text from a spreadsheet in an Excel workbook.

[NUMERIC,TXT,RAW]=XLSREAD(FILE) reads the data specified in the Excel

file, FILE. The numeric cells in FILE are returned in NUMERIC, the text

cells in FILE are returned in TXT, while the raw, unprocessed cell

content is returned in RAW.

[NUMERIC,TXT,RAW]=XLSREAD(FILE,SHEET,RANGE) reads the data specified

in RANGE from the worksheet SHEET, in the Excel file specified in FILE.

It is possible to select the range of data interactively (see Examples

below). Please note that the full functionality of XLSREAD depends on

the ability to start Excel as a COM server from MATLAB.

[NUMERIC,TXT,RAW]=XLSREAD(FILE,SHEET,RANGE,'basic') reads an XLS file as

above, using basic input mode. This is the mode used on UNIX platforms

as well as on Windows when Excel is not available as a COM server.

In this mode, XLSREAD does not use Excel as a COM server, which limits

import ability. Without Excel as a COM server, RANGE will be ignored

and, consequently, the whole active range of a sheet will be imported.

Also, in basic mode, SHEET is case-sensitive and must be a string.

[NUMERIC,TXT,RAW]=XLSREAD(FILE,SHEET,RANGE,'',CUSTOMFUN)

[NUMERIC,TXT,RAW,CUSTOMOUTPUT]=XLSREAD(FILE,SHEET,RANGE,'',CUSTOMFUN) When the Excel COM server is used, allows passing in a handle to a

custom function. This function will be called just before retrieving

the actual data from Excel. It must take an Excel Range object (e.g. of

type 'Interface.Microsoft_Excel_5.0_Object_Library.Range') as input,

and return one as output. Optionally, this custom function may return

a second output argument, which will be returned from XLSREAD as the

fourth output argument, CUSTOMOUTPUT. For details of what is possible

using the EXCEL COM interface, please refer to Microsoft documentation.

INPUT PARAMETERS:

FILE: string defining the file to read from. Default directory is pwd.

Default extension is 'xls'.

SHEET: string defining worksheet name in workbook FILE.

double scalar defining worksheet index in workbook FILE. See

NOTE 1.

RANGE: string defining the data range in a worksheet. See NOTE 2.

MODE: string enforcing basic import mode. Valid value = 'basic'. This

is the mode always used when COM is not available (e.g. on Unix).

RETURN PARAMETERS:

上一页第2页

你可能喜欢

热门文档

相关文档

  • 关于matlab读取excel以及处理

    在许多时候我们要借助于 matlab 读取 excel 的 内容进行处理, 内容进行处理,一下是一种常用的处理方法文件本质上就是一个二维矩阵, office 的表格文件也就是 xls...

  • matlab读取txt和excel

    matlab读取txt和excel_数学_自然科学_专业资料。matlab读取txt和excelText 的读写 1.读文本文件 fid=fopen('matlab3.txt','r') %我已把 txt 放入 matlab 默认...

  • matlab读取excel数据

    matlab读取excel数据_计算机软件及应用_IT/计算机_专业资料 暂无评价0人阅读0次下载举报文档 matlab读取excel数据_计算机软件及应用_IT/计算机_专业资料。1.用 ...

  • Matlab 如何读取 Excel 表格数据

    Matlab 如何读取 Excel 表格数据_理学_高等教育_教育专区。Excel 表格数据? 上一篇: 在 VC++程序中输出空心文字 Matlab 如何读取 Excel 表格数据 下一篇: My ANN...

  • Excel 读入Matlab

    ? 1.利用 matlab 从 excel 中读取数据使用:xlsread 命令、uiimport 可视化导入命令 exp:excel 表的文件名为 book1.xls,存放在 E:\ 读取命令:data = xlsread(...

  • MATLAB读取TXT excle

    MATLAB读取TXT excle_电脑基础知识_IT/计算机_专业资料。matlab教程文本读写matlab 中读取 excel 的 xls 文件 1.使用函数 xlsread 读取单个文件 (1)num=xlsread(...

  • MATLAB读取excel数据求助

    MATLAB 读取 excel 数据求助 想从 excel 中读取一个这样的矩阵 0 9 inf 3 inf 9 0 2 inf 7 inf 2 0 2 4 3 inf 2 0 inf inf 7 4 inf 0 可是用...

  • matlab与excel

    原理是这样的,当用户系统安装有 Excel 时,MATLAB 创建 Excel 服务器,通过服务器接口读取数 据。当用户系统没有安装 Excel 或 MATLAB 不能访问 COM 服务器时,...

  • MATLAB如何导入excel数据

    MATLAB如何导入excel数据_计算机软件及应用_IT/计算机_专业资料。下面我就通过实例介绍一下 MATLAB 如何导入 excel 数据。 1. 读取 sheet1 中的所有数据 我们以 03...

  • Matlab如何在Excel中提取数据

    clc;clear; dname=input (' 数据文件名:\n') ; %读入数据 Excel→Matlab A=xlsread (dname) ; 3 实验数据处理 - 64 - DATABASE AND INFORMATION MANAGEMENT...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email