I need to export an internal table to an Excel 2007 spreadsheet using abap. The report is a scheduled report run in background. All I need formatted are the column names which are in bold. What would be the best way to achieve this? Code example would be helpful.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.