Read The Excel File In AS/400

[DaccitAS/400]

Hi,

If anyone wants to read the excel file in as400.It is Possible by CPYFRMIMPF Command.By use of it we can create a report in which input is in excel sheet.



Thanks
Ankit
Daccit Pvt Ltd

[tomholden]

Re: Read The Excel File In AS/400

Hi,

If anyone wants to read the excel file in as400.It is Possible by CPYFRMIMPF Command.By use of it we can create a report in which input is in excel sheet.



Thanks
Ankit
Daccit Pvt Ltd

using CPYFRMIMPF??? Absolutely not. you can use the POI HSSF java library to parse the spreadsheet though. go to http://systeminetwork.com and do a search for HSSF and you'll find a service program written by Scott Klement that will allow you to parse the spreadsheet directly from the IFS.