How to read Excel file and write to a SAP screen.

pbrods · Post by **pbrods** » Mon Dec 20, 2004 5:18 pm

I have not seen any examples of how to read an Excel (or text) file and write it one row at a time (multiple cells) into an app with multiple fields in a corresponding table. In other words, load data from a file to a table in SAP. Anybody?

support · Post by **support** » Mon Dec 20, 2004 5:29 pm

Hi,

Did you see these:

http://www.mjtnet.com/scripts.hts?display+118
http://www.mjtnet.com/scripts.hts?display+106

These show you two methods of grabbing data from Excel. Sending the data to the SAP screen would be a case of simulating user activity. Many many examples of that here and in the Scripts & Tips section (http://www.mjtnet.com/scripts.hts) and I recommend that you read the getting started guide in the documentation which will acquaint you with the concepts required for GUI automation.

Marty · Post by **Marty** » Fri Feb 11, 2005 7:07 pm

Sorry, but I didn't see here the two example of grabbing data from Excel and sending to the application - simulating user activity. This is exactly what I'm trying to do to make my decision to purchase.

support · Post by **support** » Fri Feb 11, 2005 7:29 pm

Those links have changed. Here are the new links with examples of reading from Excel:

http://www.mjtnet.com/forum/viewtopic.php?t=1470
http://www.mjtnet.com/forum/viewtopic.php?t=1482
http://www.mjtnet.com/forum/viewtopic.php?t=1464

As for simulating user activity there are literally thousands of examples of this littered around this site as that is the most common task. For that I would advise looking at the "Scripting Windows for Beginners" section of the help file which explains the most common GUI automation concepts. Then look at SetFocus, Send Character/Text, Press/Release, WaitWindowOpen and other window commands.

What you are wanting to do - reading from Excel and sending data to a window - is a very common scenario. You should find lots of help here. Follow the beginners guide as recommended above, then sketch out the process manually and you'll be half way there then ask questions here if you get stuck at any point.