Help with script reading from excel or txt file

[Sennback]

Hi,

I need a script wich is going in a loop and reads in data from an excel or txt file.

I am happy for everything that can help me, so even a script wich is made for something completely different that I can modify is perfect!
I know almost nothing about this but I am faliliar to programming other languages.

I need to program 1000 names into a meridian switch and has a file with both extension numbers and names.
So the script will have to be like this:
Start of loop
waitfor "DN "
transmit "86306^M" (here it should read extension)
waitfor " NAME "
transmit "test^M" (here it should read name)
waitfor " XPLN "
transmit "^M"
waitfor " DISPLAY_FMT "
transmit "^M"
Go to start of loop

 

[knob]

I have several examples at

http://www.aspectscripting.com/samples.html

that illustrate how to read from Excel (via DDE) or from text files.

http://www.aspectscripting.com/DDE_EXCEL_TO_TEXT.ZIP

shows how to read data from an Excel spreadsheet using DDE. Here are a few scripts that show how to open and manipulate a text file (I would recommend viewing the discussion of these three scripts on the samples page):

http://www.aspectscripting.com/InsertString.was

http://www.aspectscripting.com/TabDelimit.was

http://www.aspectscripting.com/Swapper.ZIP

Whichever method you choose, you will be in some sort of loop (for example, while not feof 0/endwhile for text files). You'll just need to insert your commands above into the script after it reads each piece of information.


aspect@aspectscripting.com

http://www.aspectscripting.com