The setLink function is established to set a link into a cell.
var excel = new Excel("test.xlsx");
excel.createSheet("newSheet")
.createSheet("linkSheet")
.setLink("newSheet","A1","#\'linkSheet'!A1"); // To set a link into a cell.| Calling | Returning |
|---|---|
| Excel . setCell ( sheetName , position , linkUrl ) | Excel |
| Parameters | Type | Description |
|---|---|---|
| sheetName | String | The sheet name. |
| position | String | The cell position for add a link. |
| linkUrl | String | The Url for link to a sheet. |