Skip to Content (Press Enter)
UserImage.jpg
Lucas Leveau
1698Views
4Comments
Solved
[Advanced Excel] How to use Cell_WriteRange() ? 
Question
Component
Usability

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 ! 

0
0
17 May 2019
Copy Link
2023-02-10 19-42-59
João Melo
 
MVP
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.

See solution in context
AdvancedExcelSample.oml
5
0
19 May 2019
Copy Link
UserImage.jpg
Hitesh Vasnani

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

0
0
25 Sep 2019
Copy Link
2025-09-25 22-50-38
Hanno

Hi Lucas

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

1
0
18 May 2019
Copy Link
2023-02-10 19-42-59
João Melo
 
MVP
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.

AdvancedExcelSample.oml
5
0
19 May 2019
Copy Link
UserImage.jpg
Hitesh Vasnani

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

0
0
25 Sep 2019
Copy Link
UserImage.jpg
Lucas Leveau

HI João,

Thanks to your example, I found my problem !

It helped me a lot !

Best regards

0
0
20 May 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.