Write Heading in excel

[sasmitakumari]

Since in my example I have kept all headers in a single string with comma separated , I had used Split function to get individual header. Now you should omit that line...
Ex: If your array name is "sHeaderArray" then...
*** Writing Header***'

Code:

i = 0
For Each sHeader in sHeaderArray
i = i + 1
ExcelSheet.ActiveSheet.Cells(1, i).Value = sHeader
Next