More than 3 years have passed since last update.

スプレッドシートの表をアプリで表示させる方法

Posted at 2021-01-27

スプレッドシートの下記のシートを

Google Apps Scriptのアプリケーションで下記のように表示させるコードです。

code.gs

function doGet() {
  const html = HtmlService.createTemplateFromFile("index");
  return html.evaluate();
}

function getData() {
  const sht = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('シート1');
  return sht.getDataRange().getValues();
}

index.html

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
    <style>
      
      /* ここら辺は適当に */
      table{
        width: 500px;
        border: solid 1px #000000;
        border-collapse: collapse;
        margin: 20px;
      }
      
      th{
        border: solid 1px #ffffff;
        padding: 8px 12px 8px 12px;
        background-color: #000;
        color: #ffffff;
        }
        
      td{
        border: solid 1px #000000;
        padding: 7px 10px 7px 10px;
        }
      
    </style>
  </head>
  <body>
  
    <table>
      <?
        const data = getData();
        const header = data.shift();

        output._ = '<tr>';
        for(const column of header){
          output._ = '<th>'+ column +'</th>';
        }
        output._ = '</tr>';

        for(const record of data){
          output._ = '<tr>';
          for(const cell of record){
            output._ = '<td>'+ cell +'</td>';
          }
          output._ = '</tr>';
        }
      ?>
    </table>
  </body>
</html>

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up