MATLAB – Working with Spreadsheets

Prerequisite: Getting Started with MATLAB

In Matlab, Spreadsheets are represented as a table. A spreadsheet most often contains text and numerical data in row and column format. You need to perform the following steps to start working with spreadsheets (.xlsx,.csv) in Matlab

• Click on upload in the header section.

• Now select your file.
• After upload completed, the uploaded file will be shown in your current folder window.
• Now double-click on your file. It will look like the below screenshot

Let’s Understand the import section.

Import Section in Matlab

The import section looks like below image

• The Selection/History section allows you to select specific range of rows/columns from your excel file.Let’s say you want to select data from column A row 1 to column C row 6 then enter A1:C6 in the area
• The Name part allows you to give your selected data a name say your variable name.

• After giving all the input now at the final step click on Import Selection.

• If you want to work as a normal variable with selected data then select import Data.
• If you want to Generate Script or Generate Function or Generate Live Script select the option of your preference.