cancel
Showing results for 
Search instead for 
Did you mean: 

error mesage java.lang.noclassdeffounderror

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

API Summer News

Congratulate last week's winners here:
1. @sanj - $50
2. @Sehuang and @aaronpliu - $35
3. @jhanzeb1 - $15

To do this week:
- Ask product-related questions
- Reply to any questions

Win $50, $35 or $15 gift card!
Winners will be decided next Monday (Aug 27)

Top Kudoed Authors
Are You In?