MATLAB: Reading multiple cells after merged cell from excel sheet

actxservercomexcelmerged cells

Cells A1 and B1 are merged. Now when I read Cells A1 and B1 with Excel COM Application, they read 'Waste Accumulation'and 'NaN' and The immediate cell going down after merged cell is just A2 . Is there a method with which I can read both the cells A2 and B2 after read merged cell? I would like to read column after cells A2 and B2 separately.

Best Answer

I'm still not exactly clear what your question is. If you're trying to find the cells that are part of the merge I've already shown how to do that in my comment:

%...
sheet = workbook.Worksheets.Item(sheetname{1});
start_range = sheet.Cells.Find(string_item{1});  %no need to get the address
end_range = start_range.End('xlDown');
numcolumns = start_range.MergeArea.Columns.Count;  %if you want to know how many columns are merged

After that I'm not sure what you want to do.

Related Solutions

MATLAB: How to determine the range of cells in an Excel worksheet that have values in them using MATLAB 7.9 (R2009b)

When you use XLSREAD to read data from an Excel file, MATLAB creates a COM connection to the Excel Application and reads data. The input argument "range" is passed to the Excel parser and so you can use any valid expression that Excel understands. Unfortunately, there is no direct mechanism to specify reading all values from a specific cell.

To determine the range of cells being used on an Excel worksheet, you can inspect the "UsedRange" variable which is provided by the Excel COM Interface. The code snippet below indicates how this can be done:

Excel = actxserver('Excel.Application');
fullPathToExcelFile = 'C:\work\myFile.xlsx'; % Please modify this to the location of your excel file
ExcelWorkbook = Excel.workbooks.Open(fullPathToExcelFile,0,true);
WorkSheets = Excel.sheets;
TargetSheet = get(WorkSheets,'item','Sheet1');
Activate(TargetSheet);
DataRange = Excel.ActiveSheet.UsedRange;
r = DataRange.Address
ExcelWorkbook.Close
Excel.Quit
Excel.delete
clear Excel WorkSheets TargetSheet DataRange ExcelWorkbook
% Using the range returned to read data
r1 = regexp(r, ':', 'split');
end_cell = regexprep(r1{2}, '\$', '');
start_cell = 'B9';
range = [start_cell ':' end_cell];
val = xlsread('myFile.xlsx', 'Sheet1', range);

MATLAB: How to use offset function of excel vba in Matlab coding environment???

Matlab indexing starts at 1 not 0.

 first_m = objSheet.Range('A:Z').Find('month').offset(1,1).Address;

Best Answer

Related Solutions

MATLAB: How to determine the range of cells in an Excel worksheet that have values in them using MATLAB 7.9 (R2009b)

MATLAB: How to use offset function of excel vba in Matlab coding environment???

Related Question