{"id":100,"date":"2025-02-24T17:36:50","date_gmt":"2025-02-24T17:36:50","guid":{"rendered":"https:\/\/infotechville.com\/blog\/?p=100"},"modified":"2025-02-24T17:36:51","modified_gmt":"2025-02-24T17:36:51","slug":"how-to-customize-exported-data-in-xlsx-file","status":"publish","type":"post","link":"https:\/\/infotechville.com\/blog\/index.php\/2025\/02\/24\/how-to-customize-exported-data-in-xlsx-file\/","title":{"rendered":"How to customize exported data in XLSX file."},"content":{"rendered":"\n

This example is based on the Java and JavaServer Faces (JSF) with PrimeFaces component library tech stack, but it can also be used with other frameworks.<\/p>\n\n\n\n

A problem description.<\/strong><\/p>\n\n\n\n

There are some cases with table data exporting when exported tables contain unexpected values. Or the values need to be updated under certain conditions. Or if we need extra columns\/data to combine different UI views in one exported table. There are few examples below.<\/p>\n\n\n\n

Primefaces dataExporter is used to export data. A standard configuration looks like<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

and it gives us a table which was configured accordingly<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Let\u2019s export the data (by clicking the XLSX icon at the top right corner) and see what is in the exported file.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

As we can see there is the first column, which is a checkbox mark in the UI table, is shown like a Java object with text \u2018javax.faces.component.UIPanel@3e45c1ea<\/em>\u2018. Let\u2019s consider it the first thing to customize in the exported file. Probably, we want to see it like \u2018Selected\u2019 in the header.<\/p>\n\n\n\n

Also, there is the last column, which is a button in the UI table, is just empty string (\u201c\u201d) in the header. We don\u2019t need it in the file at all. Let\u2019s consider it the second thing to customize in the exported file.<\/p>\n\n\n\n

Now let\u2019s check values in the exported file.<\/p>\n\n\n\n

The first column\u2019s value is \u201cfalse\u201d (or \u201ctrue\u201d when it\u2019s selected in the UI table). It\u2019s not a very \u2018user-friendly\u2019 message, somebody would like to see it like \u201cSelected\u201d or \u201cUnselected\u201d. It would be the third thing to customize in the exported file.<\/p>\n\n\n\n

The \u2018Status\u2019 column and the right column with the blue button also have unreadable messages. These values are text versions of Java objects, and additionally hower text for those columns accordingly. Even if we needed an explanation of the column values we would want them to be present in a more readable format. In this case, we just remove the extra text and update the values.<\/p>\n\n\n\n

So, that is what the problem is, and below is a solution.<\/p>\n\n\n\n

A solution.<\/strong><\/p>\n\n\n\n

To customize the exported file we should catch it before downloading and update it. We use Primefaces attribute \u2018postProcessor<\/mark><\/em>\u2018.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Then we update the file in Java code so it will be customized before downloading. Let\u2019s see the code itself.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

The updated exported file:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

As we can see the values had been updated and the updated file was downloaded.<\/p>\n\n\n\n

The same approach can be used to add more columns (values) to xlsx files or other file types where text values need to be updated.<\/p>\n\n\n\n

\n\n\n\n

If you need help with solutions for data analysis and\/or any solutions for data management, please contact me sergiitechinfo@gmail.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This example is based on the Java and JavaServer Faces (JSF) with PrimeFaces component library tech stack, but it can also be used with other…<\/p>\n

Read moreHow to customize exported data in XLSX file.<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-100","post","type-post","status-publish","format-standard","hentry","category-java-programming","entry"],"_links":{"self":[{"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=100"}],"version-history":[{"count":8,"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":118,"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/100\/revisions\/118"}],"wp:attachment":[{"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infotechville.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}