How can I read an Excel spreadsheet from COBOL?

Question ID : 120
Created on 2010-02-03 at 5:14 PM
Author : Veryant Support [support@veryant.com]

Online URL : http://support.veryant.com/support/phpkb/question.php?ID=120



You can use the attached code as a framework to read your Excel spreadsheet.
The sample reads an Excel spreadsheet and display the contents using the Apache POI, installed with your isCOBOL runtime.
Compile and run it, passing the name of your spreadsheet as a parameter.

For instance:

   iscc readxls.cbl
   iscrun READXLS readxls.xls
Another good sample to refer to is in the samples folder of your isCOBOL installation, under "/is-java/iscobol-uses-java-object/others/excel".
NOTE: isCOBOL contains the basic Apache POI libraries. If you need full support, you can download more libraries here: http://poi.apache.org/download.html



Back to Original Question