converting txt to xlsx
Mostrar comentarios más antiguos
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*
Respuesta aceptada
Tim Koopman
el 16 de Jul. de 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')
Más respuestas (0)
Categorías
Más información sobre Spreadsheets en Centro de ayuda y File Exchange.
el 16 de Jul. de 2020
el 16 de Jul. de 2020
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
