Hi,
I have created an excel template giving field names,customizing the fonts,background color etc.i just want the data from my fex file to poulate the template.

e.g.,i made the template( taking car,model,country -field names of CAR table) in sheet1 of my workbook,now when i am trying to poulate the template, the entire table is getting printed on sheet1 but the template which i made is getting erased.

Please suggest me how to achieve this.Thanks in advance

You must have a sheet dedicated to the data only, with no Excel styling or special features. You can set up unlimited numbers of additional worksheets in the same workbook that reference the cells of the data worksheet. FYI, there is a project to make the WebFOCUS data worksheet hide-able. We don't know yet what release that will be in.

Diane, WebFOCUS Product Division