MATLAB: Readcell command doesn’t work anymore!

readcell

Hi all,

I have a matlab code that reads data from an excel sheet using the readcell function.

I have a data starting in cell B3 to Bx (x can be different).

So I used the following finction to get these data

x1 = readcell("model","sheet","sheet name","Range",'B3:B3');

This function used to give me the needed results (all non empty cells in col B starting from B3). However, I just tried to run my code again today and I was chocked that this command doesn't work anymore!!! error !!!

any idea? please help me!

Thanks in advance,

Lara

Best Answer

This only reads one cell:

"Range",'B3:B3'

There is nothing in your code that reads "all non empty cells in col B starting from B3" as you write. It just reads B3.

Related Solutions

MATLAB: Import entire row instead of range from excel

T = readtable(file) ;   % suggested 
data = xlsread(file) ;

MATLAB: How to use xltoRight, xlDown and similar utilities from MATLAB

The following example uses the Excel functions xltoRight and xlDown to select a contiguous block of data. For more information on how these functions work, consult your Microsoft documentation.

Note that there must be a block of data around the specified cell B9; otherwise, these Excel functions will select the entire worksheet, as detailed in the Microsoft documentation.

e = actxserver ('Excel.Application') % open Activex server
eWorkbooks = e.Workbooks
exlFile = eWorkbooks.Open('C:\MyFile.xls')%open file
exlSheet1 = exlFile.Sheets.Item('Tabelle1')%Choose Sheet
lastCol = exlSheet1.Range('B9').End('xltoRight').Column % find last column
% Convert column number to Excel column code
if (lastCol <= 26)
      lastColchar=char(96+lastCol)
else
      lastColchar = [char(96+floor((lastCol-1)/26)) char(97+rem(lastCol-1,26))]
end
lastrow = exlSheet1.Range('B9').End('xldown').Row % find last row
myrange=[lastColchar num2str(lastrow)]
data_ran=['b9:' myrange]
data=exlSheet1.Range(data_ran).Value% These are the  requested data

Best Answer

Related Solutions

MATLAB: Import entire row instead of range from excel

MATLAB: How to use xltoRight, xlDown and similar utilities from MATLAB

Related Question