نمايش پست تنها
قديمي ۰۷-۸-۱۳۹۲, ۰۳:۵۱ بعد از ظهر   #10 (لینک دائم)
raha_hakhamanesh Male
Super Moderator
 
آواتار raha_hakhamanesh
 
تاريخ عضويت: خرداد ۱۳۸۷
محل سكونت: دنیا
پست ها: 281
تشكرها: 28
253 تشكر در 147 پست
My Mood: Zodranj
پيش فرض

نقل قول:
نوشته اصلي بوسيله 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)
مقالات فارسی: سیویلیکا (کنفرانس داخلی)
مقالات فارسی: مگ ایران (ژورنالهای داخلی)
raha_hakhamanesh آفلاين است   پاسخ با نقل قول
از raha_hakhamanesh تشكر كرده اند:
c1354 (۰۷-۹-۱۳۹۲), mehdi10421 (۰۷-۱۰-۱۳۹۴), yashar12 (۰۸-۲۸-۱۳۹۲)