Add title for column in Excel

[Banu]

Hi All,

I have been working on converting collection into Excel.

But i need title for each column in excel when i create excel. And i don't know how to achieve it.

Can anyone help me to resolve it?

 

[Sukesh Kumaru]

Hello,

Scenario-1:
Make sure to read the excel data including column names from excel file into collection.

Scenario-2:
You manually create column names in excel file and use write collection action by using the cell reference as "A2" (as first row has column names, write to the same excel file by opening it using MS Excel VBO).

Good Luck.