pedrosojones 0 Posted April 30, 2010 Dear all, I need you help to use the _ExcelWriteCell function Exemple: _ExcelWriteCell($oExcel, "I Wrote to This Cell", 1, 1) How can I do, to write in the next cell if the 1st one is used ? Thank-you, Best Regards, João Jones Share this post Link to post Share on other sites
l3ill 70 Posted April 30, 2010 Do you mean, if there is data in cell A:1 that it will automatically move (write) to the next cell? I don't think it's possible... Otherwise if you just want to write to one cell after another: #include<Excel.au3> $oExcel = _ExcelBookNew() For $i = 1 To 20 ;Loop _ExcelWriteCell($oExcel, $i, $i, 1) ;Write to the Cell Next My Contributions...SnippetBrowserNewSciTEPathFinderText File ManipulationFTP Connection Tester / INI File - Read, Write, Save & Load Example Share this post Link to post Share on other sites
Juvigy 49 Posted April 30, 2010 (edited) It is possible: #include<Excel.au3> $oExcel = _ExcelBookNew() For $i = 1 To 2000 ;Loop $oExcel.Range("A"&$i).Select if $oExcel.Application.ActiveCell.Value = "" then _ExcelWriteCell($oExcel, $i, $i, 1) exitloop endif Next Edited April 30, 2010 by Juvigy Share this post Link to post Share on other sites
l3ill 70 Posted April 30, 2010 Sweeet...new excel stuff. mind telling me where you found that? My Contributions...SnippetBrowserNewSciTEPathFinderText File ManipulationFTP Connection Tester / INI File - Read, Write, Save & Load Example Share this post Link to post Share on other sites
Juvigy 49 Posted April 30, 2010 MSDN Excel has a object model. Share this post Link to post Share on other sites
pedrosojones 0 Posted April 30, 2010 Thank-you guys, I will test it. Nice Week-end Share this post Link to post Share on other sites
Ktulu789 0 Posted December 21, 2014 How to use _ExcelWriteCell or something similar on AutoIt latest version 3.3.12.0? Download a UDF file? AutoIt is a blessing, I don't know how I was able to use my computer before [Auto]It :-S Share this post Link to post Share on other sites
water 2,408 Posted December 23, 2014 AutoIt 3.3.12.0 comes with a re-written Excel UDF. Please check the Changelog for Script breaking changes. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites