MATLAB Answers

converting txt to xlsx

8 views (last 30 days)
hjo
hjo on 16 Jul 2020
Commented: Tim Koopman on 16 Jul 2020
Hi I am trying to convert a textfile to xlsx. file
My textfile holds this information:
StudentName: James
School: University of Blah
Year: 2020
Grade: 3
Pin: 40
And I want to convert this to xlsx. file
*check the attached screenshot file*

  0 Comments

Sign in to comment.

Accepted Answer

Tim Koopman
Tim Koopman on 16 Jul 2020
This will convert the full text file to .xlsx:
yourFileName = readcell('yourFileName.txt')
writecell(yourFileName,'yourFileName.xlsx')
If you only want to save the second column, like in your screenshot, use this:
yourFileName = readcell('yourFileName.txt')
writecell(yourFileName(:,2),'yourFileName.xlsx')

  2 Comments

hjo
hjo on 16 Jul 2020
does readcell() function work on text files?
Tim Koopman
Tim Koopman on 16 Jul 2020
Yes it does

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!