Re: Re[2]: xlsread does not read a column

[Nicholas Jankowski]

On Fri, Aug 5, 2016 at 10:10 AM, Nicholas Jankowski <address@hidden> wrote:

On Fri, Aug 5, 2016 at 3:04 AM, Svetlana <address@hidden> wrote:

 Sure. Here is my xlsx-file (attached). It contains the following column:
1
1
1
1
1
1
2
Here is my call of xlsread: 
clear all
clc
d=xlsread('test.xlsx') m-file and xlsx-file are in the same directory.

Here is the result: 
Detected XLS interfaces: COM*; (* = default interface)
d = 2
d is double, size(d) is 1x1 Четверг,  4 августа 2016, 18:54 +03:00 от "NJank [via Octave]" <address@hidden4.nabble.com>:
>

Hmmm... I'm unable to recreate what you're seeing. I saved you're xslx file and got the following behavior:

>> pkg load io
Picked up JAVA_TOOL_OPTIONS: -Djava.vendor="New Oracle"
>> xlsread('test.xlsx')
Detected XLS interfaces: ans =

   1
   1
   1
   1
   1
   1
   2

>> myvar = xlsread('test.xlsx')
myvar =

   1
   1
   1
   1
   1
   1
   2

If I remember correctly xlsread is a wrapper for other functions that do the actual conversion, and it can call different functions depending what's available on the system. (At least the older versions would look for installed Excel or Openoffice, or use Java, or ...?)  I have MS Office installed which may be affecting the choice made by the program. What do you have?

Just curious, what output do you get if you request all of the output arguments?  Please try:

>>  [num_array, text_array, raw_array, limits] = xlsread('test.xlsx')