List Icon
Mailing list Archive

2019 up to July 2022 | 20182017  |  2016  2015 2014 | 2013

The mailing list has been closed since July 2022, but continues to serve as an archive of information about QF-Test.
But if you want to stay informed about news about QF-Test, you can simply
Subscribe to Newsletter  

To get up-to-date information about each release - including minor releases - you can
subscribe to the RSS feed or follow us on social media.
Alternatively, QF-Test also provides release information itself.

Another source of information is our blog, where there are current articles on general topics, on the company QFS and also various "how-tos"
subscribe to blog

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[QF-Test] Help required working Excel reports in QF-Test version 3.5.5-p1 -- >Jython scripting

  • Subject: [QF-Test] Help required working Excel reports in QF-Test version 3.5.5-p1 -- >Jython scripting
  • From: Hema Nagaraj <hema.nagaraj@?.com>
  • Date: Mon, 27 Jul 2015 13:56:59 +0000


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 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)