Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Force apex_data_export to format Excel columns as 'text'

Jon Dixon11 hours ago

I am using apex_data_export to build an Excel Export, which will be downloaded, changes made, and re-uploaded using apex_data_parser.

I cannot find a way to force apex_data_export to format columns as text so that leading zeros are not lost for values like 0004.

Is this possible with apex_data_export?

It looks like you can apply Oracle Format Strings to the output, but this does not help because the values are VARCHARs (e.g., 0004, 2338, 0006, ABCDEF).

Comments
Post Details
Added 11 hours ago
1 comment
35 views