Skip to content

Latest commit

 

History

History
24 lines (18 loc) · 601 Bytes

excel.setLink.md

File metadata and controls

24 lines (18 loc) · 601 Bytes

Excel.setLink

The setLink function is used to set a link into a cell.

Sample

var excel = new Excel("test.xlsx");
excel.createSheet("newSheet")
.createSheet("linkSheet")
.setLink("newSheet","A1","#\'linkSheet\'!A1");		// To set a link into a cell.

API

Calling Returning
excel. setLink ( sheetName, position, linkUrl ) Excel
Parameters Type Description
sheetName String The sheet name.
position String The cell position for adding a link.
linkUrl String The URL for linking to a sheet.