// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("E2").setFormula("=sum(C1:C2)"); worksheet.getRange("C1").setFormula("=B1"); worksheet.getRange("B1").setFormula("=sum(A1:A2)"); worksheet.getRange("A1").setValue(1); worksheet.getRange("A2").setValue(2); worksheet.getRange("C2").setValue(3); ArrayList list = new ArrayList(); for (IRange item : worksheet.getRange("E2").getPrecedents()) { list.add(item); } while (list.size() > 0) { ArrayList temp = list; list = new ArrayList(); for (IRange item : temp) { for (int i = 0; i < item.getRowCount(); i++) { for (int j = 0; j < item.getColumnCount(); j++) { List dependents = item.getCells().get(i, j).getPrecedents(); if (dependents.size() == 0) { item.getCells().get(i, j).getInterior().setColor(Color.GetSkyBlue()); } else { item.getCells().get(i, j).getInterior().setColor(Color.GetGray()); list.addAll(dependents); } } } } } // Save to an excel file workbook.save("GetAllPrecedents.xlsx");