i met nextproblem: i'm trying to finad all rows where the parameter is met: like:
public static List findRows(String parameter, Cells cells){
List rows = new ArrayList();
boolean stop = false;
Cell curreCell = null;
Cell previousCell = null;
FindOptions findOptions = new FindOptions();
findOptions.setMatchType(FindOptions.MATCH_ENTIRE);
findOptions.setSearchType(FindOptions.SEARCH_BY_ROWS);
findOptions.setLookinType(FindOptions.LOOKIN_VALUES);
do{
if(previousCell == null){
curreCell = cells.find(parameter, null, findOptions);
previousCell = curreCell;
}else{
curreCell = cells.find(parameter, previousCell, findOptions);
previousCell = curreCell;
}
if(curreCell != null)
rows.add(cells.getRow(curreCell.getRowIndex()));
else
stop = true;
}while(!stop);
return rows;
}
but i get the next exception:
[ERROR] 22 Mar 03:58:27.328 PM DefaultQuartzScheduler_Worker-1 [bc.SchedulerEventBConverter]
java.lang.NullPointerException
at com.aspose.cells.FindOptions.a(Unknown Source)
at com.aspose.cells.FindOptions.a(Unknown Source)
at com.aspose.cells.FindOptions.c(Unknown Source)
at com.aspose.cells.FindOptions.b(Unknown Source)
at com.aspose.cells.Cells.find(Unknown Source)
at bc.excel.model.AsposeAbstractSheetDecorator.findRows(AsposeAbstractSheetDecorator.java:65)
at bc.excel.model.AsposeBargainSheetRawDataDecoratorImpl.setTradeInfoCells(AsposeBargainSheetRawDataDecoratorImpl.java:151)
at bc.excel.model.AsposeBalbothSheetRawDataDecoratorImpl.setTradeInfoCells(AsposeBalbothSheetRawDataDecoratorImpl.java:38)
at bc.excel.model.AsposeBargainSheetRawDataDecoratorImpl.createRow(AsposeBargainSheetRawDataDecoratorImpl.java:30)
at bc.excel.model.AsposeBargainSheetRawDataDecoratorImpl.createRows(AsposeBargainSheetRawDataDecoratorImpl.java:206)
at bc.excel.model.WorkbookRawDataDecoratorImpl.convert(WorkbookRawDataDecoratorImpl.java:49)
at bc.Converter.integrateBalbothToRawData(Converter.java:81)
at bc.BargainIntegrator.integrate(BargainIntegrator.java:77)
at bc.SchedulerEventBConverter$1.run(SchedulerEventBConverter.java:38)
at java.security.AccessController.doPrivileged(Native Method)
at bc.SchedulerEventBConverter.execute(SchedulerEventBConverter.java:27)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
help me please to resolve this problem!!!