Untitled

function onOpen() {
  // Add a custom menu to the spreadsheet.
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
      .createMenu('產生結果')
      .addItem('產生html到GoogleDrive(測試)', 'genhtmltoGD')
      .addToUi();
}

function genhtmltoGD(){
  FileName='Test_Donation_Page.html';
  var tic = Date.now();
  var doc = SpreadsheetApp.getActiveSpreadsheet();
  doc.toast("UPDATING.....");

  var sheetnamein = "輸出準備區";
  var sheetin = doc.getSheetByName(sheetnamein);
  var value_first = sheetin.getRange(2, 1, 1, 3).getDisplayValues();
  var value = sheetin.getRange(3, 1, sheetin.getMaxRows()-2, 3).getDisplayValues();

  var output_text="★Monthly Stars★：(๑′ܫ`)/[★TOP★]\(๑′ܫ`)o→"+value_first[0][0]+" - $"+value_first[0][1];
  for (var i in value){
      key=value[i][0];
      if(key=="") break;
      output_text=output_text+"　"+value[i][2]+value[i][0]+" - $"+value[i][1];
  }
  var output_html=
      "<!DOCTYPE html>\
       <meta charset=\"UTF-8\" />\
       <title>Example</title>\
       <script type=\"text/javascript\" src=\"jquery.min.js\"></script> \
       <script type=\"text/javascript\" src=\"jquery.marquee.min.js\"></script> \
       <link type=\"text/css\" href=\"jquery.marquee.min.css\" rel=\"stylesheet\" media=\"all\" /> \
       <!-- HTML -->    \
       <div class=\"example1\"> \
           <ul class=\"marquee\"><li>"+output_text+"</li></ul> \
       </div> \
       <script type=\"text/javascript\"> \
           $(document).ready(function (){ \
               $(\".marquee\").marquee({ \
                   showSpeed: 0, \
                   scrollSpeed: 25, \
                   pauseOnHover: false, \
                   pauseSpeed: 0, \
                   loop: -1 \
               }); \
           }); \
      </script>";
  FilesIt=DriveApp.getFilesByName(FileName)
  while(FilesIt.hasNext()) {
    DriveApp.removeFile(FilesIt.next());
  }
  FileID=DriveApp.createFile(FileName, output_html, MimeType.HTML);
  FileUrl=FileID.getDownloadUrl();
  FileUrl=FileUrl.replace("&gd=true","")
  var destinationRange = sheetin.getRange(3, 7, 1, 1);
  destinationRange.setValues([["=HyperLink(\""+FileUrl+"\",\"點我下載\")"]]);
}