Please help me in writing Jython script to find SUM of range of cells in Excel
Where testfile is the File name , here I have given dummy path, “Deal Audit” is the sheet name.
I have worked earlier on excel for verifying cell data, but finding difficulty in this scenario.
Scenario: Trying to add a range of rows ranging from R9 to R20 in excel and store Total in Variable “TValue”
Below is the script :
from jxl import *
from java.io import File
testFile = "<Path><xls file>"
workbook = Workbook.getWorkbook(File(testFile))
sheet = workbook.getSheet("Deal Audit")
Rvalue = sheet.range(R9:R20)
rc.logMessage(str(RValue), dontcompactify=True, report=True, nowrap=False)
TValue = workbook.worksheetfunction.sum(Rvalue)
rc.logMessage(str(TValue), dontcompactify=True, report=True, nowrap=False)