saving 3 dimensional data in excel file in a particular format

1 view (last 30 days)

Show older comments

Ekta Sharma on 20 Sep 2022

0
Link

Direct link to this question

https://ch.mathworks.com/matlabcentral/answers/1808365-saving-3-dimensional-data-in-excel-file-in-a-particular-format

Commented: Ekta Sharma on 20 Sep 2022

Accepted Answer: Akira Agata

I have a dataset A(5,100,3000) and I want to export it to excel. I want 5 sheets, each with 100 rows and 3000 columns.

1 Comment
Show -1 older commentsHide -1 older comments

Ekta Sharma on 20 Sep 2022

It works. Thanks for your quick reply

Sign in to comment.

Sign in to answer this question.

Accepted Answer

Akira Agata on 20 Sep 2022

1
Link

Direct link to this answer

https://ch.mathworks.com/matlabcentral/answers/1808365-saving-3-dimensional-data-in-excel-file-in-a-particular-format#answer_1056925

Open in MATLAB Online

How about the following?

for kk = 1:5
    writematrix(squeeze(A(kk,:,:)), "yourExcel.xlsx", "Sheet", kk);
end

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Categories

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

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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