Feuilles de calcul

Feuilles de calcul Microsoft^® Excel^®

Lisez et écrivez des données issus de fichiers de tableur (feuilles de calcul), y compris des fichiers .xls et .xlsx, sous forme de tables, de timetables, de matrices ou de tableaux dans MATLAB^®. Vous pouvez importer un ensemble de données sélectionnées ou plusieurs feuilles de calcul à partir de fichiers de tableur.

Applications

Import Tool

Import data from file

Tâches du Live Editor

Import Data

Import data from a file in the Live Editor (depuis R2023a)

Fonctions

développer tout

Lire et écrire des tables ou des timetables

Importation et exportation de base

`readtable`	Create table from file
`writetable`	Write table to file
`readtimetable`	Create timetable from file
`writetimetable`	Write timetable to file
`sheetnames`	Get sheet names from spreadsheet file (depuis R2019b)

Définir des règles d’importation

`detectImportOptions`	Create import options based on file content
`spreadsheetImportOptions`	Import options object for Spreadsheets
`getvaropts`	Get variable import options
`setvaropts`	Set variable import options
`setvartype`	Set variable data types
`preview`	Preview eight rows from file using import options

Lire et écrire des matrices et des tableaux

`readmatrix`	Read matrix from file
`writematrix`	Write a matrix to a file
`readcell`	Create cell array from file
`writecell`	Write cell array to file
`readvars`	Read variables from file
`importdata`	Load data from file

Objets

spreadsheetDatastore Datastore for spreadsheet files

Rubriques

Lire les données de feuilles de calcul

Import Spreadsheets
Spreadsheets, such as Microsoft Excel files, often contain a mix of numeric and text data as well as variable and row names.
Read Spreadsheet Data Using Import Tool
Preview spreadsheet data from a file or the clipboard and select data to import using the Import tool.
Read Spreadsheet Data into Table
The best way to represent tabular spreadsheet data in MATLAB is in a table since tables can store heterogeneous (a mix of numeric and text) data, as well as variable and row names.
Control How MATLAB Imports Your Data
If you want to control the import process beyond the options provided by the readtable function, such as defining how to handle missing data or errors, then create an import options object before importing the data.
Read Spreadsheet Data into Array or Individual Variables
In addition to importing data as a table using readtable, you can also import data as a matrix, a cell array, or import separate variables directly in to the workspace.
Read Collection or Sequence of Spreadsheet Files
Read and manage data from a collection of spreadsheet files.

Écrire des données dans des feuilles de calcul

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

Informations connexes

Importing Spreadsheets (4 min 34 s)