How to extract specific columns from large excel spreadsheet

I am doing a project for school, and I'm very new to MATLAB. I have only just learned how to use xlsread to import an excel spreadsheet. I have an excel spreadsheet with a little over 300 rows and 15 columns. I need to be able to extract specific rows from specific columns. For example to create a scatter plot I need to extract about 100 different rows (not in order) from 2 of the columns. What is the best way to go about this? Thank you.

[Arif Hoq]

use readtable function. can you please be specific which rows do you want to extract ? Please attach your data

Answer 1

[Image Analyst]

With xlsread() you can specify what columns in the cell reference, something like

[numbers, strings, raw] = xlsread(filename, 'Sheet2', 'C1:D100'); % Extract column C & D

Adapt as needed.

[Alexander Duncan]

Can this be used to extract certain rows from those columns?

[Image Analyst]

If you wanted certain rows, you could extract it from numbers, strings, or raw with indexing, as usual, or you could just alter your range in the call to xlsread, like 'C30:D50' or whatever you want.