Problems with xlsread function

1 次查看（过去 30 天）
Ed
Ed 2012-12-21
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?

请先登录，再回答此问题。

回答（1 个）

Jonathan Sullivan
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 个评论
Ed
Ed 2012-12-21
clearing and closing did not make any difference.
Image Analyst
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 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by