How to export a matlab table as a excel/csv file?

681 次查看（过去 30 天）
Andi
Andi 2023-5-31
编辑： Andi 2023-6-1
Hi everyone,
Mya someone suggest me how i can export the Matlab table as a csv/excel file?

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
Cris LaPierre 2023-5-31
编辑：Cris LaPierre 2023-5-31
I suggest using writetable.
writetable determines the file format based on the specified extension. The extension must be one of the following:
  • .txt, .dat, or .csv for delimited text files
  • .xls, .xlsm, or .xlsx for Excel® spreadsheet files
  • .xlsb for Excel spreadsheet files supported on systems with Excel for Windows®
  • .xml for Extensible Markup Language (XML) files

更多回答（1 个）

Diwakar Diwakar
Diwakar Diwakar 2023-5-31
May be this code with help you.
% Sample table data
data = {'John', 25, 'USA'; 'Alice', 32, 'Canada'; 'Mike', 28, 'Australia'};
headers = {'Name', 'Age', 'Country'};
T = table(data(:,1), data(:,2), data(:,3), 'VariableNames', headers);
% Export as Excel file
excelFile = 'table_data.xlsx';
writetable(T, excelFile, 'Sheet', 'Sheet1');
% Export as CSV file
csvFile = 'table_data.csv';
writetable(T, csvFile);

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by