Problem opening excel csv file using xlsread
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Colin Gilbert
am 25 Nov. 2015
Kommentiert: ravi
am 11 Apr. 2016
I am trying to use the xlsread function to open a part of a CVS excel file that is too large to open in excel (1.07 GB).
B = xlsread('programtest.csv','Sheet 1','A10:F28');
However, I get the following error:
??? Error: The server threw an exception.
Error in ==> xlsread at 250 ExcelWorkbook = Excel.workbooks.Open(file,0,true);
Error in ==> programtest at 5 B = xlsread('programtest.csv','Sheet 1','A10:F28');
Is there a way to solve this issue? Thanks
1 Kommentar
ravi
am 11 Apr. 2016
I was encountering the same problem since long. I tried saving the excel file in 97-2003 format. And then xlsread worked well :-)
Akzeptierte Antwort
Weitere Antworten (1)
Walter Roberson
am 26 Nov. 2015
You are using MS Windows. On MS Windows, Excel is invoked by xlsread() to read the file, so if Excel cannot read the file then xlsread() cannot read the file either.
Mohammad mentioned csvread(); another possibility is fopen/textscan/fclose (which csvread will use internally); or fopen/fscanf()/fclose depending on the complexity of the file.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!