Delete-Column

Command Description

Delete a column from the sheet

Command Prototype

Excel.DeleteColumn(objExcelWorkBook,sheet,strCell,bSave)

Parameter Description

Parameter	Required	Type	Default	Description
objExcelWorkBook	True	expression	objExcelWorkBook	Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel) or the workbook object returned by the command "Bind Excel" (Excel.BindBook))
sheet	True	string	"Sheet1"	The string means sheet name. The number means sheet order(starting from 0)
strCell	True	string	"A1"	The specified column, can be positioned using a cell name like 'A1' or directly using a numeric column number
bSave	True	boolean	None	Save immediately after the operation

Demo

/************************Remove column************************** ******** 
**Input 1: 
**      objExcelWorkBook -- Excel workbook object (a workbook opened using the  "Open Excel" command (Excel.OpenExcel)  or a work bound using the "Bind Excel" command (Excel.BindBook) book object). 
**Entry 2: 
**      sheet--If a string is used, it means the name of the specified worksheet; if a number is used, it means the order of the specified worksheet (starting from 0). 
**Entry 3: 
**      strCell--Specified row, you can use the cell name such as 'A1' to locate, or directly use the numeric row number to locate. 
**Entry 4: 
**      bSave--The operation is completed and saved immediately. (boolean true/false) 
** 
*********************************************************************/ 
  
objExcelWorkBook = Excel.OpenExcel(@res"Test.xlsx",True,"Excel","","") 
Excel.DeleteColumn(objExcelWorkBook,"Sheet1","F1",False) 
TracePrint "Delete column: The column where F1 of the Excel object Sheet1 worksheet is located has been deleted" 
Excel.CloseExcel(objExcelWorkBook,True)