Export CDT to Excel Smart Service

Thanks Josh.

what is the solution for this issue ?
does that smart service (Export CDT to Excel) need to be enhanced ?

Or.. do I need to create a wrapper smart service to take input as exported excel document and re-create formatted document something like below ?

Now modify the workbook with POI:
Workbook wb = WorkbookFactory.create(new FileInputStream("workbook.xls"));

Sheet sh = wb.getSheetAt(0);
sh.getRow(0).getCell(0).setCellValue(2); // set A1=2

FileOutputStream out = new FileOutputStream("workbook2.xls");
wb.write(out);
out.close();


Thx

Thanks Josh.

what is the solution for this issue ?
does that smart service (Export CDT to Excel) need to be enhanced ?

Or.. do I need to create a wrapper smart service to take input as exported excel document and re-create formatted document something like below ?

Now modify the workbook with POI:
Workbook wb = WorkbookFactory.create(new FileInputStream("workbook.xls"));

Sheet sh = wb.getSheetAt(0);
sh.getRow(0).getCell(0).setCellValue(2); // set A1=2

FileOutputStream out = new FileOutputStream("workbook2.xls");
wb.write(out);
out.close();


Thx

My recommendation is to enhance the existing smart service. You can do so by requesting to update the component here: forum.appian.com/.../actions

we had tried downloading latest 1.9.5 version today and got it installed and we are getting below error

2018-04-26 13:44:40,727 [Appian Work Item - 4874 - ProcessExec00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=122, classname=com.appiancorp.ps.exceltools.smartservice.export.ExportCdtToExcelv2
java.lang.NullPointerException

Can someone provide with alternative plugin that can "Trigger a reevaluation of all formulas in the workbook after writing all data "