string array to excel

39 views (last 30 days)

Show older comments

TheDice on 26 Apr 2021

0
Link

Direct link to this question

https://in.mathworks.com/matlabcentral/answers/813925-string-array-to-excel

Commented: Stephen23 on 27 Apr 2021

Accepted Answer: Scott MacKenzie

Hello I have an 8x14 string array and would like to export it as an Excel file. Is there a command to do this?

Many greetings

Fabian

1 Comment
Show -1 older commentsHide -1 older comments

Stephen23 on 27 Apr 2021

https://www.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html

Sign in to comment.

Sign in to answer this question.

Accepted Answer

Scott MacKenzie on 26 Apr 2021

0
Link

Direct link to this answer

https://in.mathworks.com/matlabcentral/answers/813925-string-array-to-excel#answer_685495

Open in MATLAB Online

Am I missing something, or is this as simple as it seems:

s = repmat(["a" "bcd"], 8, 7); % 8x14 string matrix
writematrix(s, 'temp.xlsx');

1 Comment
Show -1 older commentsHide -1 older comments

TheDice on 27 Apr 2021

No it is as simple as it seems. I have tried many other commands but i have not found this one. Thanks for this.

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!