Super Moderator
تاريخ عضويت: خرداد ۱۳۸۷
محل سكونت: دنیا
پست ها: 281
تشكرها: 28
253 تشكر در 147 پست
My Mood:
|
نقل قول:
نوشته اصلي بوسيله c1354
لطفا کمکککککککککککککک فرمایید
.
|
سلام
از لینک زیر:
Read Microsoft Excel spreadsheet file - MATLAB xlsread - MathWorks Deutschland
كد:
Read Microsoft Excel spreadsheet file
expand all in page
Syntax
- num = xlsread(filename) example
- num = xlsread(filename,sheet)
- num = xlsread(filename,xlRange) example
- num = xlsread(filename,sheet,xlRange) example
- num = xlsread(filename,sheet,xlRange,'basic')
- [num,txt,raw] = xlsread(___) example
- ___ = xlsread(filename,-1)
- [num,txt,raw,custom] = xlsread(filename,sheet,xlRange,'',functionHandle) example
Description
example
num = xlsread( filename) reads data from the first worksheet in the Microsoft® Excel® spreadsheet file named filename and returns the numeric data in array num.
On Windows® systems with Microsoft Excel software, xlsread reads any file format recognized by your version of Excel.
If your system does not have Excel for Windows, xlsread operates in basic import mode, and reads only XLS, XLSX, XLSM, XLTX, and XLTM files.
num = xlsread( filename, sheet) reads the specified worksheet.
example
num = xlsread( filename, xlRange) reads data from the specified range, xlRange, of the first worksheet in the file.
example
num = xlsread( filename, sheet, xlRange) reads from the specified sheet and range, xlRange.
num = xlsread( filename, sheet, xlRange, 'basic') reads data from the spreadsheet in basic mode, the default on systems without Excel for Windows. If you do not specify all the arguments, use empty strings as placeholders, for example, num = xlsread(filename,'','','basic').
example
[ num, txt, raw] = xlsread(___) additionally returns the text fields in cell array txt, and the unprocessed data (numbers and text) in cell array raw using any of the input arguments in the previous syntaxes. If xlRange is specified, leading blank rows and columns in the worksheet that precede rows and columns with data are returned in raw.
___ = xlsread( filename,-1) opens an Excel window to interactively select data. Select the worksheet, drag and drop the mouse over the range you want, and click OK. This syntax is supported only on Windows systems with Excel software.
example
[ num, txt, raw, custom] = xlsread( filename, sheet, xlRange,'', functionHandle) reads from the spreadsheet, executes the function associated with functionHandle on the data, and returns the final results as numeric data in array num. The xlsread function optionally returns the text fields in cell array txt, the unprocessed data (numbers and text) in cell array raw, and the second output from the function associated with functionHandle in array custom. The xlsread function does not change the data stored in the spreadsheet. This syntax is supported only on Windows systems with Excel software.
__________________
.
.
.
برای تشکر دکمه مخصوص وجود دارد لطفا پست هرز ایجاد نکنید
.
.
اینقدر از دسترسی نداشتن به مقاله شیون نکنید
مقالات انگلیسی: ایران سای (ISI, IEEE, ACM)
مقالات فارسی: سیویلیکا (کنفرانس داخلی)
مقالات فارسی: مگ ایران (ژورنالهای داخلی)
|