<a href=”http://lmgtfy.com/?q=as400+file+to+xls”>Google is your friend!</a>
First step should be to ensure that your system is properly configured for CCSID conversions. If your QCCSID system value is anything but 65535, you are probably okay. However, if it is 65535, then you should review the possible implications of changing away from 65535 to an appropriate value. (The 65535 value more or less tells your system to avoid doing CCSID conversions when transferring data to or from other systems. It’s something like trying to do all FTP transfers in BINARY.)
Next, if you need actual .XLS files, then you will need to create or obtain programming that is capable of writing in Excel format. Excel is a Windows/Microsoft product, not an IBM product.
Finally, if you only need to do transfers in a <i>compaible</i> format, you can use the CPYTOIMPF command. An example of a <i>compatible</i> format would be a .CSV file. Although “.CSV” generally means “Comma-Separated Values”, other separator characters can often be used, e.g., ‘tab’ characters. When creating files for windows, you usually want CR and LF (carriage-return and line-feed) characters to mark end-of-line. Unix usually wants only LF characters. If you create the output streamfile with the CPYTOIMPF command, you can usually use a streamfile code page of *PCASCII.
The streamfile would be in a directory in the /root or possibly the /QNTC file system. (It could potentially even be a NFS mount from a Linux/Unix system, I suppose.) It can be in a directory that is designated as a share for Windows networking or it might be written directly to a Windows (or Linux) system on your network.
That’s a very short introduction. Add comments in the ‘Discussion’ area below if details are needed.