Help I am trying to create a Matlab script that reads in & opens up an Excel file in matlab, then gives you the versatility to filter out the columns and rows you do not want included. so far here I have something like:
data = xlsread('your_file.xls');
Newfile = unique('your_file.xls');
Newfile = data(:,20); *removes column 20*
Newfile = data(13,:); *removes row 13*
I am trying to find a way to make it so it doesn't need to be hard coded to filter out a column or row. Also is there a way to filter out the columns by variables as opposed to intergers. Thank you