I am having single column in excel sheet which I want to replicate in Jython scripting and place it in adjacent column.The Content of the Column is as in the Pic below

from jxl import *
from jxl.write import *
from java.io import File
workbook = Workbook.getWorkbook(File("$(TargetFolder)\Book2.xls"))
targetWorkbook = Workbook.createWorkbook(File("$(TargetFolder)\Book2.xls"),
workbook)
sheet = targetWorkbook.getSheet(0)
columnIndex = 0

rowCount = sheet.getRows()

for i in range(rowCount):
 row = sheet.getRow(i)
 content = row[columnIndex].getContents()
 rc.logMessage("Content -> " + content)    
 wc = sheet.getWritableCell(1,i)
 newLabel = Label(1,i, content)
 sheet.addCell(newLabel)
 
targetWorkbook.write() 
targetWorkbook.close()
workbook.close()

Before running Script
null

After running Script
null