water Posted March 1, 2013 Posted March 1, 2013 ClipGet to retrieve the content and then _ExcelWriteCell from the Excel UDF. 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
tempman Posted March 1, 2013 Author Posted March 1, 2013 Are you kidding me, this is the easiest way?!? #include <Excel.au3> $oExcel = _ExcelBookNew() For $i = 1 To 10 _ExcelWriteCell($oExcel, "111", $i, 1) _ExcelWriteCell($oExcel, "222", $i, 2) _ExcelWriteCell($oExcel, "333", $i, 3) _ExcelWriteCell($oExcel, "444", $i, 4) Next $aArray = _ExcelReadSheetToArray($oExcel, 1, 3, 0, 1) $Max = $aArray[0][0] _ExcelColumnInsert($oExcel, 1, 1) For $i = 1 To $Max _ExcelWriteCell($oExcel, $aArray[$i][1], $i, 1) Next _ExcelColumnDelete($oExcel, 4, 1)
water Posted March 1, 2013 Posted March 1, 2013 No kidding. That's the easiest way to do it wiht the Excel UDF. If you want to play with Excel COM then have a look at the range.cut method. 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