This content has been marked as final. Show 6 replies
i do not know about webutil , but i think you can do this with text_io package and it's procedures
fopen and getline
i think you can do this with text_io package and it's procedures fopen and getlineNo, an Open Office spread sheet is a zipped bunch of XML files. You would have to unzip the file, choose the correct XML file and then parse the content.
can you describe briefly..
I want to read the data of a open office spread sheet to the forms grid using webutilI don't know a way to directly manipulate OO-files with Oracle tools.
Since you want to use webutil I assume, that there is no MS Office installed, otherwise you could access it with OLE-functions.
Can you export the data to a CSV file? It would be easier to handle.
Another option is to copy/paste the content.
As last you could try to load the file to the server, unzip it and read the content of the XML.
Perhaps you can give us more information.
Thanks for your suggestion,
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.