pedrosojones Posted April 30, 2010 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
l3ill Posted April 30, 2010 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
Juvigy Posted April 30, 2010 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
l3ill Posted April 30, 2010 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
pedrosojones Posted April 30, 2010 Author Posted April 30, 2010 Thank-you guys, I will test it. Nice Week-end
Ktulu789 Posted December 21, 2014 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
water Posted December 23, 2014 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
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