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

Hi everyone,

Mya someone suggest me how i can export the Matlab table as a csv/excel file?

Answer 1

[Cris LaPierre]

I suggest using writetable.

• writetable(T,filename)

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

Answer 2

[Diwakar Diwakar]

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);