Is there any builtin function available to enter header for each sheet on the spreadsheet.I have three sheets on the work book and have to provide heading for those..
Yes. I don't remember the name off hand. But I am sure it is easy to find. Just take a look at the documenation under functions by category / spreadsheet functions.
you can use SpreadsheetSetHeader function.
<cfset spreadsheetSetHeader(SpreadsheetObj,"left header","center header","right header")>