Open Source Tools

Reply
Highlighted
Occasional Contributor

error mesage java.lang.noclassdeffounderror

dear all

I have this script run

---

import org.apache.poi.ss.usermodel.*
import org.apache.poi.hssf.usermodel.*
import org.apache.poi.xssf.usermodel.*
import org.apache.poi.ss.util.*

def fs = new FileInputStream ("/Users/Documents/soapUIworkspace/logindata.xlsx")
Workbook wb = WorkbookFactory.create(fs)
def ws = wb.getSheet("Sheet1")
def r = ws.getPhysicalNumberOfRows()

for (def i=0; i<r; i++) {
    def row = ws.getRow(i)
    def c = row.getPhysicalNumberOfCells()

    for(def j=0; j<c;j++) {
        def cell = row.getCell(j)
        log.info cell.getStringCellValue()
    }
}
log.info r
 
wb.close()

 

.....

when I ran it, I got an error message "java.lang.noclassdeffounderror org/openxmlformats/schemas/spreadsheets/x2006/main/ctextensionlist" (attached). I am using soapUI-5.4.0 EB.

 

I already insert the jar files in the ext and lib folders.

 

please help

Join us to win gifts
Daily Articles: 1, 2, 3, 4, 5, 6, 7

Program Rules
Do you do REST?