Matlab Programming Course > Fetching data from external files and fprintf command

External Files in Matlab Xlsread Command And Manipulation Of Excel Files

21.1k

The worksheet indicated by num = xlsread(filename, sheet) is read. num = xlsread(filename, xlRange) reads the first worksheet in the workbook from the supplied range. Use range syntax in Excel, such as 'A1:C3'. num = xlsread(filename, sheet, xlRange) reads the worksheet and range supplied.

The workspace variables are stored in MAT-files, which are binary MATLAB files. There are various successive versions of MAT-files that support an increasing variety of capabilities, starting with MAT-file Version 4. All MAT-file versions are supported by MATLAB releases R2006b and beyond.

Alternatively, in the Current Folder browser, right-click the file's name and select Import Data. Then choose the file you'd like to import. Set the importing choices in the Import Tool box before clicking Import Selection to import the data into MATLAB.

Learner's Ratings

4.7

Overall Rating

  • 83%
  • 9%
  • 4%
  • 0%
  • 4%

Reviews

H
Het PATEL
5

best

S
Souvik Poddar
5

excellent

A
Ayush Sinha
5

It's a great course, the curriculum is ideal. Very helpful too.

S
Sanjid Ahmed Sany
5

Excellent explanation sir.

S
Sanjid Ahmed Sany
5

Excellent explanation sir.

A
Akash Gupta
5

Excellent

N
Navin Kumar
5

Why payment processing time show technical difficulties.

A
Aanshika priya
5

ITS A AWESOME

A
Ashnarayan Kumar Sah
5

good

S
Shivayogi Alligidad
5

Nice teaching. ease to understand

Show More
Recommended Courses
Course Content

  1. Introduction To Matlab And User Interface
    17m 39s
  2. How to use LearnVern
    3m 20s
  3. Frequently Used Commands And Scripts And Workspace
    21m 25s
  4. Mathematical Operations and Variable Rules in Matlab
    27m 1s
  5. First Matlab Program - Area Calculation Of a Circle
    18m 17s
  6. Assignment of introduction to Matlab
    2m 35s

  1. Pre-defined Functions Factorial, Root, Trigonometrical, Exponential And Logarithmatic Functions
    16m 46s
  2. Complex Numbers Defining Complex Numbers Abs, Angle, Real, Image Commands In Complex Numbers
    15m 29s
  3. Vectors Defining Vectors, Transpose Of Vectors, Dot And Cross Products Of Vectors
    20m 22s
  4. Data Extraction From Vector, linspace Command, Element Wise Operations And Statistical Analysis Of Vectors
    20m 5s
  5. Assignment of Complex Numbers and Vectors
    2m 31s

  1. Matrices Defining Matrix, Data Extraction From Matrix, Sum, Min, Max Command In Matrix
    27m 49s
  2. Diagonal Matrix Reshape Command, Diag Command And Manipulation Of Diagonal Matrix
    15m 23s

  1. Engineering Mathematics Defining Function Using Inline Command, Differentiation And Integration
    30m 13s
  2. Limits And Partial Derivatives In Matlab
    14m 12s
  3. Assignment of Engineering Mathamatics
    2m

  1. Different Logical Operators, Andor Operation, If Statement With Example
    27m 7s
  2. If-else, Elseif, For And While Loop With Examples
    27m 59s
  3. Logical Operations In If Statement With Example
    16m 47s
  4. Switch Command With Example
    20m 22s
  5. Advance Functions Defining Annonymus Function
    13m 36s
  6. Projects Function Of Average, Evaluation Of Polynomial And Area Of Rectangle
    32m 7s
  7. Assignment of logical operations and Functions
    3m 55s
  8. Assignment of logical operations and Functions 2
    2m 20s

  1. External Files in Matlab Xlsread Command And Manipulation Of Excel Files
    20m 6s
  2. Fprintf Command Printing Desired Text Using fprintf Command With Examples
    17m 2s
  3. Area Calculation Of a Circle And Displaying Results Using fprintf Command
    18m 13s
  4. Assignment of Fetching data from external files and fprintf command
    2m 14s

  1. Plotting Plot Command, Labeling axis, Title Of Graph, Customization Of Graph, Subplots
    37m 7s
  2. Advance Plotting Hold Command, linewidth Commands And Marker Options
    31m 2s
  3. Assignment of Plotting and Graphs
    1m 41s

  1. Sensor Selection And Explaination Of BMI Project
    23m 35s
  2. Program On BMI (Body Mass Index)
    52m 14s
  3. Identifying The Prime Numbers Using For Loop
    15m 12s
  4. Identifying The Prime Numbers Using While Loop
    13m 50s
  5. While Loop Application
    16m 51s
  6. Summary Of Matlab
    50s
  7. Assignment of Programming examples
    2m 11s

  1. Matlab Interview Questions
    13m 2s
Enroll For Free