can we generate the excels in xlsx format in PEGA 5.5?
Currently we are using xls format to generate the excels. we got a requirement to generate the excels in xlsx format instead of xls. we are using the PEGA 5.5. we need to know whether PEGA 5.5 will support xlsx format or not.
Pegasystems
IN
Accenture
IN
Thanks Rajiv.. can you please advise whether any alternative way available to have the excels in .xlsx format without upgrading to PEGA 6 or 7.
Pegasystems
IN
I was suggesting you to directly import these libraries in your 5.5 environment. My intention of its availability in 6.1 GA onwards was for you reference so that you are aware that this is the technology that we use internally for excel parsing (specially will full text indexing of attachments).
cognizant
US
can u please tell how are you generating xls format in 5.x version because we need to generate xls formated excel file
You might want to use Apache POI 3rd party libraries to do this - https://poi.apache.org/spreadsheet/. Note that these APIs are available in the Pega platform from 6.1 GA onwards.