Is it possible to have first column as headers in excel

Hi Team,

We have to write output data to excel and since it will involve iteration as well, we will have to write each customer detail in a separate sheet. For this we will have to use 1st column as headers instead of Horizontal, so that values can be inserted row wise instead of column-wise. Is it possible to dynamically add sheets to existing excel and to have 1st column as header via Community Edition.



No the same is not possible. Using excel loop activity you will be able to write data in same row which is currently in context of the iteration undergoing.