converting txt to xlsx

12 次查看（过去 30 天）

gmltn1212 2020-7-16

评论： Tim Koopman 2020-7-16

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*

Tim Koopman 2020-7-16

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

gmltn1212 2020-7-16

does readcell() function work on text files?

Tim Koopman 2020-7-16

Yes it does

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Text Files

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

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

Translated by