DetectImportOptionsSpreadsheet>DetectImportOptionsSpreadsheet.execute (Calls: 2, Time: 0.221 s)
Generated 04-Jun-2021 04:11:08 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
Function Name | Function Type | Calls |
...ptions>DetectImportOptions.execute | class method | 2 |
Line Number | Code | Calls | Total Time | % Time | Time Plot |
38 | [opts,func] = func.getOptsFrom... | 2 | 0.186 s | 84.3% | |
32 | func.WorkSheet.openBook(func.F... | 2 | 0.015 s | 6.6% | |
39 | opts = func.setNonDetectionPro... | 2 | 0.014 s | 6.2% | |
23 | checkWrongParamsWrongType(supp... | 2 | 0.002 s | 1.0% | |
37 | func.WorkSheet.openSheet(func.... | 2 | 0.002 s | 0.9% | |
All other lines | 0.002 s | 1.0% | |||
Totals | 0.221 s | 100% |
Function Name | Function Type | Calls | Total Time | % Time | Time Plot |
...rtOptionsSpreadsheet.getOptsFromSheet | class method | 2 | 0.185 s | 84.0% | |
...Spreadsheet.setNonDetectionProperties | class method | 2 | 0.013 s | 6.0% | |
UsesWorksheet>UsesWorksheet.openBook | class method | 2 | 0.012 s | 5.3% | |
...gt;AcceptsSheetNameOrNumber.get.Sheet | class method | 4 | 0.002 s | 1.1% | |
...eadsheet>checkWrongParamsWrongType | class method | 2 | 0.002 s | 0.9% | |
UsesWorksheet>UsesWorksheet.openSheet | class method | 2 | 0.001 s | 0.3% | |
getExtension | function | 2 | 0.001 s | 0.2% | |
...;AcceptsReadableFilename.get.Filename | class method | 4 | 0.000 s | 0.1% | |
Self time (built-ins, overhead, etc.) | 0.005 s | 2.1% | |||
Totals | 0.221 s | 100% |
Total lines in function | 20 |
Non-code lines (comments, blank lines) | 5 |
Code lines (lines that can run) | 15 |
Code lines that did run | 11 |
Code lines that did not run | 4 |
Coverage (did run/can run) | 73.33 % |
time | Calls | line | |
---|---|---|---|
21 | function opts = execute(func, supplied) | ||
22 | import matlab.io.spreadsheet.internal.*; | ||
0.002 | 2 | 23 | checkWrongParamsWrongType(supplied); |
0.001 | 2 | 24 | fmt = getExtension(func.Filename); |
25 | % On Windows for ODS and XLSB files error when UseExcel is set to false by the user | ||
< 0.001 | 2 | 26 | if(ispc && contains(fmt, {'ods', 'xlsb'}, 'IgnoreCase',true)... |
27 | && isfield(supplied,'UseExcel') && supplied.UseExcel && ~func.UseExcel) | ||
28 | error(message('MATLAB:spreadsheet:book:fileTypeUnsupported', fmt)); | ||
< 0.001 | 2 | 29 | end |
30 | |||
< 0.001 | 2 | 31 | if isfield(supplied,'UseExcel') |
0.015 | 2 | 32 | func.WorkSheet.openBook(func.Filename, func.Sheet, fmt, func.UseExcel); |
33 | else | ||
34 | % detectImportOptions does not have a 'UseExcel' parameter and relies on 'UseExcel' false by default | ||
35 | func.WorkSheet.openBook(func.Filename, func.Sheet, fmt, false); | ||
2 | 36 | end | |
0.002 | 2 | 37 | func.WorkSheet.openSheet(func.Sheet); |
0.186 | 2 | 38 | [opts,func] = func.getOptsFromSheet(supplied); |
0.014 | 2 | 39 | opts = func.setNonDetectionProperties(opts); |
< 0.001 | 2 | 40 | end |
Other subfunctions in this file are not included in this listing.