Problems with xlsread function
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Jonathan Sullivan
2012-12-21
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 个评论
Image Analyst
2012-12-21
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?
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!