Posted by: shijesh | August 9, 2011

Download to Excel (XML)

At present APEX provide download to CSV only. If we want to download it to EXCEL , we need to use some reporting tool or we can create our own PL/SQL package.

Here I tried to create a package in PL/SQL which will download the file in XML Spreadsheet 2003 format which will open in MS Excel. It supports formatting. At present I have given option to download the spreadsheet in two different style.

Demo Link : http://apex.oracle.com/pls/apex/f?p=12060:26

Soon I will be posting the link to the package.

Advertisements

Responses

  1. Dear Shijesh,
    Do have any Idea about how can we upload xls instead of csv..
    Regards,
    Fateh

    • Hi,

      There are several tools available to upload the data from excel to oracle. [Google for third party tool to upload excel to oracle table]
      You can also use the excel macro to upload the data to Oracle table. [Google for excel macro to load data to oracle table]

      Regards,
      Shijesh

  2. Hi,
    Do you have the package to create the XML download format?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: