xlsread converts whole array to logical
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
John Williams
le 18 Jan 2016
Réponse apportée : Rebecca Krosnick
le 20 Jan 2016
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 commentaire
Walter Roberson
le 18 Jan 2016
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?
Réponse acceptée
Rebecca Krosnick
le 20 Jan 2016
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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Get Started with MATLAB dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!