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.

Spreadsheets

Microsoft® Excel® spreadsheets

Read and write data in spreadsheet files, including .xls and .xlsx files. Import spreadsheet data interactively using the Import Tool. Import or export spreadsheet data programmatically using the functions on this page. To compare primary ways to import spreadsheet files, see Ways to Import Spreadsheets.

Functions

Import ToolImport data from file
readtableCreate table from file
writetableWrite table to file
xlsfinfoDetermine if file contains Microsoft Excel spreadsheet
xlsreadRead Microsoft Excel spreadsheet file
xlswriteWrite Microsoft Excel spreadsheet file
importdataLoad data from file
detectImportOptionsCreate import options based on file content
getvaroptsGet variable import options
setvaroptsSet variable import options
setvartypeSet variable data types

Using Objects

SpreadsheetDatastoreDatastore for spreadsheet files
SpreadsheetImportOptionsImport options object for Spreadsheets

Topics

Ways to Import Spreadsheets

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

Write Data to Excel Spreadsheets

Export data in the workspace to a Microsoft Excel spreadsheet file.

Define Import Options for Tables

For customized data import and additional control over the import process, define and use the import options.

System Requirements and Supported File Formats for Spreadsheets

System requirements and supported file extensions for spreadsheet files.

Was this topic helpful?