Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Ways to Import Spreadsheets

Import Data from Spreadsheets

You can import data from spreadsheet files into MATLAB® interactively or programmatically, using an import function.

This table compares the primary ways to import spreadsheet files.

Ways to Import Spreadsheet Files

Description

For More Information, See...

Import Tool

Import a worksheet or range to column vectors, a matrix, a cell array, or a table. You can generate code to repeat the operation on multiple files that are similar.

Read Spreadsheet Data Using Import Tool

readtable

Import a worksheet or range to a table.

Read Spreadsheet Data into Table

Define Import Options for Tables

xlsread

Import a worksheet or range to numeric and cell arrays.

Read Spreadsheet Data into Arrays

SpreadsheetDatastore

Import data from one or more worksheets in a file.

Import data from from a collection of spreadsheet files.

Importing Data from Excel Spreadsheets

Some import options require that your system includes Excel® for Windows®. For more information, see System Requirements and Supported File Formats for Spreadsheets.

Paste Data from Clipboard

Paste data from the clipboard into MATLAB using one of the following methods:

  • On the Workspace browser title bar, click , and then select Paste.

  • Open an existing variable in the Variables editor, right-click, and then select Paste Excel Data.

  • Call uiimport -pastespecial.

See Also

| | | |

Related Topics

Was this topic helpful?