Is it possible to have first column as headers in excel


#1

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.

Thanks


#2

Hi,

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.

Regards,
Amit