Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to conditionally display/not display columns in Excel template?
Summary
How to conditionally display/not display columns in Excel template?
Content
I have one sheet on my XSL template that has a table with 3 columns and I'm looping through the XML and display 1 or more sheets based on data in the xml.
For example, let's say the xml has three nodes that have the below values.
- Open
- Closed
- Pending
I'm looping through these three nodes and create an xsl output that eventually will have three sheets,Open, Closed and Pending
My requirement is for the Closed sheet, I want to add 2 more columns to the table so it will have 5 columns. Open and Pending still have only 3 columns. How do I do it in the xls template?
Thanks
Answers
-
In my example, I use three xml nodes but that number is dynamic. It could have 6-7 nodes in the xml therefore I'll have 6-7 sheets in the output. Only the Closed sheet will have 5 columns in the table. The rest will have only 3 column.
So there's no way to be able to put in some kind of conditional statement? Something like
If the sheet is Closed then display the additional 2 columns.
Something simple as that?
0 -
My suggestion is build template in 3 sheets in same .xls, I am not sure how your .xml data is.?
0