Eric Lehti
VIP Member
Are any of you Creating Excel (.xls and .xlsx ) spreadsheets directly from RPG?
We do not do so. We use the Excel Add-In "Transfer Data from IBM i" that is included with IBM's client access for Windows to download from data files.
Or I will produce a .csv file on a network folder with:
CPYTOIMPF FROMFILE(F55001B) +
TOSTMF('/QNTC/SCHROEDER/LIBRARY/rmaO/open_RMA.TXT') +
MBROPT(*REPLACE) STMFCODPAG(*PCASCII ) RCDDLM(*CRLF)
We do not do so. We use the Excel Add-In "Transfer Data from IBM i" that is included with IBM's client access for Windows to download from data files.
Or I will produce a .csv file on a network folder with:
CPYTOIMPF FROMFILE(F55001B) +
TOSTMF('/QNTC/SCHROEDER/LIBRARY/rmaO/open_RMA.TXT') +
MBROPT(*REPLACE) STMFCODPAG(*PCASCII ) RCDDLM(*CRLF)