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

After running Script
