SkysLastChance Posted November 14, 2016 Share Posted November 14, 2016 I am trying to pull data from a website and input into excel for a set number of times. This is the code I have so far. How should I go about going down 1 row at a time? If there is a certain help file I should be looking at let me know. expandcollapse popup#include <IE.au3> #include <Excel.au3> Excel () $sBox = InputBox ("Chart", "How Many Times") Func Excel () While ProcessExists("EXCEL.EXE") $ms = MsgBox(5,"","Process error. You have an Excel sheet open. You must close it in order to let this program work. Please close it now.") If $ms=2 Then Exit Sleep(250) WEnd Global $sExcelFile = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "(*.xlsx)") If FileExists($sExcelFile) Then Global $oExcel = _Excel_Open () $oExcel = _Excel_BookOpen($oExcel,$sExcelFile) ;this will open the chosen xls file. EndIf EndFunc Local $i = 0 Do $oIE = _IE_Example("basic") $oDiv = _IEGetObjById($oIE, "line1") _Excel_RangeWrite($oExcel,Default, $oDiv.innertext, "A1") $oDiv = _IEGetObjById($oIE, "line2") _Excel_RangeWrite($oExcel,Default, $oDiv.innertext, "B1") $oDiv = _IEGetObjById($oIE, "line3") _Excel_RangeWrite($oExcel,Default, $oDiv.innertext, "C1") $i = $i + 1 Until $i = $sBox You miss 100% of the shots you don't take. -Wayne Gretzky -Michael Scott Link to comment Share on other sites More sharing options...
water Posted November 14, 2016 Share Posted November 14, 2016 Try: Local $i = 1 Do $oIE = _IE_Example("basic") $oDiv = _IEGetObjById($oIE, "line1") _Excel_RangeWrite($oExcel,Default, $oDiv.innertext, "A" & $i) $oDiv = _IEGetObjById($oIE, "line2") _Excel_RangeWrite($oExcel,Default, $oDiv.innertext, "B" & $i) $oDiv = _IEGetObjById($oIE, "line3") _Excel_RangeWrite($oExcel,Default, $oDiv.innertext, "C" & $i) $i = $i + 1 Until $i > $sBox SkysLastChance 1 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
SkysLastChance Posted November 14, 2016 Author Share Posted November 14, 2016 I can't thank you enough. water 1 You miss 100% of the shots you don't take. -Wayne Gretzky -Michael Scott Link to comment Share on other sites More sharing options...
water Posted November 14, 2016 Share Posted November 14, 2016 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
SkysLastChance Posted November 15, 2016 Author Share Posted November 15, 2016 (edited) NVM Edited November 15, 2016 by SkysLastChance You miss 100% of the shots you don't take. -Wayne Gretzky -Michael Scott 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