Can any one tell me if there is an easy way to convert as400 spool files to a fornat that can be imported into excel? Currently i am modifying programs to build a db file as well as a spool file which is becoming tedious. I'm new to as400 Java development (JT400).I'm get spooled file list and read it normal text. Now i want to convert it to excel (XLS) file. I'm Trying to convert AS400 spooled file to excel(XLS) file using Java.but im faild.
Active3 years ago
I was doing the code change. After compiling the programs in RPG i want to do the testing. But when i run the command i am not able to get spool file for that run of command. Please help. Thanks in Advance!
cschneid7,66711 gold badge2020 silver badges2828 bronze badges
ApostrophiApostrophi
Oracle Spool File
1 Answer
![As400 Convert Spool File Excel As400 Convert Spool File Excel](https://interform400.com/images/site/AMJBDRP2_InterFormXML.png)
Assuming you're correct and that the program creates a spool file...
Sounds like it's being sent to a printer automatically. By default, once a spool file is printed it gets deleted from the system.
Try doing the following before running your program:
You'll need to use the name of the printer file used by your program in place of
CharlesCharlesMYPRTF
. The HOLD(*YES)
will prevent the spool file generated from the printer file from being sent to the assigned printer.![As400 Convert Spool File Excel As400 Convert Spool File Excel](https://www.drvtech.com/wp-content/uploads/2018/11/Excel_Video_5.jpg)
As400 Convert Spool File To Excel
12.4k11 gold badge1111 silver badges3232 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.