Matlab cannot read data from a file which is saved as a text-file from Excel

2 Ansichten (letzte 30 Tage)
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 Kommentare
laurie
laurie am 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
G A
G A am 2 Jun. 2012
I have checked this again. This happens if you save data from Excel as Unicode Text. If you save the data as Text (Tab delimited) - everything is OK.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

per isakson
per isakson am 2 Jun. 2012
You need to set the input argument, encoding, of fopen. There are many alternatives including "Unicode".
  4 Kommentare
G A
G A am 3 Jun. 2012
I am using Office 2010 and Matlab 2011b
G A
G A am 3 Jun. 2012
I have tried
fopen(filename,'r','n','windows-1251')
varying encodings, however it has not solved the problem

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by