SpreadJS 13
SpreadJS Documentation / Sample Code / Sample Code for Rows and Columns / Customizing the Headers
In This Topic
    Customizing the Headers
    In This Topic

    You can specify the header text.

    Customize headers

    Using Code

    This example puts custom text in the headers.

    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