[Advanced Excel] How to use Cell_WriteRange() ?

Hi everyone, i'm trying to use the action "Cell_WriteRange" from the "Advanced Excel" module and i cant make it works.


When i open my exported excel file, the action wrote "False" in each cells of the choosen range


If anyone has any ideas to help me ! 

Hi Lucas

Make sure that you pass in a Record List and not just a normal list for the data parameter.

Solution

Hi Lucas, 

The way the method WriteRange is written, it demands that its DataSet parameter be a List of Records of a Structure. That is, it won't work if the record list you use as parameter is defined in a local variable, or even an aggregate result set.

You need to define the Structure in your project and your local variable must be of that structure type.

I've attached an example to this post.

Solution

HI João,

Thanks to your example, I found my problem !

It helped me a lot !

Best regards

João Melo wrote:

Hi Lucas, 

The way the method WriteRange is written, it demands that its DataSet parameter be a List of Records of a Structure. That is, it won't work if the record list you use as parameter is defined in a local variable, or even an aggregate result set.

You need to define the Structure in your project and your local variable must be of that structure type.

I've attached an example to this post.

HI João,

thanks for the OML. i am using OutSystem version 9, and i tried using the Advanced Excel however i have an issue getting the headers out in the excel. i know in v10 there are additional method to cater for this. 

below are the methods i have for v10, 


could you kindly share with me some ideas on how to achieve this ? please


Thanks,

Best Regards,

Hitesh