Problems with xlsread function
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (1)
Jonathan Sullivan
il 21 Dic 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 Commenti
Image Analyst
il 21 Dic 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?
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!