|Title: How can I read an Excel spreadsheet from COBOL?|
|Here are the steps to compile and run the attached sample COBOL program (in readxls.zip) which will read an Excel spreadsheet and display the contents. This sample uses Apache POI.
compreadxls.bat contains the following two lines:
runreadxls.bat contains the following:
If you install POI in another location you simply need to modify the compile and run scripts.
To run READXLS without having to change CLASSPATH you could use the following command line:
Or if you want you can add C:poi-3.6poi-3.6-20091214.jar to your system CLASSPATH using the Control Panel : System : Advanced : Environment Variables dialog.
I think you will be able to see how to modify this sample to do what you need it to. If you need help please let our support team know.
|Authored by: Veryant Support on Wed, Feb 3rd, 2010 at 7:00 PM
This question has been viewed 12103 times so far.
|Online URL: http://support.veryant.com/support/phpkb/question.php?ID=120|
Powered by PHPKB Knowledge Base Software