CA Service Management

  • Private Community

  • 1.  Query Results into an Excel

    Posted Jan 30, 2017 04:38 AM

    Hi Team,

     

    can we export  "select from database" operator query results into an excel in ITPAM  workflow? 

     

    Regards,

    santoshi.P



  • 2.  Re: Query Results into an Excel

    Posted Jan 30, 2017 11:22 AM

    Not sure if there is an easier way but one option may be to pass the results of the select operator to a Java class (using Invoke Java operator). Quick search yielded the following which may help:

     

    POI-HSSF and POI-XSSF - Java API To Access Microsoft Excel Format Files 

    Apache POI – Reading and Writing Excel file in Java