I'm trying to generate a report in Excel format. My requirement is that the report needs to start at a fixed row and column (say ``C9'') and it should retain whatever existed originally in the template before the row on which output begins. Is there any way to do this?

Thanks!

This message has been edited. Last edited by: Kerry,

Check out Excel templates in the documentation

Can you please point me to any available in online documentation?

Thanks!

The doc link is in the upper right corner of this page.

Unfortunately, I can't find anything for my case. Basically what I want to find out is - can I control what {row,column} output gets printed on?

Thanks!

To move the report content down x rows have x lines in your header. To move it y columns to the right have y empty fields in your output. Open your mind to what you want to do and it will become obvious how to achieve it.

As for leaving current content untouched then Darin has already given you a pointer to your solution, excel templates.

Understand that in a template file, if you target sheet number 2 (for instance) then that sheet is "deleted" and your report is created in that location (as a new sheet essentially) so you should see why existing content gets wiped out.

T

In addition, the Excel template's sheet 1 is the one that should have the existing data on. Cells in sheet 1 can refer to cells in sheet 2 - this is the way you get the WebFOCUS data in sheet 2 to display in sheet 1 - the one the user will use. There is a method to suppress the sheet tabs so that the user doesn't know that there are multiple sheets, but I don't like using that.

Documentation on Excel Templates:
Creating Reports With Graphical Tools > Styling Reports With the Report Painter > Using Excel Templates

Creating Reports With WebFOCUS Language > Choosing a Display Format > Using Excel Display Formats: Excel 2000, Excel 97, Excel > Creating Excel Templates

How to hide the worksheet tabs in EXL2K Template output?

+1 for Line 1! I think I can figure out what needs to be done now.

Thanks a lot!

Give a man a fish and he'll eat well for one day.

Give him a boat and rod ......

You know the rest

T