Iam looking for a way to hide the data sheet with Excel template. Any idea?
Thank You SandhyaThis message has been edited. Last edited by: Kerry,
October 22, 2012, 04:55 PM
Waz
I think this is part of the setup.
Create the template, and hide the sheet that will receive the data.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 22, 2012, 04:59 PM
Sandhya j
Hi Waz Thanks for the reply. I tried this solution. But it didn't work. Data is getting populated in the sheet (Unhided) where I have the fomulas etc.,
Thanks
October 22, 2012, 05:24 PM
Waz
Did you specify which sheet the data would be written to ?
FORMAT EXL2K TEMPLATE templatename SHEETNUMBER x
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 23, 2012, 11:46 AM
Sandhya j
Waz,
I specified the sheet number.
October 23, 2012, 04:33 PM
Waz
Can you post the code ?
What sheet has the formulas and what is supposed to get the data ?