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