Several years ago, I developed an API which allows COBOL, ASM, etc. to read and write native excel files.
To read, the unmodified Excel files is binary uploaded to sequential file or PDS member. JCL allocates sequential file or PDS member via JCL. COBOL program accesses sequential file or PDS member via API. Let me know if you are interested in additional details. Sam On Mon, Aug 3, 2015 at 10:36 AM, Farley, Peter x23353 < peter.far...@broadridge.com> wrote: > I think that the "open document" format for spreadsheet files (*.ods) is > an XML file in reality, you might want to investigate converting the Excel > template to that format first. > > Excel since the 2007 version can save files in that format, using "SaveAs". > > HTH > > Peter > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Ron Thomas > Sent: Monday, August 03, 2015 1:20 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Exporting Excel to Dataset > > We have a requirement that looks for exporting an Excel template with data > in a tabular format from an FTP folder location to a mainframe PDS which > later needs to be accessed via COBOL for some business processing logic. > > We know that this works fine if the input Excel file is in .CSV format. > What we are looking for is, if anyone is aware of any such functionalities > where we can accept and export the Excel template as such to a PDS that is > readable by COBOL without being converted to a .CSV file? > > Thanks > Ron T > -- > > > This message and any attachments are intended only for the use of the > addressee and may contain information that is privileged and confidential. > If the reader of the message is not the intended recipient or an authorized > representative of the intended recipient, you are hereby notified that any > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please notify us immediately by > e-mail and delete the message and any attachments from your system. > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
