DigDeep Posted July 19, 2016 Share Posted July 19, 2016 Hi, Looking at the Help file, if I am trying to delete entire column for A:C:D, either there is no error coming up but the columns do not get deleted OR I get error for "_Excel_RangeDelete($oWorkbook.ActiveSheet, $sRange)" $Final_XLS = "C:\Temp\Final.xls" Func Delete_Columns($sXLS) ; Create application object and open an example workbook Local $oExcel1 = _Excel_Open(False) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeDelete Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $oWorkbook = _Excel_BookOpen($oExcel1, $sXLS) If @error Then _Excel_Close($oExcel1) Return False EndIf Local $sRange = "A:C:D" _Excel_RangeDelete($oWorkbook.ActiveSheet, $sRange) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeDelete Example 1", "Error deleting cells." & $sRange & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $iResult1 = _Excel_BookSaveAs($oWorkbook, $sXLS) _Excel_Close($oExcel1) Return $iResult1 EndFunc ;==>Delete_Columns Delete_Columns($Final_XLS) Link to comment Share on other sites More sharing options...
DigDeep Posted July 19, 2016 Author Share Posted July 19, 2016 (edited) I was able to get this done via below way... $Final_XLS = "C:\Temp\Final.xls" Func Delete_Columns($sXLS) ; Create application object and open an example workbook Local $oExcel1 = _Excel_Open(False) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeDelete Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $oWorkbook = _Excel_BookOpen($oExcel1, $sXLS) If @error Then _Excel_Close($oExcel1) Return False EndIf Local $sRange = "A:D" _Excel_RangeDelete($oWorkbook.ActiveSheet, $sRange, $xlShiftToLeft, 2) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeDelete Example 1", "Error deleting cells." & $sRange & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $iResult1 = _Excel_BookSaveAs($oWorkbook, $sXLS) _Excel_Close($oExcel1) Return $iResult1 EndFunc ;==>Delete_Columns Delete_Columns($Final_XLS) Edited July 19, 2016 by DigDeep Link to comment Share on other sites More sharing options...
water Posted July 19, 2016 Share Posted July 19, 2016 How to handle ranges is described in the wiki: https://www.autoitscript.com/wiki/Excel_Range 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