Creating column dynamically in excel template

Question

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. English 90 Maths 90

Ambily-Oracle · Answer

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?

Ambily-Oracle · Answer

Thank you, Will try out.

Yogen · Answer

Nothing that I know. As per my knowledge upload it and run the report.