How do we eliminated columns in excel file has negative values?

Dear experiences

i have a data which are stored in an excel file which is consist from thousands of columns, therefore in my data there are some columns completely contain negative values in random order in other words in columns which must be eliminate the complete values in these columns are negative and there is no positive values exist .. i'm thinking to check first value in every column if its negative then eliminate otherwise if >=0 then leave. as in the following image where i need to eliminated columns along with its columns labels..

i would glade thanks any one can find a way to do this process.

Answer 1

[Guillaume]

To delete at once all the columns for which all the rows are negative:

yourmatrix(:, all(yourmatrix < 0)) = [];

[ahmed obaid]

this code is very sufficient, only small note as in the following image where i need to eliminated columns along with its columns labels. how to do that please if i read data from excel as a table or matrix.

[Guillaume]

 yourtable(:, all(yourtable{:, :} < 0) = []

[ahmed obaid]

Very excellent solution, only small note, hot to avoid parse or deleting only first columns because its contain rows labels, i have applied your code on the table without first columns and its work very well but when i consider my attached image table its shown an error

Cannot concatenate the table variables 'St1' and 'Var1', because their types are double and cell.

[Guillaume]

yourtable(:, [false, all(yourtable{:, 2:end} < 0)] = [];

However, better would be to fix the import so that the row labels become row names in the table. To your readtable add the option , 'ReadRowNames', true

[ahmed obaid]

Very smart solution , thanks a lot