Write cell arrays to matlab

2 次查看（过去 30 天）

Bas 2015-9-17

评论： Bas 2015-9-17

Hi,

I have a matrix A containing 1x24 cells. Each cell contains data cx1, with c being variable. So, A{1} is 2360x1, while A{2} is 2344x1 etc.

Now I want each cell to be written in a separate sheet in excel. How can I do this? I tried several approaches but get errors all the time..

Anyone knows how to do this?

Walter Roberson 2015-9-17

for K = 1 : length(A)
  thissheetname = sprintf('Sheet#%02d', K);
  xlswrite('YourFile.xls', A{K}, thissheetname);
end

Bas 2015-9-17

Thanks this works :)

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

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

Translated by