Excel Forum

Code: Select all

function generateMessage(e)
{
      var Wbook='----------------------';
      var WSheet='Notify_รอเปิดTK';
  
      var ss= SpreadsheetApp.openById(Wbook).getSheetByName(WSheet);
  
      var firstRow = 2;
      var lastRow = ss.getDataRange().getDisplayValues();
      var lastColumn = ss.getLastColumn();
  
      var headerData = ss.getRange("A1:J1").getValues()[0];

      var date = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy")
      var text_data_title = 'ประจำวันที่ '+date;
      var text_data = "";
      var text_message ="";
  
      //for (var j = 2; j < lastRow+1 ; j++) {
       
        var listData = ss.getRange("A"+firstRow+":J"+firstRow).getDisplayValues()[0];
             for (var i = 0; i < lastColumn ; i++) {
                  text_data += "\n" + headerData[i] + " : " + listData[i];
                                                   }  
                                           //}
  for (var j = 0; j < lastRow ; j++) {
     text_message=text_data_title+"\n"+text_data;
      sendNotification(text_data);
      // firstRow=firstRow+1;
  }
}