Spreadsheet

The Spreadsheet module provides functions for reading and writing tabular data from and to text-based spreadsheet formats, such as CSV and delimiter-separated files.

It supports importing into various data types like numeric arrays, cell arrays, and tables, as well as exporting them back to files.

This enables smooth interaction with spreadsheet software (Excel, LibreOffice Calc, etc.) and data exchange between applications.

csvread
Read comma-separated value (CSV) file.
csvwrite
Write comma-separated value file.
delimitedTextImportOptions
Create options for importing delimited text data.
detectImportOptions
Create import options based on file content.
dlmread
Read an numeric matrix from a text file file using a delimiter.
dlmwrite
Write an numeric matrix to a text file file using a delimiter.
getvaropts
Get variable import options for selected variables.
jsonImportOptions
Create options for importing JSON data.
readcell
Create cell array from file.
readmatrix
Create matrix array from file.
readtable
Create table from file.
readtimetable
Create timetable from file.
readvars
Create variables by reading column-oriented data from a file.
setvaropts
Set variable import options for selected variables.
setvartype
Set variable data types for selected variables.
spreadsheetImportOptions
Create options for importing spreadsheet data.
writecell
Write a cell to a file.
writematrix
Write a matrix to a file.
writetable
Write table to file.
writetimetable
Write timetable to file.
xlsfinfo
Return information about an Open XML spreadsheet file.
xlsread
Read data from an Open XML spreadsheet file.
xlswrite
Write data to an Open XML spreadsheet file.