Elements in xlsread output MATLAB version R2018a
1 回表示 (過去 30 日間)
古いコメントを表示
GIorgi Tsutskiridze
2018 年 4 月 26 日
編集済み: Walter Roberson
2018 年 4 月 26 日
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] ?
0 件のコメント
採用された回答
Walter Roberson
2018 年 4 月 26 日
https://www.mathworks.com/help/matlab/matlab_prog/ignore-function-outputs.html
it means ignore output.
1 件のコメント
j.D
2018 年 4 月 26 日
編集済み: Walter Roberson
2018 年 4 月 26 日
Walter hope you are doing well i need your help with following problem a colleague of mine asked a question recently please have a look on it
Thanks in advance.
その他の回答 (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!