Is it possible to create a formatted text file from Excel work book?

By stating "formatted", I mean that the output file should be having a
pagewise report header, column headings etc. Like those reports which we
generate using COBOL, Dbase etc.

Regards,
Ramana Murthy