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
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2009-01-22T01:22:10Z by SystemAdmin
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:45Z in response to SystemAdminHi,
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:10Z in response to SystemAdminThank you very much and I really apologise for posting on the wrong forum. Do you think there will be any issue as the file starts from a Windows thin-client onto a z/OS Mainframe?