Have an Excel macro download data to the iSeries
Home > IT Answers > Microsoft Windows > Have an Excel macro download data to the iSer...
Aderene
15 pts.
0
Q:
Have an Excel macro download data to the iSeries
Microsoft Excel, iSeries application development tools, IFS, Excel macros, iSeries job
Is it possible to code an Excel macro to download a spread sheet to the IFS (on the iSeries) and then to start an iSeries job to process the downloaded data?
ASKED: Oct 17 2008  4:05 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
SBatSI
370 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I cannot answer your question directly, but here is a link to a training program that promises to teach you how to do things like this.

http://www.lab400.com/product_detail.asp?prod_id=201

I hope this helps...

Regards,

Steve B
Last Answered: Oct 20 2008  3:20 PM GMT by SBatSI   370 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

GAC   300 pts.  |   Oct 20 2008  4:08PM GMT

Aderene,

What I understand in your question is that you have an MS-Excel file and you want to upload and process the information in your i5. You can follow several paths:

1. If the data structure is the same as a physical file in the i5, just define a data transfer description file and use the add-on provided in Personal Communications to upload the data to the PF.

2. If your .xls has just one sheet then save its contents to an IFS folder in a standard (non-Excel) format like CSV or DOS text and then use command CPYFRMIMPF to import it to a database file and process it. Several saves must be done if you have several sheets in your .xls. I recommend you this method if you have more experience programming on the i5.

3. Use a VBA macro from the spreadsheet itself to browse the file and save the information to the i5. Use this if you have experience developing macros in Visual Basic for Applications and the information in the excel needs previous process. Same result but it is more “attractive” to a final user to fill the excel and press a button (more complicated to us, developers, as we have to think about the process and security).

4. There is a Java API  <a href="http://poi.apache.org" title="http://poi.apache.(" target="_blank">poi.apache.org</a>). You can use it at the client computer or at the i5 server. Again, easier to a final user but more complicated to a programmer/developer.

Good luck,

Gerardo

 
0