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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

this.setBorder line format using rowIndex & colIndex inquiry

Thread ID:





131577 Jul 17,2017 04:28 PM UTC Jul 18,2017 11:58 AM UTC ASP.NET Core 1
Tags: Spreadsheet
Jacob Knight
Asked On July 17, 2017 04:28 PM UTC

In the documentation I've seen the format:
this.setBorder({ type: "allborder", color: "#000000", style: "solid" }, "A5:V11");

I was wondering if there is a way to use the row and column indexes similar to how we update cell values:
this.XLEdit.updateCellValue({ rowIndex: aNumber, colIndex: aNumber }, someValue);

Silambarasan I [Syncfusion]
Replied On July 18, 2017 11:58 AM UTC

Hi Jacob, 
Thank you for using Syncfusion products. 
We have checked your requirement and it has been achieved by using ‘getRangeIndices()’ client-side method in Spreadsheet. Please refer the following code example. 
var ssObj = $("#Spreadsheet").data("ejSpreadsheet"), cellValue = "SomeValue", 
    cellAddress = "A2"; 
//Update by cell address 
range = ssObj.getRangeIndices(cellAddress); 
ssObj.XLEdit.updateCellValue({ rowIndex: range[0], colIndex: range[1] }, cellValue); 
//You can also convert the range e.g: [0,0,0,0] to cell address by using ssObj.getAlphaRange() 
// ssObj.getAlphaRange(0,0,0,0); // returns "A1" 
Using updateCellVaue(), you can update value and format for single cell only. If you want to update multiple cells with unique value, you can use the ‘updateUniqueData()’ client-side method else use the ‘updateRange()’ method to update range of cells based on defined sheet settings. Please refer the following API links for more information. 
Could you please check the above information and get back to us if we misunderstood your requirement? 


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