SpreadJS Documentation
Customizing the Headers
SpreadJS Documentation > Sample Code > Sample Code for Rows and Columns > Customizing the Headers

You can specify the header text.

Using Code

This example puts custom text in the headers.

JavaScript
Copy Code
$(document).ready(function () {
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
    var sheet = spread.getActiveSheet();

//Set the desired string in headers
sheet.setValue(0, 1, "Column Header", GC.Spread.Sheets.SheetArea.colHeader);
sheet.setValue(1, 0, "Row Header", GC.Spread.Sheets.SheetArea.rowHeader);
sheet.setColumnWidth(1, 120.0,GC.Spread.Sheets.SheetArea.colHeader);
sheet.setColumnWidth(0, 90.0,GC.Spread.Sheets.SheetArea.rowHeader);
});
See Also

Developer's Guide

Creating Multiple Headers

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page