Student Result with Page Print

नमस्‍कार दोस्‍तो,

इस ब्‍लॉग में हम आपको बहुत ही सरल भाषा में बतायेगें की किस प्रकार गुगल शीट के डेटा से Student का Result केसे बनाया जाता है ा

In this blog we will tell you Student Result with Page Print so read the complete blog carefully and learn Student Result with Page Print according to given guidelines.

Practical For Click :- Practical

Step 1 :- Click to Google Sheet Copy With Source Code

Step 2 :- Click to >> Extensions >> App Script >>

Step 3 :- Create 7 file Name Given Below

Kode.gs

index.html

Macros.html

Form-js.html

stylecss.html

css.html

js.html

Step 4 :- Click to Copy Below Code and Paste to Kode.gs File

function doGet() { return HtmlService.createTemplateFromFile('index').evaluate() .setTitle("Result") .addMetaTag('viewport', 'width=device-width, initial-scale-1.0') .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL); } function include(filename){ return HtmlService.createHtmlOutputFromFile(filename).getContent(); }

Step 5 :- Click to Copy Below Code and Paste to index.html File

<!DOCTYPE html>
<html lang="en">
    <head>
         <meta charset="UTF-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  <meta http-equiv="X-UA-Compatible" content="ie=edge" />
  <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr"
    crossorigin="anonymous">
        <title>RAPORT</title>   
    </head>
  <?!= include('stylecss'); ?>

<body>
<div id = "Komponen"></div>
<div id = "BoxMessage">

<div>
<div id = "JudulMsg"></div>
<div id = "IsiMsg"></div>
<div id = "AkhirMsg"></div>
</div>
</div>

<div id="objek">
<center><img src="https://lh4.googleusercontent.com/wwzupQPyFKkqhY2_fwM5X88Lyqn1IqV47j784NvULzFYEpRbzzfnNVSJWcEJhXa_4WQTC8Ytk5VsvjepWaYqmTrr9GnKEvYz99R8qqZBHVxsT1-jiPS06NS_kbp8UCw_1g=w1280"><br>
<h4 style="margin-top: 3px;">Sunrise IT Education<br></h4></center><hr style="width:85%;margin-top:-10px">

<center><h4 style="margin-top: 3px;font-size: 13px;">Result<br>Year 2022-2023</h4></center>

   <div class="row"style="margin-left:8%;">
   <label>Roll NO <span style="margin-left: 60px;font-size: 12px;">:</span></label>
   <input id="Jnc1" style="width: 12%;font-size: 15px;" type="" name=""placeholder="Roll NO Enter">
   <button id = "btncari" style="width: Auto; height: 22px;background-color:#91d6ed;">SEARCH</button><br>

   <label>Student Name <span style="margin-left: 17px;font-size: 12px;">:</span></label>
   <input id="Jnc2" style="width: 25%;font-size: 15px;" type="" name=""disabled><br><br>
   <label>Father Name <span style="margin-left: 6px;font-size: 12px;">:</span></label>
   <input id="Jnc3" style="width: 12%;font-size: 15px;" type="" name=""disabled><br><br>
   <label>Gender <span style="margin-left: 60px;font-size: 12px;">:</span></label>
   <input id="Jnc4" style="width: 12%;font-size: 15px;" type="" name=""disabled>
  </div>

     <?!= include('css'); ?>
<div class="container-fluid p-0">
      <nav class="navbar navbar-expand-lg">
          <ul class="navbar-nav"style="font-size:13px;">
            <a class="nav-item dropdown">
              <div class="dropdown">
                <a class="nav-link"style="color:#000;margin-left:5%;">
                <img src="https://drive.google.com/uc?id=1URkLsYAIwkbutyf3jXsJyrtrW7a16gy8"style="width:20px"></a>
                <div class="dropdown-content"style="margin-left:5%;">
                  <button id = "btncari" style="width: 100%; height: 22px;background-color:#91d6ed;">SEARCH</button><br>
                  <button id = "btnbersih" style="width: 100%; height: 22px;background-color:#dbd524;">RESTART</button><br>
                  <button id = "btnubah" style="width: 100%; height: 22px;background-color:#96ee96;">UPDATE</button><br>
                  <button id = "btnhapus" style="width: 100%; height: 22px;background-color:#b17c7c;" onclick ="Confirm.Execute()">DELETE</button><br>
                  <button id = "btnsimpan" style="width: 30%; height: 22px" value="Save" hidden> 
                </div>
              </div>
          </ul>
      </nav>
    </div> 

  <form action="" method="POST" id="form">
  <center>
  <table width=85% >

  <tr>
    <th rowspan="2"style="width: 3%;background-color:#d6d6d6;">Sr. No.</th>
    <th rowspan="2"style="width: 6%;background-color:#d6d6d6;">Subject</th>
    <th rowspan="2"style="width: 6%;background-color:#d6d6d6;">1st Test</th>
    <th rowspan="2"style="width: 6%;background-color:#d6d6d6;">Half Year Exam</th>
    <th rowspan="2"style="width: 6%;background-color:#d6d6d6;">2nd Test</th>
    <th rowspan="2"style="width: 6%;background-color:#d6d6d6;">Final Exam</th>
    <th rowspan="2"style="width: 6%;background-color:#d6d6d6;">Total</th>
  </tr>
  <tr>
  </tr>
  <tr>
    <td class="a"style="text-align: center;font-size:12px;" >1</td>
    <td class="a"><input id="Jnc5" style="width: 99%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc6" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc7" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc8" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc9" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc10" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
  </tr>
   <tr>
    <td class="a"style="text-align: center;font-size:12px;" >2</td>
    <td class="a"><input id="Jnc11" style="width: 99%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc12" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc13" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc14" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc15" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc16" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
  </tr>
   <tr>
    <td class="a"style="text-align: center;font-size:12px;" >3</td>
    <td class="a"><input id="Jnc17" style="width: 99%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc18" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc19" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc20" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc21" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc22" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
  </tr>
  <tr>
    <td class="a"style="text-align: center;font-size:12px;" >4</td>
    <td class="a"><input id="Jnc23" style="width: 99%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc24" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc25" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc26" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc27" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
    <td class="a"><input id="Jnc28" style="text-align: center;width: 98%;"type="text" name=""disabled></td>
  </tr>
  </table>
  <br>
   <label style="margin-left: 40%;">Date Select,</label>
   <input style="width: 15%;margin-left:1%;" type="date" name=""><br>
   <label style="margin-left: 30%;">Signature<br><br><br><span style="margin-left:29%">SiTE</span></label>
   <!--
   <input style="width: 30%;margin-left:47%;font-size: 15px;" type="text" name="" placeholder="Signature">
 -->
  </center>
  </form>
  </div>
   
  
   <p align="center">
    
    <input style="width: 10%;" type="button" onclick="print('form')" value="Print Result"></p>
   <script>
     function Print(form){
      var printdata = document.getElementById(form);
      newwin = window.open("");
      newwin.document.write(printdata.outerHTML);
      newwin.print();
      newwin.close();
     }
    </script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/js/materialize.min.js"></script> 
     <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
    <?!= include('Form-js'); ?>
         <?!= include('js'); ?>
    </body>
</html>

Step 6 :- Click to Copy Below Code and Paste to Macros.html File

Step 7 :- Click to Copy Below Code and Paste to Form-js.html File

Step 8 :- Click to Copy Below Code and Paste to stylecss.html File

Step 9 :- Click to Copy Below Code and Paste to css.html File

Step 10 :- Click to Copy Below Code and Paste to js.html File

Student Result with Page Print