This is a static copy of a profile report

Home

createWorkbook>constructWorkbook (Calls: 2, Time: 0.008 s)
Generated 04-Jun-2021 04:11:08 using performance time.
subfunction in file C:\Program Files\MATLAB\R2020b\toolbox\shared\spreadsheet\+matlab\+io\+spreadsheet\+internal\createWorkbook.m
Copy to new window for comparing multiple runs

Parents (calling functions)

Function NameFunction TypeCalls
createWorkbookfunction2
Lines where the most time was spent

Line NumberCodeCallsTotal Time% TimeTime Plot
131
book = matlab.io.spreadsheet.i...
20.007 s93.0%
134
if any(ismissing(book.SheetNam...
20.000 s2.2%
139
end
20.000 s1.6%
144
end
20.000 s0.0%
132
try
20.000 s0.0%
All other lines  0.000 s3.1%
Totals  0.008 s100% 
Children (called functions)
No children
Code Analyzer results
No Code Analyzer messages.
Coverage results
Show coverage for parent directory
Total lines in function20
Non-code lines (comments, blank lines)5
Code lines (lines that can run)15
Code lines that did run10
Code lines that did not run5
Coverage (did run/can run)66.67 %
Function listing
time 
Calls 
 line
 125 
function book = constructWorkbook(format, filename, tryInterop, sheet, sheetNamesOnly)
< 0.001 
      2 
 126
    if sheetNamesOnly 
 127 
        book = matlab.io.spreadsheet.internal.Workbook(format, filename, false, 0, true);
< 0.001 
      2 
 128
    elseif isempty(sheet) 
 129 
        book = matlab.io.spreadsheet.internal.Workbook(format, filename, tryInterop);
< 0.001 
      2 
 130
    else 
  0.007 
      2 
 131
        book = matlab.io.spreadsheet.internal.Workbook(format, filename, false, sheet); 
< 0.001 
      2 
 132
        try 
 133 
            % for chart sheets, SheetNames is not a property on the workbook
< 0.001 
      2 
 134
            if any(ismissing(book.SheetNames)) 
 135 
                % this could happen with hidden sheets in the workbook that
 136 
                % could cause only the hidden sheet to be loaded and all other
 137 
                % sheets are missing
 138 
                book = matlab.io.spreadsheet.internal.Workbook(format, filename, tryInterop);
< 0.001 
      2 
 139
            end 
 140 
        catch ME
 141 
            throw(ME);
< 0.001 
      2 
 142
        end 
      2 
 143
    end 
< 0.001 
      2 
 144
end 

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