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

["Robert Lahmer, QFS support" <support@?.de>]

Hello Hema,

here's an example code based on the more modern Apache POI (which - in
contrast to the JXL library - is also able to deal with .xlsx files):


from org.apache.poi.hssf.usermodel import HSSFWorkbook
from java.io import FileInputStream

filename = rc.lookup("qftest", "suite.dir") + "/mytable.xls"
fis = FileInputStream(filename)
workbook = HSSFWorkbook(fis)
fis.close()
sheet = workbook.getSheet("Deal Audit");
TValue = 0
col = ord("R") - ord("A")
for row in range(9, 20 + 1):
    cell = sheet.getRow(row - 1).getCell(col)
    TValue += cell.getNumericCellValue()
print TValue


Best regards,
    Robert



Am 27.07.2015 15:56, schrieb Hema Nagaraj:
> 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
>
>
>
> _______________________________________________
> qftest-list mailing list
> qftest-list@?.de
> http://www.qfs.de/mailman/listinfo/qftest-list