Mailing List - Entries of 2015

List Icon
Mailing list Archive

2019 up to July 2022 | 2018 | 2017  |  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.
If you want to stay informed about news about QF-Test, you can simply subscribe to our newsletter:
Subscribe to Newsletter  

[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

Team,

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)

 

 

Thanks,

Hema

We use "Matomo" cookies to anonymously evaluate your visit to our website. For this we need your consent, which is valid for twelve months. A revocation, so-called opt-out, is possible at any time on our privacy page.

accept
configuration
Cookie configuration

1. Functional cookies

We use functional cookies to ensure the basic functionality of the website.

2. Performance and statistic cookies

We use Matomo for analyzing and optimizing our website. Cookies permit an anonymous collection of information that help us offering you a clear and user-friendly visit of our web pages.

Confirm selection

Cookie details