Guest User

Untitled

a guest
Jul 4th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException: Specified named range 'RtSummary.1' does not exist in the current workbook.
  2.  
  3. //cell 3 (total orders) will be filled later
  4. String summarySheetName="RtSummary."+snapshots[i].trim()+Integer.toString(i+1);
  5. String detailSheetName="RtDetail."+snapshots[i]+(i+1);
  6. Row orderRow;
  7.  
  8.  
  9. //first comparison table content
  10. int rowOffset=15+snapshots.length;
  11. curRow=overviewSheet.createRow(rowOffset+i);
  12. orderRow=curRow;
  13. curCell=curRow.createCell(1);
  14. curCell.setCellStyle(lrBarStyle);
  15. curCell.setCellValue(snapshots[i]);
  16.  
  17. curCell=curRow.createCell(2);
  18. curCell.setCellStyle(lrBarStyle);
  19. if(sameDay)
  20. curCell.setCellValue(dateSDF.format(startDate.getTime()));
  21. else
  22. curCell.setCellValue(dateSDF.format(startDate.getTime())+"-"+dateSDF.format(endDate.getTime()));
  23.  
  24. curCell=curRow.createCell(4);
  25. curCell.setCellStyle(lrBarStyle);
  26. System.out.println(summarySheetName);
  27. curCell.setCellFormula(summarySheetName+"!N"+(routes.length+2));
  28. System.out.println("0k");
Advertisement
Add Comment
Please, Sign In to add comment