I have WAS running on z/OS with a DB2 backend. I have a thin-client browser, where the user can upload an excel file, with a column of data, which needs to be inserted into DB2.
Is there some kind of web-based control, which can read an excel file, and extract the contents? That page will consist of a text box, with a browse and upload buttons. I would rather not have to submit the excel file as a multi-part message, being that the Excel file is a binary, and z/OS will not be compatible with windows. But if I have to, I would, if someone can help.
Thanks in advance
Pinned topic Reading Excel data from a thin client to z/OS main frame
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-01-22T01:22:10Z at 2009-01-22T01:22:10Z by SystemAdmin
Re: Reading Excel data from a thin client to z/OS main frame2009-01-21T21:57:45ZThis is the accepted answer. This is the accepted answer.Hi,
This is not really the right forum for this, but the following may help
Apache POI is a collection of pure Java APIs to read and write MS Office formats. You could us this on the server side to read the data out of the uploaded file.
Or the other option may be to deploy a Java Applet on the client side to read the file and then upload the data. To get access to the local file system but you will probably need to sign the Applet in order to get the required permission.
Hope this helps,
p.s. I have never used POI but I have worked with customers who have. There are other options just google "java excel" for options.
Re: Reading Excel data from a thin client to z/OS main frame2009-01-22T01:22:10ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK