wutangah Posted August 20, 2007 Share Posted August 20, 2007 Hello everyone! How do I take values and load them into an array for data entry? Link to comment Share on other sites More sharing options...
PsaltyDS Posted August 20, 2007 Share Posted August 20, 2007 Hello everyone!How do I take values and load them into an array for data entry?Welcome to AutoIt! Download Locodarwin's ExcelCOM_UDF(), and start experimenting.If you get stuck post a short 'reproducer' script to show the problem, and you'll get lots of help. Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
bogQ Posted August 20, 2007 Share Posted August 20, 2007 (edited) Hello everyone! How do I take values and load them into an array for data entry?if you need data from txt file to excel then something like this #Include <ExcelCOM_UDF.au3> #include <File.au3> $thenumber = "1" $oExcel = _ExcelBookOpen(@ScriptDir&"\Excel.xls",1);<== show=1 hide=0 $search = "Excel.txt" Dim $aRecords If Not _FileReadToArray($search,$aRecords) Then Exit EndIf For $x = 1 to $aRecords[0] _ExcelWriteCell($oExcel, $aRecords[$x], "a"&($thenumber)) $thenumber =$thenumber+1 Next if you need data from excel to array try to read then try reading info from ExcelCOM_UDF on command _ExcelReadArray your fast PsaltyDS Edited August 20, 2007 by bogQ TCP server and client - Learning about TCP servers and clients connectionAu3 oIrrlicht - Irrlicht projectAu3impact - Another 3D DLL game engine for autoit. (3impact 3Drad related) There are those that believe that the perfect heist lies in the preparation.Some say that it’s all in the timing, seizing the right opportunity. Others even say it’s the ability to leave no trace behind, be a ghost. Link to comment Share on other sites More sharing options...
wutangah Posted August 20, 2007 Author Share Posted August 20, 2007 Thanks guys! I'll start experimenting right away! Link to comment Share on other sites More sharing options...
PsaltyDS Posted August 20, 2007 Share Posted August 20, 2007 your fast PsaltyDSPsaltyDS is really just an answer-bot script written in AutoIt by SmOke_N... shh! Don't tell anybody... Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
wutangah Posted August 20, 2007 Author Share Posted August 20, 2007 PsaltyDS is really just an answer-bot script written in AutoIt by SmOke_N... shh! Don't tell anybody... LOL! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now