Write-into-Column
Command Description
Write an array of column data starting from the specified cell in the sheet
Command Prototype
Excel.WriteColumn(objExcelWorkBook,sheet,strCell,data,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" | Two forms of cell are supported: cell names (such as "A1") or array of rows and columns (such as [row number, column number]). It is case-insensitive to use cell names |
| data | True | expression | [1,'one',2,'two',3,'three'] | The array to be written |
| bSave | True | boolean | None | Save immediately after the operation |
Demo
/************************Write 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 cell, supports two forms of cell name such as "A1" and row and column array such as [row number, column number]. When using the cell name, it is not case-sensitive.
**Entry 4:
** data--Array to write.
**Entry 5:
** bSave--The operation is completed and saved immediately. (boolean true/false)
**
*********************************************************************/
objExcelWorkBook = Excel.OpenExcel(@res"Test.xlsx",True,"Excel","","")
Excel.WriteColumn(objExcelWorkBook,"Sheet1","H1",["a","b","c","d"],False)
TracePrint "Write column: The column where H1 of the Excel object Sheet1 worksheet is located has written data 'abcd'"
Excel.CloseExcel(objExcelWorkBook,True)