How to delete a column from excel file in excel 2013

[Mian 0]

If I am not wrong _Excel_RangeDelete() function is used to delete rows/columns/cells from the excel file. In the manual page there are examples of deleting range and rows but I found not a single example of deleting a whole column. I tried this _Excel_RangeDelete($oExcel, "1")  but no success. Please help.

[JLogan3o13 961]

Hi, @Mian welcome to the forum. The snippet below works just fine for me:

#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\1.xls")
_Excel_RangeDelete($oWorkbook.ActiveSheet, "B:B", $xlShiftToLeft)

 

[Mian 0]

@JLogan3o13 Thank you for the solution. I used the following code to remove the column but I will update my code now

;
; To remove the excluded column
;
send("^g") ; ^  is for CTRL
sleep(500)
WinWait("Go To")
sleep(500)
WinActivate("Go To")
sleep(500)
;send("R")
send("G1")
sleep(500)
Send("{TAB 3}")
sleep(500)
Send("{ENTER}")
sleep(500)
send("^{SPACE}")
sleep(500)
send("^-")
sleep(500)

 

[water 1,615]

It is always a good idea to use the UDFs that come with Autoit to automate Office.
Automating the GUI might interfere with user actions, using COM (most of the time) does not.

[Mian 0]

very true @water. thats why I posted the question  I had another question posted, can you please have a look of that too.

 

[water 1,615]

If you are talking aboutthen I have already added a comment.