Ram Posted December 28, 2006 Share Posted December 28, 2006 I have an inerface that has few textField, few comboBox, few checkBox... Now I have written a script that can add data to the textField using controlSend and used ControlCommand to fetch data from combobox and check/uncheck the checkbox.. Now I would like do this stuff using Excel file.. i.e I have excel file that has all related datas that are needed for textField, ComboBox, Checkbox..I would like get corresponding data from the excel file put them to it's corresponding textField in the interface... Is this possible? if so can someone guide me to that particular example or give me an idea on doing this.. Awaiting your response! Thanks! Link to comment Share on other sites More sharing options...
martin Posted December 28, 2006 Share Posted December 28, 2006 I have an inerface that has few textField, few comboBox, few checkBox... Now I have written a script that can add data to the textField using controlSend and used ControlCommand to fetch data from combobox and check/uncheck the checkbox..Now I would like do this stuff using Excel file.. i.e I have excel file that has all related datas that are needed for textField, ComboBox, Checkbox..I would like get corresponding data from the excel file put them to it's corresponding textField in the interface...Is this possible? if so can someone guide me to that particular example or give me an idea on doing this..Awaiting your response!Thanks!Search for "Excel" in the forums and you will find lots to help you. Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script. Link to comment Share on other sites More sharing options...
dabus Posted December 28, 2006 Share Posted December 28, 2006 Try thishttp://www.autoitscript.com/forum/index.php?showtopic=34302 -- excelhttp://www.autoitscript.com/forum/index.php?showtopic=14166 -- excel http://www.autoitscript.com/forum/index.ph...st&p=230702 -- access http://www.autoitscript.com/forum/index.php?showtopic=30461 -- wordhttp://www.autoitscript.com/forum/index.ph...st&p=233852 -- word Link to comment Share on other sites More sharing options...
Ram Posted December 29, 2006 Author Share Posted December 29, 2006 Thanks mate! I will check those links and I will reply back if at all these don't help me!! Link to comment Share on other sites More sharing options...
Ram Posted December 30, 2006 Author Share Posted December 30, 2006 Hey .. Sorry I browsed through the website.. all I understand is the excelCOM gets the data stores to an array ... but how do I call these my text field??? Please let me know.. Awaiting your response! Thanks! Link to comment Share on other sites More sharing options...
Ram Posted January 8, 2007 Author Share Posted January 8, 2007 Hi Guys, I am still looking for a solution ... I am really not sure how this works? anybody have an example on how to call each Excel Columns/row to a particular box? Awaiting your response! Thanks! Link to comment Share on other sites More sharing options...
The Kandie Man Posted January 8, 2007 Share Posted January 8, 2007 (edited) Use the functions that they show, then take the array and use _ArrayDisplay() to see what is inside of it: #include <array.au3> ;somewhere up here you get the data from the excel sheet and place it into $a_ReadExcel _ArrayDisplay($a_ReadExcel,"Array Data:") ;this will only work if the array is single dimensional Also, can you show the functions that you didn't understand. I don't feel like digging through all those Excel COM/OBJ UDFs to find the functions that you are referring to if my above example doesn't work. Edited January 8, 2007 by The Kandie Man "So man has sown the wind and reaped the world. Perhaps in the next few hours there will no remembrance of the past and no hope for the future that might have been." & _"All the works of man will be consumed in the great fire after which he was created." & _"And if there is a future for man, insensitive as he is, proud and defiant in his pursuit of power, let him resolve to live it lovingly, for he knows well how to do so." & _"Then he may say once more, 'Truly the light is sweet, and what a pleasant thing it is for the eyes to see the sun.'" - The Day the Earth Caught Fire Link to comment Share on other sites More sharing options...
Ram Posted January 9, 2007 Author Share Posted January 9, 2007 Use the functions that they show, then take the array and use _ArrayDisplay() to see what is inside of it: #include <array.au3> ;somewhere up here you get the data from the excel sheet and place it into $a_ReadExcel _ArrayDisplay($a_ReadExcel,"Array Data:") ;this will only work if the array is single dimensional Also, can you show the functions that you didn't understand. I don't feel like digging through all those Excel COM/OBJ UDFs to find the functions that you are referring to if my above example doesn't work. Thanks for the example... that reads the array.. but I am not sure how to use ExcelCOM...how to get the excel each rows data to array? I am new in this?? Please help!! - 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