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

672 次查看(过去 30 天)
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);

Community Treasure Hunt

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

Start Hunting!

Translated by