Aspose.Cells - Tracing Precedents and Dependents

Tracing Precedents

//Instantiating a Workbook object
Workbook workbook = new Workbook("data/workbook.xls");

Cells cells = workbook.getWorksheets().get(0).getCells();
Cell cell = cells.get("A12");

//Tracing precedents of the cell A12.
//The return array contains ranges and cells.
ReferredAreaCollection ret = cell.getPrecedents();

//Printing all the precedent cells' name.
if(ret != null)
{
  for(int m = 0 ; m < ret.getCount(); m++)
  {
    ReferredArea area = ret.get(m);
    StringBuilder stringBuilder = new StringBuilder();
    if (area.isExternalLink())
    {
        stringBuilder.append("[");
        stringBuilder.append(area.getExternalFileName());
        stringBuilder.append("]");
     }
     stringBuilder.append(area.getSheetName());
     stringBuilder.append("!");
     stringBuilder.append(CellsHelper.cellIndexToName(area.getStartRow(), area.getStartColumn()));
     if (area.isArea())
      {
          stringBuilder.append(":");
          stringBuilder.append(CellsHelper.cellIndexToName(area.getEndRow(), area.getEndColumn()));
      }
      System.out.println("Tracing Precedents: " + stringBuilder.toString());
   }
}

Tracing Dependents

//Get the A1 cell
Cell c = cells.get("A5");
//Get the all the Dependents of A5 cell
Cell[] dependents = c.getDependents(true);
for (int i = 0; i< dependents.length; i++)
{
     System.out.println("Tracing Dependents: " + dependents[i].getWorksheet().getName() +dependents[i].getName() + ":" + dependents[i].getIntValue());
}

Download Source Code

For More Examples, Please Visit Aspose Docs

Last edited May 9, 2014 at 5:59 AM by shoaibkhan, version 2