Number columns are in text format in Excel export

Ante Obradović

Hi, when our users export the data from Business Intelligence Publisher report to Excel, they want to perform additional analyses. Hence, they need to perform calculations on number columns, but the columns are in text format and when the user tags a couple of Excel cells, they only count, the average and sum are not calculated (this is a good way of checking the cell format).

There is a function in Excel (NUMBERVALUE) which can be used to convert the data into numbers, and it works, but we need more permanent solution for the users.

Nathan CCC

Hi,

If you build your template as an excel template, rather than other type of template such as RTF or online layout editor, then you can make it so that column in your excel output is data type number not text.

See

Oracle® Fusion Middleware

Report Designer's Guide for Oracle Business Intelligence Publisher

12c (12.2.1.3.0)

E80602-02

September 2017

Creating Excel Templates

https://docs.oracle.com/middleware/12213/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#BIPRD2744

Ante Obradović

Hi Nathan,

we did as you instructed, we created an Excel template and uploaded it to a new report and now it downloads as numeric data which is calculable.

Thank you for your help!

Ante