How to Use Select All box in Interactive Report Oracle Apex

Download Any Report Csv. Xml And Xlsx Files In Oracle Apex

 

The Most Common Solution Is To Convert The Xlsx File Into A Csv Format And Upload Data From The File To The Website Table Using The Pl / Sql Custom Process. This Is A Simple And Proven Method, But Due To Low Flexibility It Is Only Suitable For Uploading Files With A Fixed And Predictable Data Format (Number Of Columns And Their Data Types). In The Event Of Adding A New Column To An Existing File Or Deletion, We Are Forced To Adjust The Upload Process And / Or The Target Table. If We Want To Give The User The Ability To Share Data In The Form Of A Report, We Should Also Keep In Mind About The Apex Application Update.
It Does Not Change The Fact, That There Is A Need To Import Data Directly Into Xlsx Files And Our Customers Will Not Stop Asking For It. So If Necessary, We Should Find A Solution, Right?

Steps To How To Download Any Report Csv, Xml And Xlsx Files.

1. Create A New Page, Name- Download Any Report 

2. Create a Region, Name- All Button Name- All Button
    Type- Static Content
    Source -> HTML Code-

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081<span class="pln">
    </span><span class="pun">&lt;!--</span><span class="pln">DOCTYPE html</span><span class="pun">--&gt;</span><span class="pln">
    </span><span class="str">&lt;html&gt;</span><span class="pln">
    	</span><span class="str">&lt;head&gt;</span><span class="pln">
    		</span><span class="pun">&lt;</span><span class="pln">meta http</span><span class="pun">-</span><span class="pln">equiv</span><span class="pun">=</span><span class="str">"Content-Type"</span><span class="pln"> content</span><span class="pun">=</span><span class="str">"text/html; charset=UTF-8"</span><span class="pun">&gt;</span><span class="pln">
    			</span><span class="str">&lt;title&gt;</span><span class="typ">SheetJS</span><span class="pln"> JS</span><span class="pun">-</span><span class="pln">XLSX </span><span class="typ">In</span><span class="pun">-</span><span class="typ">Browser</span><span class="pln"> HTML </span><span class="typ">Table</span><span class="pln"> </span><span class="typ">Export</span><span class="pln"> </span><span class="typ">Demo</span><span class="pun">&lt;/</span><span class="pln">title</span><span class="pun">&gt;</span><span class="pln">
    			</span><span class="str">&lt;style&gt;</span><span class="pln">
    </span><span class="pun">.</span><span class="pln">xport</span><span class="pun">,</span><span class="pln"> </span><span class="pun">.</span><span class="pln">btn </span><span class="pun">{</span><span class="pln">
     display</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">inline</span><span class="pun">;</span><span class="pln">
     text</span><span class="pun">-</span><span class="pln">align</span><span class="pun">:</span><span class="pln">center</span><span class="pun">;</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">
    a </span><span class="pun">{</span><span class="pln"> text</span><span class="pun">-</span><span class="pln">decoration</span><span class="pun">:</span><span class="pln"> none </span><span class="pun">}</span><span class="pln">
    </span><span class="com">#data-table, #data-table th, #data-table td { border: 1px solid black }</span><span class="pln">
 </span><span class="pun">&lt;/</span><span class="pln">style</span><span class="pun">&gt;</span><span class="pln">
</span><span class="pun">&lt;</span><span class="pln">style type</span><span class="pun">=</span><span class="str">"text/css"</span><span class="pun">&gt;&lt;/</span><span class="pln">style</span><span class="pun">&gt;</span><span class="pln">
   </span><span class="pun">&lt;/</span><span class="pln">head</span><span class="pun">&gt;</span><span class="pln">
    </span><span class="str">&lt;body&gt;</span><span class="pln">
    </span><span class="pun">&lt;!--[</span><span class="kwd">if</span><span class="pln"> gt IE </span><span class="lit">9</span><span class="pun">]--&gt;</span><span class="pln">
    </span><span class="pun">&lt;</span><span class="pln">script type</span><span class="pun">=</span><span class="str">"text/javascript"</span><span class="pln"> src</span><span class="pun">=</span><span class="str">" #APP_IMAGES#download/xlsx.full.min.js.download"</span><span class="pun">&gt;</span><span class="pln">
             	</span><span class="pun">&lt;/</span><span class="pln">script</span><span class="pun">&gt;</span><span class="pln">
    </span><span class="pun">&lt;!--[</span><span class="pln">endif</span><span class="pun">]----&gt;</span><span class="pln">
    </span><span class="pun">&lt;!--[</span><span class="kwd">if</span><span class="pln"> lte IE </span><span class="lit">9</span><span class="pun">]&gt;</span><span class="pln">
    </span><span class="pun">&lt;</span><span class="pln">script type</span><span class="pun">=</span><span class="str">"text/javascript"</span><span class="pln"> src</span><span class="pun">=</span><span class="str">"shim.min.js"</span><span class="pun">&gt;&lt;/</span><span class="pln">script</span><span class="pun">&gt;</span><span class="pln">
    </span><span class="pun">&lt;</span><span class="pln">script type</span><span class="pun">=</span><span class="str">"text/javascript"</span><span class="pln"> src</span><span class="pun">=</span><span class="str">"xlsx.full.min.js"</span><span class="pun">&gt;&lt;/</span><span class="pln">script</span><span class="pun">&gt;</span><span class="pln">
    </span><span class="pun">&lt;</span><span class="pln">script type</span><span class="pun">=</span><span class="str">"text/javascript"</span><span class="pln"> src</span><span class="pun">=</span><span class="str">"Blob.js"</span><span class="pun">&gt;&lt;/</span><span class="pln">script</span><span class="pun">&gt;</span><span class="pln">
    </span><span class="pun">&lt;</span><span class="pln">script type</span><span class="pun">=</span><span class="str">"text/javascript"</span><span class="pln"> src</span><span class="pun">=</span><span class="str">"FileSaver.js"</span><span class="pun">&gt;&lt;/</span><span class="pln">script</span><span class="pun">&gt;</span><span class="pln">
    </span><span class="pun">&lt;![</span><span class="pln">endif</span><span class="pun">]--&gt;</span><span class="pln">
  </span><span class="str">&lt;script&gt;</span><span class="pln">
    </span><span class="kwd">function</span><span class="pln"> doit</span><span class="pun">(</span><span class="pln">type</span><span class="pun">,</span><span class="pln"> fn</span><span class="pun">,</span><span class="pln"> dl</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln">
     </span><span class="kwd">var</span><span class="pln"> elt </span><span class="pun">=</span><span class="pln"> document</span><span class="pun">.</span><span class="pln">getElementById</span><span class="pun">(</span><span class="str">'testid'</span><span class="pun">);</span><span class="pln">
     </span><span class="kwd">var</span><span class="pln"> wb </span><span class="pun">=</span><span class="pln"> XLSX</span><span class="pun">.</span><span class="pln">utils</span><span class="pun">.</span><span class="pln">table_to_book</span><span class="pun">(</span><span class="pln">elt</span><span class="pun">,</span><span class="pln"> </span><span class="pun">{</span><span class="pln">sheet</span><span class="pun">:</span><span class="str">"Sheet JS"</span><span class="pun">});</span><span class="pln">
     </span><span class="kwd">return</span><span class="pln"> dl </span><span class="pun">?</span><span class="pln">
      XLSX</span><span class="pun">.</span><span class="pln">write</span><span class="pun">(</span><span class="pln">wb</span><span class="pun">,</span><span class="pln"> </span><span class="pun">{</span><span class="pln">bookType</span><span class="pun">:</span><span class="pln">type</span><span class="pun">,</span><span class="pln"> bookSST</span><span class="pun">:</span><span class="kwd">true</span><span class="pun">,</span><span class="pln"> type</span><span class="pun">:</span><span class="pln"> </span><span class="str">'base64'</span><span class="pun">})</span><span class="pln"> </span><span class="pun">:</span><span class="pln">
      XLSX</span><span class="pun">.</span><span class="pln">writeFile</span><span class="pun">(</span><span class="pln">wb</span><span class="pun">,</span><span class="pln"> fn </span><span class="pun">||</span><span class="pln"> </span><span class="pun">(</span><span class="str">'Downloaded File.'</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> </span><span class="pun">(</span><span class="pln">type </span><span class="pun">||</span><span class="pln"> </span><span class="str">'xlsx'</span><span class="pun">)));</span><span class="pln">
    </span><span class="pun">}</span><span class="pln">
    </span><span class="pun">&lt;/</span><span class="pln">script</span><span class="pun">&gt;</span><span class="pln">
        </span><span class="str">&lt;pre&gt;</span><span class="pln">
        	</span><span class="str">&lt;b&gt;</span><span class="typ">Export</span><span class="pln"> it</span><span class="pun">!&lt;/</span><span class="pln">b</span><span class="pun">&gt;</span><span class="pln">
        </span><span class="pun">&lt;/</span><span class="pln">pre</span><span class="pun">&gt;</span><span class="pln">
        </span><span class="pun">&lt;</span><span class="pln">table id</span><span class="pun">=</span><span class="str">"xport"</span><span class="pun">&gt;</span><span class="pln">
            </span><span class="str">&lt;tbody&gt;</span><span class="pln">
                </span><span class="str">&lt;tr&gt;</span><span class="pln">
                    </span><span class="str">&lt;td&gt;</span><span class="pln">
                        </span><span class="str">&lt;pre&gt;</span><span class="pln">XLSX </span><span class="typ">Excel</span><span class="pln"> </span><span class="lit">2007</span><span class="pun">+</span><span class="pln"> XML</span><span class="pun">&lt;/</span><span class="pln">pre</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="pun">&lt;/</span><span class="pln">td</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="str">&lt;td&gt;</span><span class="pln">
                        </span><span class="pun">&lt;</span><span class="pln">p id</span><span class="pun">=</span><span class="str">"xportxlsx"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"xport"</span><span class="pun">&gt;</span><span class="pln">
                            </span><span class="pun">&lt;</span><span class="pln">input type</span><span class="pun">=</span><span class="str">"submit"</span><span class="pln"> </span><span class="kwd">value</span><span class="pun">=</span><span class="str">"Export to XLSX!"</span><span class="pln"> onclick</span><span class="pun">=</span><span class="str">"doit(&amp;#39;xlsx&amp;#39;);"</span><span class="pun">&gt;</span><span class="pln">
                        </span><span class="pun">&lt;/</span><span class="pln">p</span><span class="pun">&gt;</span><span class="pln">
                        </span><span class="pun">&lt;</span><span class="pln">p id</span><span class="pun">=</span><span class="str">"xlsxbtn"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"btn"</span><span class="pun">&gt;&lt;/</span><span class="pln">p</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="pun">&lt;/</span><span class="pln">td</span><span class="pun">&gt;</span><span class="pln">
                </span><span class="pun">&lt;/</span><span class="pln">tr</span><span class="pun">&gt;</span><span class="pln">
                </span><span class="str">&lt;tr&gt;</span><span class="pln">
                    </span><span class="str">&lt;td&gt;</span><span class="pln">
                        </span><span class="str">&lt;pre&gt;</span><span class="pln">XLSB </span><span class="typ">Excel</span><span class="pln"> </span><span class="lit">2007</span><span class="pun">+</span><span class="pln"> </span><span class="typ">Binary</span><span class="pun">&lt;/</span><span class="pln">pre</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="pun">&lt;/</span><span class="pln">td</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="str">&lt;td&gt;</span><span class="pln">
                        </span><span class="pun">&lt;</span><span class="pln">p id</span><span class="pun">=</span><span class="str">"xportxlsb"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"xport"</span><span class="pun">&gt;</span><span class="pln">
                            </span><span class="pun">&lt;</span><span class="pln">input type</span><span class="pun">=</span><span class="str">"submit"</span><span class="pln"> </span><span class="kwd">value</span><span class="pun">=</span><span class="str">"Export to XLSB!"</span><span class="pln"> onclick</span><span class="pun">=</span><span class="str">"doit(&amp;#39;xlsb&amp;#39;);"</span><span class="pun">&gt;</span><span class="pln">
                        </span><span class="pun">&lt;/</span><span class="pln">p</span><span class="pun">&gt;</span><span class="pln">
                        </span><span class="pun">&lt;</span><span class="pln">p id</span><span class="pun">=</span><span class="str">"xlsbbtn"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"btn"</span><span class="pun">&gt;&lt;/</span><span class="pln">p</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="pun">&lt;/</span><span class="pln">td</span><span class="pun">&gt;</span><span class="pln">
                </span><span class="pun">&lt;/</span><span class="pln">tr</span><span class="pun">&gt;</span><span class="pln">
                </span><span class="str">&lt;tr&gt;</span><span class="pln">
                    </span><span class="str">&lt;td&gt;</span><span class="pln">
                        </span><span class="str">&lt;pre&gt;</span><span class="typ">Comma</span><span class="pln"> </span><span class="typ">Separated</span><span class="pln"> </span><span class="typ">Values</span><span class="pun">&lt;/</span><span class="pln">pre</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="pun">&lt;/</span><span class="pln">td</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="str">&lt;td&gt;</span><span class="pln">
                        </span><span class="pun">&lt;</span><span class="pln">p id</span><span class="pun">=</span><span class="str">"xportcsv"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"xport"</span><span class="pun">&gt;</span><span class="pln">
                            </span><span class="pun">&lt;</span><span class="pln">input type</span><span class="pun">=</span><span class="str">"submit"</span><span class="pln"> </span><span class="kwd">value</span><span class="pun">=</span><span class="str">"Export to CSV!"</span><span class="pln"> onclick</span><span class="pun">=</span><span class="str">"doit(&amp;#39;csv&amp;#39;);"</span><span class="pun">&gt;</span><span class="pln">
                        </span><span class="pun">&lt;/</span><span class="pln">p</span><span class="pun">&gt;</span><span class="pln">
                        </span><span class="pun">&lt;</span><span class="pln">p id</span><span class="pun">=</span><span class="str">"csvbtn"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"btn"</span><span class="pun">&gt;&lt;/</span><span class="pln">p</span><span class="pun">&gt;</span><span class="pln">
                    </span><span class="pun">&lt;/</span><span class="pln">td</span><span class="pun">&gt;</span><span class="pln">
                </span><span class="pun">&lt;/</span><span class="pln">tr</span><span class="pun">&gt;</span><span class="pln">
            </span><span class="pun">&lt;/</span><span class="pln">tbody</span><span class="pun">&gt;</span><span class="pln">
        </span><span class="pun">&lt;/</span><span class="pln">table</span><span class="pun">&gt;</span><span class="pln">
        </span><span class="pun">&lt;/</span><span class="pln">body</span><span class="pun">&gt;</span><span class="pln">

        </span><span class="pun">&lt;/</span><span class="pln">html</span><span class="pun">&gt;</span><span class="pln">

        </span>

3. Create a New Region, 
   Name- Report,
   Type- Table/View
   Table- Your Table
   Advanced-> Static ID- testid

4. Go to Page Properties.
     JavaScript -> File URLs- Paste the code-

123<span class="pln">
	</span><span class="pun">&lt;</span><span class="pln">script src</span><span class="pun">=</span><span class="str">'https://cdn.jsdelivr.net/gh/jABER-IT/BlogSite-All-Host-File/Export_Data_Excel_File_In_Oracle_Apex/xlsx.full.min.js'</span><span class="pun">/&gt;</span>

 

🔗 Demo Application-
            URL- Demo Application
            Username - demo, Pass- demo
 

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................