I am uploading data from an excel file which was provided in a specific format, for which a minimum reproducible example is shown below:
I am trying to save each column into an array, using the following Matlab R2020b code:
params_filename = uigetfile({'*.xlsx','*.csv'});
param_config = readcell(params_filename);
greek_title = param_config(:,1);
japanese_title = param_config(:,3);
greek_value = param_config(:,2);
japanese_value = param_config(:,4);
However, because the greek letter arrays are longer than the japanese letter arrays, the japanese letter arrays have <missing>
values at the end to make them the same length, as shown below:
I can’t use Range
to read the correct cells, since the spreadsheet is provided by the user, and the column lengths are unpredictable. I would like to remove the <missing>
values, or better yet, quit reading a column as soon as a missing value is detected. How do I eliminate the <missing>
elements?