Creating column dynamically in excel template

Ambily-Oracle

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>

Yogen

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.

Ambily-Oracle

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

Thank you, Will try out.

Yogen

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