Want to add header on exported excel

[Jeeru_venkat_Rao]

Hi Friends,

When I data scrapping I don’t get headers in excel, it shows like- Column0, Column1 etc.
But I want header names.

Below screenshot is datascrapping data:-

Want headers like this:-

Can we store this header somewhere and paste it all the time after that download or any other approaches.

Please help.

[Yoichi]

Hi,

Can you try a the following?

Note : arrColumnName is String array type.

Regards,

[Jeeru_venkat_Rao]

I tried it but nothing happens. Should I use any other activity after this loop?

[Yoichi]

Hi

How did you check it? It’s necessary to add breakpoint then check it at Locals panel OR write into xlsx ,for example.

Regards,

[ashokkarale]

@Jeeru_venkat_Rao,

I would suggest to change it at Table Extraction wizard it self.

Click on the settings icon on each column and change the desired name.

Thanks,
Ashok

[Jeeru_venkat_Rao]

@ashokkarale Thank you bro, this is something which I am looking for.

Kudos to you.

[Jeeru_venkat_Rao]

Thank you @Yoichi bro.

I will try this one as well.
Really appreciate for your quick response.

[Jeeru_venkat_Rao]

Guys, I have one more query.

I want 5 months start and end date.
For eg. Start date - 01/03/2024 End date 31/03/2024.

I used below code but start date is wrong appears
Today.AddMonths(-5).AddDays(-cint(DateTime.now.ToString(“dd”))-1)

Can someone suggest

[ashokkarale]

@Jeeru_venkat_Rao,

Kindly keep one query one thread to have clear knowledge for community.

Thanks,
Ashok

[ashokkarale]

@Jeeru_venkat_Rao,

Create new thread meanwhile I’m looking into it.

[Jeeru_venkat_Rao]

Sure bro, I will new query for this