1 package org
.argeo
.slc
.web
.mvc
.result
;
5 import javax
.servlet
.http
.HttpServletRequest
;
6 import javax
.servlet
.http
.HttpServletResponse
;
8 import jxl
.write
.Label
;
9 import jxl
.write
.WritableSheet
;
10 import jxl
.write
.WritableWorkbook
;
12 import org
.argeo
.slc
.SlcException
;
13 import org
.argeo
.slc
.core
.structure
.tree
.TreeSPath
;
14 import org
.argeo
.slc
.core
.test
.SlcTestUtils
;
15 import org
.argeo
.slc
.core
.test
.tree
.PartSubList
;
16 import org
.argeo
.slc
.core
.test
.tree
.TreeTestResult
;
17 import org
.argeo
.slc
.test
.TestResultPart
;
18 import org
.springframework
.web
.servlet
.view
.document
.AbstractJExcelView
;
20 public class ResultExcelView
extends AbstractJExcelView
{
21 protected void buildExcelDocument(Map model
, WritableWorkbook workbook
,
22 HttpServletRequest request
, HttpServletResponse response
) {
24 if (workbook
.getNumberOfSheets() == 0) {
25 workbook
.createSheet("SLC", 0);
27 WritableSheet sheet
= workbook
.getSheet("SLC");
29 TreeTestResult ttr
= (TreeTestResult
) model
30 .get(GetResultController
.MODELKEY_RESULT
);
32 sheet
.addCell(new Label(0, 0, "Result " + ttr
.getUuid()));
35 for (TreeSPath path
: ttr
.getResultParts().keySet()) {
36 PartSubList lst
= ttr
.getResultParts().get(path
);
37 sheet
.addCell(new Label(0, currentRow
, "Path " + path
));
39 for (TestResultPart part
: lst
.getParts()) {
40 sheet
.addCell(new Label(0, currentRow
, SlcTestUtils
41 .statusToString(part
.getStatus())));
42 sheet
.addCell(new Label(1, currentRow
, part
.getMessage()));
45 currentRow
++;// add an empty line between paths
47 } catch (Exception e
) {
48 throw new SlcException("Could not write spreadsheet.", e
);