Matlab cannot read data from a file which is saved as a text-file from Excel
2 views (last 30 days)
Show older comments
I am not able to load data from a file which was saved as a text-file from MS Excel. textscan and load return an empty matrix. I tried to retype the data within the file using MS Notebook, to save the file with new name, however without success. If I open a new text-file with MS Notebook and copy-paste there the data from the file saved from Excel, then there is no problem with reading. Why?
2 Comments
laurie
on 1 Jun 2012
are you sure the format (UTF..) of your text-fil from Excel is the right one ? textscan as a "format" parameter i believe
Answers (1)
per isakson
on 2 Jun 2012
You need to set the input argument, encoding, of fopen. There are many alternatives including "Unicode".
4 Comments
See Also
Categories
Find more on Text Data Preparation in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!