I looked at this, 15 years later.
Getting an excel sheet to AS400 does not seem straightforward. Here what I did:
copy the excel sheet to a text file or generate an SCV
upload the text file to AS400 IFS under /home/user/file
create a source file CRTSRCPF lib/file1
CPYFRMSTMF /home/user/file lib/file1
Use SQL scripts to copy from lib/file1 to a data base file