We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback
Essential JS2

Syncfusion jQuery based widgets are no longer in active development. Switch to our pure JavaScript based next generation Essential JS 2 library.

Cell range indexes with ejSpreadsheet

Thread ID:





141892 Jan 9,2019 04:09 PM UTC Jan 10,2019 07:03 AM UTC jQuery 1
Tags: ejSpreadSheet
Asked On January 9, 2019 04:09 PM UTC

Sorry if I missed it somewhere, but when using the hyperlink functionality, is there a way to use cell range indexes as opposed to the traditional cell names? For example

Instead of this: $("#Spreadsheet").ejSpreadsheet("setHyperlink", "C5", { "webAddr": "www.google.com"}, 1);

Can I reference C5 using something like [3,5]?

Silambarasan I [Syncfusion]
Replied On January 10, 2019 07:03 AM UTC

Hi Anthony, 
Thank you for contacting Syncfusion support. 
Yes, we can pass the cell reference as array value to set the hyperlink in Spreadsheet. But, it should be in the format of [StartRowIndex, StartColumnIndex, EndRowIndex, EndColumnIndex] i.e. in your case, you should pass C5 as [2, 4, 2, 4] (note: it is zero based index). Please refer the below sample and code example. 
$("#Spreadsheet").ejSpreadsheet("setHyperlink", [4, 2, 4, 2], { "webAddr": "https://www.google.com" }, 1); 
Please get back to us if you require any further assistance. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon