Skip to main content
Question

Hello everybody. I'm trying to create an action flow that generates an excel report in xlsx format that allows formatting headers and is able to generate a large volume of data. Does anyone have a solution?

  • November 10, 2022
  • 1 reply
  • 1 view

jorge.fonse12
Level 3

Currently we are using the csv module to generate the report, however it does not allow formatting of numbers and headers. We also tried to use the excel 365 module but it only allows inserting information row by row which does not allow generating a large volume of data.

 

abhishek.chatu14
Level 7
Forum|alt.badge.img+4

Hi Jorge,

 

Unfortunately the best option is to use the advance CSV module for all your excel report related formatting , and currently its difficult for action flow to handle  large volumes of data. In my testing max 5000-6000 rows can be used to successful operations. The number may differ for you but I haven't seen any better solution for the same. Hoping for Celonis to come with some better alternative.


Reply