public static void Main(string[] args)
{
//ExStart:1
// The path to the documents directory.
string dataDir = Aspose.Cells.Examples.Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
Workbook workbook = new Workbook(dataDir + "Book1.xlsx");
Cells cells = workbook.Worksheets[0].Cells;
Cell cell = cells["B4"];
ReferredAreaCollection ret = cell.GetPrecedents();
ReferredArea area = ret[0];
Console.WriteLine(area.SheetName);
Console.WriteLine(CellsHelper.CellIndexToName(area.StartRow, area.StartColumn));
Console.WriteLine(CellsHelper.CellIndexToName(area.EndRow, area.EndColumn));
//ExEnd:1
Console.ReadKey();
}
static void Main(string[] args)
{
// Tracing Precedents
//Instantiating a Workbook object
Workbook workbook = new Workbook("C:\\book1.xls");
Cells cells = workbook.Worksheets[0].Cells;
Aspose.Cells.Cell cell = cells["B7"];
//Tracing precedents of the cell B7.
//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.Count; m++)
{
ReferredArea area = ret[m];
StringBuilder stringBuilder = new StringBuilder();
if (area.IsExternalLink)
{
stringBuilder.Append("[");
stringBuilder.Append(area.ExternalFileName);
stringBuilder.Append("]");
}
stringBuilder.Append(area.SheetName);
stringBuilder.Append("!");
stringBuilder.Append(CellsHelper.CellIndexToName(area.StartRow, area.StartColumn));
if (area.IsArea)
{
stringBuilder.Append(":");
stringBuilder.Append(CellsHelper.CellIndexToName(area.EndRow, area.EndColumn));
}
Console.WriteLine(stringBuilder.ToString());
}
}
}
