Excel Template - Column type question
Report format: Excel Template
We were asked by Oracle to use Excel Template in order to output Microsoft Excel reports. The Excel templates are designed in such a way that each mapped column refers to a tag in the XML.This works fine as long as we define each column to be either text or currency. We have also designed a Excel template called Custom Excel template, which can handle dynamic number of XML tags.
The issue is we don’t know which column holds text data and which column holds currency/numeric data. In the custom template all of our columns are formatted as text and left justified. This is causing issues because even currency columns are showing as text. Is there anyway Oracle has any solution such as if an attribute passed in the XML and the template can read that attribute and format accordingly. I know this is possible using Excel Macros, but we can’t use Macros for security reasons