Working with Navigation
Overview
Reach any worksheet or cell from the Workbook object graph, and work with hyperlinks
stored on a worksheet.
Worksheets and Cells
Index into $workbook->Worksheets for a sheet, then into $sheet->Cells by name (for
example 'A1') for a cell:
$sheet = $workbook->Worksheets[0];
$cell = $sheet->Cells['A1'];Hyperlinks
HyperlinkCollection holds the Hyperlink objects attached to a worksheet. Each
Hyperlink wraps its underlying model data (address, sub-address, and display text).
API Reference Summary
| Class/Method | Description |
|---|---|
Workbook->Worksheets | Collection of worksheets in the workbook |
Worksheet->Cells | Cell collection for the sheet, indexable by name |
HyperlinkCollection | Collection of Hyperlink objects on a worksheet |
Hyperlink | A single hyperlink attached to a worksheet |