MATLAB: I have data in multiple excel sheets. How to import only certain columns only and plot the data.

import certain columns from excel sheet

I have multiple excel files in a folder. I would like to import only certain columns from those files and plot those columns in one single graph.

Best Answer

range='B:C'   % column B and C
xlsread('file.xlsx',range)

Related Solutions

MATLAB: Excel Range in specifies Sheet.

Hi, Just activating the particular sheet before adding range will solve it.

ex = actxserver('excel.application');

ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));

Sheets = Excel.ActiveWorkBook.Sheets;

Sheet3 = get(Sheets, 'Item', 'Sheet3');

Sheet3.Activate

ex.Range('A3').Name = 'RangeName';

ex.ActiveWorkbook.Save

ex.Quit

ex.release

MATLAB: Color the particular row of the excel sheet

% Connect to Excel
Excel = actxserver('excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'Book1.xlsx'),0,false);
% Set the color of cell "A1" of Sheet 1 to Yellow
WB.Worksheets.Item(1).Range('A1').Interior.ColorIndex = 6;
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();

Does this, ofcourse you can change all the values.

Best Answer

Related Solutions

MATLAB: Excel Range in specifies Sheet.

MATLAB: Color the particular row of the excel sheet

Related Question