How to keep leading zeros in excel ; Export to Excel ADF

Add 2 outputtexts to the table column

  <af:column width="10%" sortProperty="#{bindings.ExampleVO11.hints.Attribute1.name}"
                                   filterable="true" sortable="true" headerText="InterCompany" id="c33">
                                         <af:outputText value='=" ' inlineStyle="display:none" id="ot14"/>
                            <af:outputFormatted value="#{row.bindings.Attribute1.inputValue}"
                                                shortDesc="#{bindings.ExampleVO11.hints.Attribute1.tooltip}"
                                                id="it32"/>
                            <af:outputText value='"' inlineStyle="display:none" id="ot15"/>
                        </af:column>

Reference : https://flexagon.com/2015/08/adf-export-excel-tweakingchanging-output-for-exported-excel-to-avoid-scientific-formats/

Export to Excel Java

http://thinktibits.blogspot.com/2012/12/Excel-Multiple-Conditional-Formatting-Rules-Java-POI-Example-Program.html

https://examples.javacodegeeks.com/core-java/writeread-excel-files-in-java-example/

http://thinktibits.blogspot.com/2014/08/apache-poi-freeze-pane-excel-java.html

ADF:

https://drive.google.com/file/d/1m1bvkrEF4qOr9ZCn1UVMaK1HLyWqorwR/view?usp=sharing

Export to Excel (customize the look and feel of the text in Excel) ADF

Create a button -> Add File Download Listener to it (mention the name of file; content type of file; define the method  in backing bean)

// method


// sample page example

// paint the file however you like by iterating through the rows
http://www.techartifact.com/blogs/2013/08/generate-excel-file-in-oracle-adf-using-apache-poi.html#sthash.ex7znOTY.dpbs

Sample code:

https://drive.google.com/file/d/1m1bvkrEF4qOr9ZCn1UVMaK1HLyWqorwR/view?usp=sharing