This is a static copy of a profile report

Home

readSpreadsheetVariable (Calls: 11, Time: 0.018 s)
Generated 04-Jun-2021 04:11:19 using performance time.
function in file C:\Program Files\MATLAB\R2020b\toolbox\matlab\io\spreadsheet\+matlab\+io\+spreadsheet\+internal\readSpreadsheetVariable.m
Copy to new window for comparing multiple runs

Parents (calling functions)

Function NameFunction TypeCalls
...rtOptionsSpreadsheet.getOptsFromSheetclass method2
readSpreadsheet>readDataFromSheetsubfunction6
readSpreadsheet>readVariableMetadatasubfunction2
readSpreadsheet>readRowNamessubfunction1
Lines where the most time was spent

Line NumberCodeCallsTotal Time% TimeTime Plot
9
[var,errid,placeholder] = read...
80.015 s79.6%
6
[var,errid,placeholder] = read...
30.003 s15.2%
7
case {'char','string'}
80.000 s1.6%
4
case {'double','single','int8'...
110.000 s1.1%
25
end
110.000 s0.1%
All other lines  0.000 s2.5%
Totals  0.018 s100% 
Children (called functions)

Function NameFunction TypeCallsTotal Time% TimeTime Plot
...riable>readTextSpreadsheetVariablesubfunction80.014 s74.3%
...ble>readNumericSpreadsheetVariablesubfunction30.002 s13.2%
Self time (built-ins, overhead, etc.)  0.002 s12.5%
Totals  0.018 s100% 
Code Analyzer results
No Code Analyzer messages.
Coverage results
Show coverage for parent directory
Total lines in function25
Non-code lines (comments, blank lines)8
Code lines (lines that can run)17
Code lines that did run7
Code lines that did not run10
Coverage (did run/can run)41.18 %
Function listing
time 
Calls 
 line
   1 
function [var,errid,placeholder] = readSpreadsheetVariable(type,varopts,sheet,subrange,typeIDs)
   2 
%read a variable based on its type
< 0.001 
     11 
   3
switch type 
< 0.001 
     11 
   4
    case {'double','single','int8','uint8','int16','uint16','int32','uint32','int64','uint64'} 
   5 
        %obj = matlab.io.NumericVariableImportOptions('Type',newType);
  0.003 
      3 
   6
        [var,errid,placeholder] = readNumericSpreadsheetVariable(varopts,sheet,subrange,typeIDs); 
< 0.001 
      8 
   7
    case {'char','string'} 
   8 
        %obj = matlab.io.TextVariableImportOptions('Type',newType);
  0.015 
      8 
   9
        [var,errid,placeholder] = readTextSpreadsheetVariable(varopts,sheet,subrange,typeIDs); 
  10 
    case 'datetime'
  11 
        %obj = matlab.io.DatetimeVariableImportOptions();
  12 
        [var,errid,placeholder] = readDatetimeSpreadsheetVariable(varopts,sheet,subrange,typeIDs);
  13 
    case 'duration'
  14 
        %obj = matlab.io.DurationVariableImportOptions();
  15 
        [var,errid,placeholder] = readDurationSpreadsheetVariable(varopts,sheet,subrange,typeIDs);
  16 
    case 'categorical'
  17 
        %obj = matlab.io.CategoricalVariableImportOptions();
  18 
        [var,errid,placeholder] = readCategoricalSpreadsheetVariable(varopts,sheet,subrange,typeIDs);
  19 
    case 'logical'
  20 
        %obj = matlab.io.LogicalVariableImportOptions();
  21 
        [var,errid,placeholder] = readLogicalSpreadsheetVariable(varopts,sheet,subrange,typeIDs);
  22 
    otherwise
  23 
        assert(false);
< 0.001 
     11 
  24
end 
< 0.001 
     11 
  25
end 

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