Hello to All ARIS Experts,
In my current project, we have used "EPC row display" models at L3, L4 & L5. One of the stakeholders wants to have the model graphic along with some attributes for it in excel format. Do we have any Out of Box report available for it.
Also while taking prints of the model, the fist page has the Org Unit in the swimlanes, however the for next pages, it does not show them. Is it possible to print them in such a fashion that it would have the Org Unit printed on each page.
Any pointers for the above would be really helpful.
Thanks
Neeraj
Hi Neeraj,
you should be able to create the complete picture into a single excel sheet. Try it like this:
sFileName = oModel.GUID() + ".png";
sTmpFileName = oModel.GUID() + ".xls";
oTempOut = Context.createOutputObject(Constants.OUTOTHER, sTmpFileName);
oTempOut.Init(g_nLoc[0]);
sTempOutPath = oTempOut.getCurrentPath();
sTempOutPath = Context.getTempPath();
oGfx = oModel.Graphic(true, false, g_nLoc[0]);
gfxWidth = oGfx.getWidth(Constants.SIZE_PIXEL);
gfxHeight = oGfx.getHeight(Constants.SIZE_PIXEL);
oGfx.Save(oTempOut, sFileName);
lMaxRow = new java.Double(gfxHeight / ROW_HEIGHT).intValue();
lMaxCol = new java.Double(gfxWidth / COL_WIDTH).intValue();
diffPixY = new java.Double((gfxHeight - (lMaxRow * ROW_HEIGHT)) * ROW_MAX / ROW_HEIGHT).intValue();
diffPixX = new java.Double((gfxWidth - (lMaxCol * COL_WIDTH)) * COL_MAX / COL_WIDTH).intValue();
oOutSheet[lSheetNo].setPicture(Context.getFile(sFileName, Constants.LOCATION_OUTPUT), lStartCol, lStartRow, lMaxCol + lStartCol, lMaxRow + lStartRow, 0, 0, diffPixX, diffPixY);
BR Robert