Employee Attendance Record

The following sample shows how you can use the SpreadJS spreadsheet to create useful templates that track your teams' yearly attendance.

The example is loading a predefined template using fromJSON. Record all the employee leaves on the Leave Tracker page or add specific company holidays on the Holiday sheet and see that how the data changes. Change the Employee - from dropdown below to retrive data from different employees. Print the information by clicking the Print button.
window.onload = function () { var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 1 }); initSpread(spread); }; function initSpread(spread) { spread.suspendPaint(); spread.fromJSON(data); var sheet = spread.sheets[0]; var printInfo = sheet.printInfo(); printInfo.showBorder(false); printInfo.showGridLine(false); printInfo.showColumnHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide); printInfo.showRowHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide); var style = new GC.Spread.Sheets.Style(); style.cellButtons = [ { caption:"Print", buttonBackColor: "#FA896B", hoverBackColor: "#CCCCCC", useButtonStyle: true, width:150, height:70, command: (sheet, row, col, option) => { spread.print(0); } } ]; style.foreColor = "white"; style.font = "15pt Calibri"; sheet.setStyle(0, 20, style); spread.resumePaint(); }
<!doctype html> <html style="height:100%;font-size:14px;"> <head> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/purejs/node_modules/@grapecity/spread-sheets/styles/gc.spread.sheets.excel2013white.css"> <script src="$DEMOROOT$/en/purejs/node_modules/@grapecity/spread-sheets/dist/gc.spread.sheets.all.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/en/purejs/node_modules/@grapecity/spread-sheets-print/dist/gc.spread.sheets.print.min.js" type="text/javascript"></script> <script src="$DEMOROOT$/spread/source/js/license.js" type="text/javascript"></script> <script src="$DEMOROOT$/spread/source/data/attendance-record.js" type="text/javascript"></script> <script src="app.js" type="text/javascript"></script> <link rel="stylesheet" type="text/css" href="styles.css"> </head> <body> <div class="sample-tutorial"> <div id="ss" style="width:100%;height:100%"></div> </div> </body> </html>
.sample-tutorial { position: relative; height: 100%; overflow: hidden; } body { position: absolute; top: 0; bottom: 0; left: 0; right: 0; }