Problems with xlsread function
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
I am using Matlab R2012a.
I do the following example from your documentation:
values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9}
headers = {'First', 'Second', 'Third'}
xlswrite('myExample.xlsx', [headers; values]);
This creates an excel file no problem which I can open in excel.
When I do:
A = xlsread('myExample.xlsx')
I get the following error messages:
Error: Object returned error code: 0x800AC472
Error in xlsreadCOM (line 2)
Excel.DisplayAlerts = 0;
Error in xlsread (line 230)
[numericData, textData, rawData, customOutput] = xlsreadCOM(file, sheet,
range, Excel, customFun);
What is going on?
0 comentarios
Respuestas (1)
Jonathan Sullivan
el 21 de Dic. de 2012
I can't seem to recreate the problem. Try clearing and closing everything:
values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9}
headers = {'First', 'Second', 'Third'}
xlswrite('myExample.xlsx', [headers; values]);
clear all; close all
xlsread('myExample.xlsx')
2 comentarios
Image Analyst
el 21 de Dic. de 2012
Is your version of Excel modern enough to read .xlsx files? Sounds like it. What version is it? What happens if you ask for all 3 outputs that xlsread can return?
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!