Problems with importing Excel csv format
12 views (last 30 days)
Hi. I have a lot of excel files with extension .csv that I would like to import to matlab. I think the problem is not really matlab oriented, maybe more excel. When I import the file emediately, I get the message "No data is available for review" or something like that. But if I just press the save button in my excel spread file and then click "yes" to some " format is not compatible with csv.." question, then it works again.
This clicking is very time consuming because of the many files. Have someone had related problems and solved it or any solutions to my bad explanation? Thanks on forehand! Fredrik
Fangjun Jiang on 19 Oct 2011
The message "some format is not compatible with csv.." indicates that the file contains some formatting that is not supported by .csv file.
Where does the .csv file come from? Can you use csvread() or xlsread() directly without opening the file in Excel? What if you open the .csv file with an text editor like M-editor. Do you see anything abnormal?
I suspect your .csv file has some problems. Use a text editor such as Notepad, Wordpad etc. to open it and visually inspect it to see if anything out of ordinary.
In MATLAB, you can use Excel COM server, go through a loop, open each .csv file and save it again. This is to utilize Excel to fix the problem. You probably can do that in Excel alone using Macros.
If you are using the Excel COM server, the following snip of code can be used.
xlCSV=6; %this constant is defined by MS Excel
Kevin on 22 Oct 2011
Why are you opposed to using xlsread?
xlsread reads your file in perfectly from what I can see...
[Data Text] = xlsread('000169_2011-08-18_stat.csv');
Walter Roberson on 22 Oct 2011
csvread() and dlmread() is documented as only reading data that has no text in it at all.
You can get around that restriction if you specify cell ranges, starting with a cell "below" any text lines and to the right of any text. The lines at the top that you skip can contain anything, but any cells to the left that you skip must not have any whitespace and must not have an embedded commas.