Generate Custom Excel file with dynamic columns

Hi Community

we need to generate a custom excel file but excel reports will not be enough.

Our case, we have a "Article" object, that has a "Category"

and depending on the "Category", this article has certain "ArticleRequirements".

We need to generate and excel file that will have a column header per each "ArticleRequirements"

The "ArticleRequirements" also have a classification A,B and C and ideally I need to separate them into 3 different sheets.

This means that the excel for each article can have a different number of columns.

 

Ex Excel for Product A:

 

Excel for product B:

anyone had a similar case? and any suggestions on how to approach this challenge? 

Some libraries that can be used by Creatio to achieve this?

Thanks

Luis

 

Like 1

Like

0 comments
Show all comments