Can xlsread (Matlab) read pre-named range in Excel by range name?

8 次查看（过去 30 天）
TingTing
TingTing 2015-3-3
评论： John Wilson 2016-12-23
Hi,
I know xlsread can read precise the range you specify, for example A= xlsread(filename,'Sheet1','I1:I2') However, I have lots of numbers to read and it is not practical to specify all the ranges like 'I1:I2'. Instead, in Excel I have defined a range name for 'I1:I2', like below, area1, however, I can't find if Matlab xlsread can read by Excel range name. Can anyone help? Thanks!

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

回答（2 个）

Shrirang
Shrirang 2015-3-3
Hi Yiting, I think Matlab xlsread can read by Excel range name. instead of using only one return arg "A= xlsread(filename,'Sheet1','I1:I2') ", use "[A B C] = xlsread(filename,'Sheet1','I1:I2')" Now your variable B and C will containxls data. I hope this will be helpful to you.
  3 个评论
显示 1更早的评论
John Wilson
John Wilson 2016-12-23
Hey Yiting,
I'm having the same issue and I'm a little confused by your solution. I think we are chasing the same problem.
Within Excel VBA: I have defined an object as a range and set it to a range of cells Dim Range1 as Range Set Range1 = Range(Cells(2,3),Cells(45,3))
In Matlab I attempt to call this range using xlsread('blahblah.xlsm','Sheet1','Range1')
I dont think I have any comma separated data. Everything in my Excel sheet is dimensioned as a double. (Possibly an issue of Range taking in Doubles instead on integers)
Thank you for figuring it out I was starting to think it was impossible..

请先登录，再进行评论。

Konstantinos Sofos
编辑：Konstantinos Sofos 2015-3-4
Hi Yiting,
The best and the most efficient solution in such cases is to use another function (Not Matlab standard) which is the myxlsread (attached file) * EDIT *
Example
Inputfile = 'MyFile.xls';
SheetName = 'MySheet';
MyRange1 = 'area1';
[NumericDS1,TextDS1,Excel, ExcelWorkbook] = myxlsread(Inputfile,SheetName,MyRange1 );
MyRange2 = 'A1:C100'; % this is just a dummy choise
NumericDS2= myxlsread(Inputfile,SheetName,MyRange2,Excel, ExcelWorkbook);
ExcelWorkbook.Save;
ExcelWorkbook.Close(false);
Excel.Quit
This is very fast and open/close the file once.
Regards

类别

在 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