pedrosojones Posted April 30, 2010 Share 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 Link to comment Share on other sites More sharing options...
l3ill Posted April 30, 2010 Share 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... SnippetBrowser NewSciTE PathFinder Text File Manipulation FTP Connection Tester / INI File - Read, Write, Save & Load Example Link to comment Share on other sites More sharing options...
Juvigy Posted April 30, 2010 Share 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 Link to comment Share on other sites More sharing options...
l3ill Posted April 30, 2010 Share Posted April 30, 2010 Sweeet...new excel stuff. mind telling me where you found that? My Contributions... SnippetBrowser NewSciTE PathFinder Text File Manipulation FTP Connection Tester / INI File - Read, Write, Save & Load Example Link to comment Share on other sites More sharing options...
Juvigy Posted April 30, 2010 Share Posted April 30, 2010 MSDN Excel has a object model. Link to comment Share on other sites More sharing options...
pedrosojones Posted April 30, 2010 Author Share Posted April 30, 2010 Thank-you guys, I will test it. Nice Week-end Link to comment Share on other sites More sharing options...
Ktulu789 Posted December 21, 2014 Share 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 Link to comment Share on other sites More sharing options...
water Posted December 23, 2014 Share 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 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...
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