SpreadJS 15
Features / Print / Print Background Image As Watermark
In This Topic
    Print Background Image As Watermark
    In This Topic

    SpreadJS enables users to print any background image of their choice as a watermark.

    This feature is useful especially when users want to print worksheets along with their company logo, tagline, copyright information or any other data embedded in the background of each page or several pages so as to indicate the authenticity of their brand or simply protect their content from getting copied by any other organisation. 

    The watermark() method of the PrintInfo class can be used to print background image as watermark.

    Using Code

    Refer to the following example code in order to print background image as watermark.

    Copy Code
    <!DOCTYPE html>
    <script src="https://code.jquery.com/jquery-2.1.1.min.js" type="text/javascript"></script>
    <link href="css/gc.spread.sheets.excel2013white.12.2.0.css" rel="stylesheet" />
    <script src="scripts/gc.spread.sheets.all.12.2.0.min.js"></script>
    <script src="scripts/gc.spread.sheets.print.12.2.0.min.js"></script>
    $(document).ready(function ()
     // Initializing Spread
     var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'),  { sheetCount: 1 });
    // Fetch ActiveSheet
    activeSheet = spread.getSheet(0);
    // Set Sheet's RowCount/ ColCount
    // Set value
    for (var r = 0, rc = activeSheet.getRowCount(); r < rc; r++) {
    for (var c = 0, cc = activeSheet.getColumnCount(); c < cc; c++) {
    activeSheet.setValue(r, c, r + c);
    var printInfo = activeSheet.printInfo();
    // For printing watermark on all pages
    var watermark1 = { x: 0, y: 0, width: 80, height: 80, imageSrc: "../image/gc1.png", page: "all" };
    // For printing watermark on selected pages
    var watermark2 = { x: 650, y: 1000, width: 100, height: 80, imageSrc: "../image/gc2.png", page: "0,1,3" };
     printInfo.watermark([watermark1, watermark2]);
    $("#print").click(function ()
    <input type="button" style=" margin-left:16px" id="print" value="Click to Print">
    <div id="ss" style="height:400px;width:600px"></div>