清空筛选条件
清空筛选条件

How to select some specific rows from excel

47 次查看（过去 30 天）
yang
yang 2018-8-7
评论： GAGANDEEP KAUR 2020-12-10
I have a problem to select specific rows meeting criterion from excel.
The third column in my data is the criterion. I want to select the rows whose third column numbers are in a certain range, and then keep the whole row and create a new excel file for it.
I mainly have three questions:
a. In what format should I input my data? Should I use xlsread or input it as a table?
b. Which type of data is more convenient for selection and output as excel? Double, string, cell?
c. What function should I use to select certain rows?
Thank you if anyone could help me.

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

采纳的回答

Savio Tran
Savio Tran 2018-8-7
Using xlsread, you can pull in the row you wanted as follows:
filename = 'dummy.xls';
data = xlsread(filename); %import data
columnData = data(:,3); %pull out column
This should pull your data out as an array of doubles, and then you can select rows using comparisons to filter
inRangeIndexes = find(columnData<lowerRange & columnData>upperRange);
newDataSet = data(inRangeIndexes,:); % contains only desired rows
Then, you can export your new data set using xlswrite.
  2 个评论
GAGANDEEP KAUR
GAGANDEEP KAUR 2020-12-10
Can any one please tell how can I transpose data containing range in MATLAB as if
x1=x((1:3),1);
x2=x((1:3),2);
I need x1 and x2 as transpose of x with specified rows and columns(data selected from excel sheet)

请先登录，再进行评论。

更多回答（0 个）

类别

在 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