Oi, 

Isso pode ser o último pra mim.

Eu gostaria de adicionar um cabeçalho na primeira linha no arquivo, como faço?

Uhm,

Can you write in English ? I'm using translate app for this.

If I not mistaken the translation, and you using advance excel plugin, then you need to use "Row_Insert" action from the advance excel plugin.

Then put this on the property (it will insert 1 row at the first row)

Then this cell_merge (will merge the first row, column 1 to 10)

Last is cell_write to write the content as in the properties

Clear.

actually I'm using "Download" which downloads in excel for me.

and I would like to add a header to the first line, which would appear every time I download.

how it appears when downloading:

how I want it to appear (when adding the first line):

Hi,

Basically the same thing, but adding after action "GetReportBinary" with advance excel action 

You can achieve this from the solution I have shared. Let us know if you need more clarification

Hi Manish,

Good day.

I have tried to use your solution, however, I'm having a problem with how can I execute the dynamic header.

Can you help with how can I execute it?

Can you tell me the logic of Date and Total Number there - 

1. Is it today's date and total number of records of today?
2. Did you select on Date in Web and add that as header with total records that day?

I hope my question is clear to you with above two scenario. I want to understand about the logic of data and count.

Thanks

The date is dynamic also, meaning the date will be based be on the table rows, not the date today specific.

the total number will be counted as the total sum.

So, let's say if table has 10 rows where 5 rows are of 25-05-2021 and 5 rows of 24-05-2021

Now you are exporting that data. How would you like to get the data? Something like this as below with different headers in single file???

Header Row 25-05-2021 || 5 

Data Row 1

Data Row 2

Data Row 3

Data Row 4

Data Row 5

Header Row 24-05-2021 || 5

Data Row 1

Data Row 2

Data Row 3

Data Row 4

Data Row 5

Yes, but instead of 5 it will be 15. is it possible or do I need to use an extension for this?

5 was Just the example numbers. You can do with any numbers. No issues. 

Here in my opinion you will need to use the 2 Aggregates. 

1) Let's create the copy of data aggregate and Groupby Date and Add count() attribute - For Date and Count

2) The Existing Aggregate for the Data

Create one Sort in both (Datewise) to keep accuracy in data setting. 

Then in the DATA when you are assigning the value to print - 

1. Take Date and Count from New Aggregate 
2. Then take data from 2nd aggregate where Data = Date taken from new one
3. Make it in loop
4. Download the file. 

Hope it is clear, thanks