Elements in xlsread output MATLAB version R2018a

Question

GIorgi Tsutskiridze 2018-4-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/397468-elements-in-xlsread-output-matlab-version-r2018a

编辑： Walter Roberson 2018-4-26

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

I am trying to understand the function that Matlab executes for importing data from excel file.

The very first function in the script generated from import command is the following:

%%Import the data 
    [~, ~, raw] = xlsread('C:\Users\gtsutskiridze\Documents\MATLAB\G10XRATE.XLS','g10xrate','A2:J6238')
    raw(cellfun(@(x) ~isempty(x) && isnumeric(x) && isnan(x),raw)) = {''}

I have read the help file for xlsread and it says the following:

[NUM,TXT,RAW]=xlsread(FILE) reads data from the first worksheet in the
MicrosoftExcel spreadsheet file named FILE and returns the numeric data in array NUM.
Optionally, returns the text fields in cell array TXT, and the unprocessed data (numbers and text) in cell array RAW.

My question is the following: What do does ~ mean in the output of the xlsread [~, ~, raw] ?