Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 551 Big Data Appliance
- 1.9K Data Science
- 451.3K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 560 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.4K SQL & PL/SQL
- 21.4K SQL Developer
- 296.8K Development
- Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.5K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 165 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 525 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
Export to Excel doesn't shown line break in APEX classic report
Hi ,
APEX version is : 5.0
I have a classic report whose column headers are generated using dynamically. The headers are actually APEX items whose values are determined during report runtime and accordingly the Column headers are generated.
For example : One of the column header is like this : &P30_X1.</br>&P30_X1_UTIL.%
This works fine when the report is rendered in web browser . But when i export the report to Excel , the </br> doesn't seem to work .
Any pointer here ?
Thanks
Answers
-
Hi
If you could convert the classic report to interactive report, this plugin would help you much in formatting the exported Excel. Moreover, it will export it as XLSX.
- Process Type Plugin - (IR) Report to Excel (xlsx)
Please take a look at its demo here
https://apex.oracle.com/pls/apex/f?p=23131:LOGIN::::::
demo/demo
I hope that helps you or solves your problem
Regards
Mahmoud
-
Also check Region2XSLTReport plugin: www.mirmas.si.
Demo: http://apex.mirmas.si/apex/f?p=111:34:
You can modify XSLT that ships with plugin to convert <br> to line break in column header.
-
Because Excel doesn't handle HTML very well.. You could modify the way you build your labels such that if the report is being downloaded versus displayed to use a CHR(10) instead of <br> ..
Thank you,
Tony Miller
Los Alamos, NM -
This suggestion will incur more issues for the poster, since they probably had a reason to use a standard report versus an interactive report..
Thank you,
Tony Miller
Los Alamos, NM -
That's why I said
If you could convert the classic report to interactive report,
Regards
Mahmoud
-
Thanks Tony, i will give it a try
-
Hi Mahmoud,
This is a classic report and the search fields are dynamically created , so converting them to a IR report is difficult .
-
Why should you convert the report? The description says "This plugin uses the source queries of all report regions on a page, either a clasic or interactive"
