First I want to tell you that I want the data from the client system. I have already getting the data from those client system where MS-office is available. But in case of Open office and linux client I can't able to get the data from openoffice spreadsheet to forms grid.

As said above I don't know how to access the content with Oracle tools. When I had to do so I would look at two possibilities, both require that the file is transfered to the db server. You can use webutil_file_transfer.db_to_client_with_progress to do so.

1. OO has an API that allows to control it from outside. I never used it and it would mean a lot of work to learn how to use it and OO needs to be installed on the server. Yet I assume that afterwards you can use it like OLE to read the data.

2. (My first try) Since an OO spread sheet is just a bunch of zipped XML files I would unzip one and look at the contents. http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.html
While processing the file this way can be done with PL/SQL (and maybe a little JAVA) it is less flexible than the first approach.