xlsread converts whole array to logical

1 次查看（过去 30 天）
John Williams
John Williams 2016-1-18
回答： Rebecca Krosnick 2016-1-20
I recently revisited a MatLab program from about 1 year ago and found that it no longer worked. I found the reason to be that xlsread now converts the whole numeric array to logical if the excel spreadsheet it is reading contains any true/false values. Previously it would have converted the logical values to 0 or 1 and and retained the correct values for the numeric cells. Has the behaviour of xlsread changed, and can I make it behave as it did before? I am currently using MatLab version 2015a. The previous version, with which my program worked, was 2012 a or b.
  1 个评论
Walter Roberson
Walter Roberson 2016-1-18
Which operating system are you reading on? In particular are you using MS Windows with Excel installed? If you are, have you tried using 'basic' mode?

请先登录，再进行评论。

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

采纳的回答

Rebecca Krosnick
Rebecca Krosnick 2016-1-20
I was able to reproduce this behavior (where the whole numeric array output is actually a logical array) in MATLAB R2015a, but MATLAB R2015b seems to have the original behavior you saw in R2012a/R2012b. You may want to try R2015b if you have access.
In R2015a, a workaround is to use the "raw" output from "xlsread", for example
>> [num,txt,raw] = xlsread('myExample.xlsx');
"raw" is a cell array, but will contain the numeric and logical values you are expecting.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Introduction to Installation and Licensing 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by