Posted 25 October 2018, 7:36 pm EST
Hello,
SpreadJS does not have anything like that built in.
You can give name to range with AddCustomName method and access that range with same name. For example:
$(document).ready(function () {
var spread = new Gc.Spread.Sheets.Workbook(document.getElementById('ss'), { sheetCount: 1 });
var sheet = spread.getActiveSheet();
sheet.setColumnCount(10);
sheet.setRowCount(10);
sheet.setValue(0, 0, 1);
sheet.setValue(0, 1, 2);
sheet.setValue(0, 2, 3);
sheet.addCustomName("customName3", "=$A$1:$A$6", 0, 0);
var cname = sheet.getCustomName("customName3");
var range = cname.getExpression().getRange();
var startRowIndex = range.row + 1;
var endRowIndex = range.row + range.rowCount;
var startColIndex = range.column + 1;
var endColIndex = range.col + range.columnCount;
alert("Start Row: " + startRowIndex + " Start Col: " + startColIndex)
});
Thanks,
Deepak Sharma