Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Creating column dynamically in excel template
Summary
Creating column dynamically in excel template
Content
We are working on a BIP report where we need the output in excel. Here we need to create column at run time depending on data in xml. For example, the xml can have below session . Here we have two subjects, so we create two columns in excel. If XML have 5 subjects, we need to create 5 columns. We achieved the same using split–column in RTF, but since we have limitation of 63 columns in RTF and our report will have huge number columns till 1000, we plan to use excel template. Can anyone please help or suggest is this dynamic creation of column is possible in excel. Any help will be really great.
<SUBJECTS>
<SUBJECT>
<NAME>English</NAME>
<MARK>90</MARK>
</SUBJECT>
<SUBJECT>
<NAME>Maths</NAME>
<MARK>90</MARK>
</SUBJECT>
</SUBJECTS>
Answers
-
Column limitation in RTF can be overcome using XSL-FO template. You can convert RTF teamplate into xsl-fo template. However I am not sure if after converting rtf into xsl-fo column split functionality will still be retained. Please try and share the results if it works.
0 -
I converted the RTF to an XSL-FO template. Is there any way I can verify the excel for same using BI Plugin. I mean, without going through BI server?
0 -
Thank you, Will try out.
0 -
Nothing that I know. As per my knowledge upload it and run the report.
0