This is a static copy of a profile report

Home

readSpreadsheet>handleReplacement/processRules (Calls: 1, Time: 0.005 s)
Generated 04-Jun-2021 04:11:24 using performance time.
nested function in file C:\Program Files\MATLAB\R2020b\toolbox\matlab\io\spreadsheet\+matlab\+io\+spreadsheet\+internal\readSpreadsheet.m
Copy to new window for comparing multiple runs

Parents (calling functions)

Function NameFunction TypeCalls
readSpreadsheet>handleReplacementsubfunction1
Lines where the most time was spent

Line NumberCodeCallsTotal Time% TimeTime Plot
94
[fill,variables{k}] = matlab.i...
30.004 s74.5%
98
end
30.000 s6.4%
93
fill = varOpts{k}.FillValue;
30.000 s5.4%
96
variables{k}(ids(:,k)) = fill;
10.000 s2.7%
95
if ~all(ids(:,k) == 0)
30.000 s2.3%
All other lines  0.000 s8.7%
Totals  0.005 s100% 
Children (called functions)

Function NameFunction TypeCallsTotal Time% TimeTime Plot
processRawFillfunction30.003 s51.2%
Self time (built-ins, overhead, etc.)  0.003 s48.8%
Totals  0.005 s100% 
Code Analyzer results
No Code Analyzer messages.
Coverage results
Show coverage for parent directory
Total lines in function24
Non-code lines (comments, blank lines)5
Code lines (lines that can run)19
Code lines that did run12
Code lines that did not run7
Coverage (did run/can run)63.16 %
Function listing
time 
Calls 
 line
  83 
    function processRules(ids,rule,errFcn)
< 0.001 
      1 
  84
        switch(rule) 
< 0.001 
      1 
  85
            case 'error' 
  86 
                rowK = find(any(ids,2),1);
  87 
                colK = find(ids(rowK,:),1);
  88 
                errFcn(varOpts{colK}.Type,rowK,colK);
< 0.001 
      1 
  89
            case 'fill' 
  90 
                % Replace fill value
< 0.001 
      1 
  91
                for k = 1:numel(variables) 
  92 
                    % Replace fill value
< 0.001 
      3 
  93
                    fill = varOpts{k}.FillValue; 
  0.004 
      3 
  94
                    [fill,variables{k}] = matlab.io.internal.processRawFill(fill,variables{k}); 
< 0.001 
      3 
  95
                    if ~all(ids(:,k) == 0) 
< 0.001 
      1 
  96
                        variables{k}(ids(:,k)) = fill; 
< 0.001 
      3 
  97
                    end 
< 0.001 
      3 
  98
                end 
  99 
            case 'omitvar'
 100 
                % set the selected variable ID to zero so it can be filtered later.
 101 
                omitVars(:,any(ids,1)) = true;
 102 
            case 'omitrow'
 103 
                % Collect record numbers which need to be omitted
 104 
                omitRecords(any(ids,2),:) = true;
      1 
 105
        end 
< 0.001 
      1 
 106
    end 

Other subfunctions in this file are not included in this listing.