Daily Archives: March 12, 2014

How to create array of String in Jython

Posted on by 
import jarray
import java
myArray = jarray.array(["mugil", "Vannan"], java.lang.Object)

rc.logMessage(str(len(myArray)))

for value in myArray:
 rc.logMessage(value)

For Character

myArray = jarray.array(["m", "V"], "c")

For Integer

import jarray
import java
myArray = jarray.array([1,2,3,4,5,6], java.lang.Integer)

rc.logMessage(str(len(myArray)))

for value in myArray:
 rc.logMessage(str(value))

How to Replicte Column in Excel Sheet Jython Scripting

Posted on by

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