Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
72:custom_reports_accessing_data_reading_msexcel [2019/02/27 19:02] – ext-bkkr | 72:custom_reports_accessing_data_reading_msexcel [2019/10/04 06:59] – cgl | ||
---|---|---|---|
Line 16: | Line 16: | ||
4. Copy the example and the POI Javascript wrapper function into the Data Collection script editor of the Data Set. | 4. Copy the example and the POI Javascript wrapper function into the Data Collection script editor of the Data Set. | ||
- | 5. Include a Current metric like [[[Software Project: | + | 5. Include a Current metric like [[:software_project: |
6. Click on the Data Set on **Preview Results** | 6. Click on the Data Set on **Preview Results** | ||
- | **Exampe | + | **Exampel |
< | < | ||
function dumpValues(file) { | function dumpValues(file) { | ||
if (file !=null) { | if (file !=null) { | ||
var wb = new WorkbookFactory.create(file); | var wb = new WorkbookFactory.create(file); | ||
- | // var sheet = wb.getSheetAt(0); | ||
var sheet = wb.getSheet(" | var sheet = wb.getSheet(" | ||
for (myrow = 1; !isCellEmpty(sheet, | for (myrow = 1; !isCellEmpty(sheet, | ||
Line 38: | Line 37: | ||
var ArtifactName = "Excel Metric Example"; | var ArtifactName = "Excel Metric Example"; | ||
var ArtifactInstanceName = " | var ArtifactInstanceName = " | ||
- | var process = | + | var process = stages.getCurrentProcess(); |
- | pkit.getCurrentProject().getEntities(" | + | var artifacts = process.getEntities(" |
- | if (process.length !=0 ) { | + | for each (artifact in artifacts) { |
- | var artifacts = process[0].getEntities(" | + | |
- | for each (artifact in artifacts) { | + | |
if (artifact.getProperty(" | if (artifact.getProperty(" | ||
var artifacts_instances = | var artifacts_instances = | ||
Line 53: | Line 50: | ||
} | } | ||
} | } | ||
- | } | + | } |
- | } | + | |
} | } | ||
</ | </ |