My Oracle Support Banner

How To Dynamically Show or Hide a Sheet in an Excel Template According to the Value of a Field. (Doc ID 2659509.1)

Last updated on APRIL 14, 2020

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 and later
Information in this document applies to any platform.


How to dynamically show or hide a sheet in an excel template according to the value of a field.

for example if parameter P_BOTON_COMPAR = '1' SHOW the sheets called "Comparative" and "Graph.Comparatives". On the contrary, if the value of the parameter P_BOTON_COMPAR = '0' HIDE the sheets


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.