Captions in OutPut File

[janardhan]

Hi Friends,

while exporting I need a caption in output xls file .

for example:

Transportation Report
Covering Transportation Date from
Report  Generated on
Route ( Header)                                                          Date ( Header)
111                                                                            13/02/2013
222                                                                            14/02/2013

Like this i need to Output file.

Please help me out.

Thanks in Advance

Janardhan

[janardhan]

Hi Friends ,

Please find the below attached xls sheet Output file.

I need like this.

[Gysbert_Wassenaar]

That's not possible unless you use a macro to export to excel. See here for a such a macro.

[janardhan]

Hi Gysbert,

Its not possible without using Macro...