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... Read More
isCOBOL General
If you find yourself needing to send SMS messages from an isCOBOL application, there are several ways to accomplish this by using a third-party API. For example, Twilio offers a widely-used and robust solution. To use the Twilio API, you'll... Read More
Each installation setup includes a README. This README file lists all the new features in that release. There is also a file named CHANGELOG.txt that lists all changes in the release, in order of build and ID number. For instance, if you update... Read More
In isCOBOL you may get a Java note saying something similar to "... uses unchecked or unsafe operations." This warning is displayed when you execute code which the Java compiler considers to be lacking in error-checking, or potentially unsafe in... Read More
One way to get the week number of a passed date is to use intrinsic functions. Using several functions available in isCOBOL, you can get the Julian date, which will give you the date's number of days in the year. Divide this by 7 and you'll... Read More
When you install isCOBOL, it asks you for the location of the Java installation, and saves this path in a file or files. Then all the executable wrappers installed in the %isCOBOL%/bin folder look for this file to find Java. If you install a new... Read More
Question: The ASSIGN TO name in my SELECT statement is a variable. How can I set iscobol.file.index.FileName in the properties file when the file name is determined by the program at run time? Answer: The solution is to set the iscobol.file... Read More
Question: Can I set the iscobol.file.index or iscobol.file.index.FileName variables inside my COBOL program? My application reads a file which has information about which file system to use for each data file. Some data files are Jisam. Others... Read More
Usually to replace a text in a string you use the "inspect replacing" statement. But with this kind of approach the original text and the new text must have the same length. To avoid this problem you can use the "C$REPLACE_ALL" routine. This... Read More
Question: The icon in the upper left corner of the Window is a blue circle containing the letters "is". How can I replace this with my own icon? Answer: If you want to display the Java icon instead of the isCOBOL icon, you can set iscobol.gui... Read More