Simplest thing would be you can have two dataset one returns header value and the other dataset return the coulmns

I have used the above expression but it gives error some times if the date is in American format.

So am using now dateadd("d",-1,dateserial(year(Today),month(Today),1))

Yes, In short, if i use preformated excel file as destination to export data, i get a empty row i.e. row 2

between the header and data.I would like to remove...

It seems that you are pointing to delete the record from the SQL table and then populate the excel again. I have already tried this and it does not work....

Sorry for short description.

I got a pre-formated excel sheet as destination. The header is formatted with color.

The requirement is to populate the excel sheet with different data type (name(string), no...

yep the client can ping the server machine