This is a static copy of a profile report

Home

DetectImportOptionsSpreadsheet>DetectImportOptionsSpreadsheet.getRangeFromUsedRange (Calls: 2, Time: 0.002 s)
Generated 04-Jun-2021 04:11:09 using performance time.
class method in file C:\Program Files\MATLAB\R2020b\toolbox\matlab\io\spreadsheet\+matlab\+io\+internal\+functions\DetectImportOptionsSpreadsheet.m
Copy to new window for comparing multiple runs

Parents (calling functions)

Function NameFunction TypeCalls
...rtOptionsSpreadsheet.getOptsFromSheetclass method2
Lines where the most time was spent

Line NumberCodeCallsTotal Time% TimeTime Plot
242
typeIDs = sheet.types(rangeToU...
20.000 s21.9%
235
rangeToUse = sheet.getRange(ra...
20.000 s13.1%
243
rangeStr = sheet.getRange(rang...
20.000 s13.1%
227
rangeStr = sheet.getDataSpan;
20.000 s10.4%
220
sheet = func.WorkSheet.SheetOb...
20.000 s9.7%
All other lines  0.001 s31.8%
Totals  0.002 s100% 
Children (called functions)
No children
Code Analyzer results
No Code Analyzer messages.
Coverage results
Show coverage for parent directory
Total lines in function27
Non-code lines (comments, blank lines)3
Code lines (lines that can run)24
Code lines that did run18
Code lines that did not run6
Coverage (did run/can run)75.00 %
Function listing
time 
Calls 
 line
 219 
        function [rangeToUse,bindRanges,rangeStr,typeIDs] = getRangeFromUsedRange(func)
< 0.001 
      2 
 220
            sheet = func.WorkSheet.SheetObj; 
< 0.001 
      2 
 221
            bindRanges = [false false]; 
< 0.001 
      2 
 222
            comObject = func.WorkSheet.IsComObject; 
< 0.001 
      2 
 223
            if(comObject) 
 224 
                [rangeStr,typeIDs] = matlab.io.spreadsheet.internal.usedDataRange(sheet);
 225 
                typeIDs(251:end,:) = [];
      2 
 226
            else 
< 0.001 
      2 
 227
                rangeStr = sheet.getDataSpan; 
 228 
                % need to limit number of rows here!
< 0.001 
      2 
 229
            end 
< 0.001 
      2 
 230
            if isempty(rangeStr) 
 231 
                typeIDs = uint8([]);
 232 
                rangeToUse = [];
 233 
                return
< 0.001 
      2 
 234
            else 
< 0.001 
      2 
 235
                rangeToUse = sheet.getRange(rangeStr, false); 
< 0.001 
      2 
 236
            end 
 237 
            
< 0.001 
      2 
 238
            if(length(rangeToUse) == 4 && (rangeToUse(3) - rangeToUse(1)) > 250) 
 239 
                rangeToUse(3) = rangeToUse(1) + 250 -1;
< 0.001 
      2 
 240
            end 
< 0.001 
      2 
 241
            if(~comObject) 
< 0.001 
      2 
 242
                typeIDs = sheet.types(rangeToUse); 
< 0.001 
      2 
 243
                rangeStr = sheet.getRange(rangeToUse); 
< 0.001 
      2 
 244
            end 
< 0.001 
      2 
 245
        end 

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