Skip to content

Instantly share code, notes, and snippets.

View deniscanevaro's full-sized avatar

Denis Nicolas Canevaro Fañañan deniscanevaro

1 follower · 7 following
  • Essalud
  • Chiclayo
View GitHub Profile
@deniscanevaro
deniscanevaro / submit.md
Created November 28, 2018 13:53 — forked from tanaikech/submit.md
Benchmark: Loop for Array Processing using Google Apps Script

Benchmark: Loop for Array Processing using Google Apps Script

April 16, 2018 Published.

July 26, 2018 Updated. Result of reduce was added.

@deniscanevaro
deniscanevaro / submit.md
Created November 28, 2018 14:02 — forked from tanaikech/submit.md
Benchmark: Reading and Writing Spreadsheet using Google Apps Script

Benchmark: Reading and Writing Spreadsheet using Google Apps Script

October 12, 2018 Published.

October 18, 2018 Updated. In order to compare with Advanced Google Service, a result of Sheets API by UrlFetchApp was added to Appendix.

@deniscanevaro
deniscanevaro / submit.md
Created December 6, 2018 21:33 — forked from tanaikech/submit.md
Converting PDF to TXT

Converting PDF to TXT

This is a sample script for converting a PDF file to a TXT file. 2 steps are required for this.

  1. Upload a PDF file as a Google Document
  2. Download a Google Document as a TXT file

In this sample, Python Quickstart is used. The detail information is https://developers.google.com/drive/v3/web/quickstart/python. Please read "Step 1: Turn on the Drive API" and "Step 2: Install the Google Client Library".




  


  




    


          
    

      

        
        

          

              @deniscanevaro
          

          

            
                deniscanevaro
                / submit.md
            
            

              Created
              December 6, 2018 22:14
                — forked from tanaikech/submit.md
            

              
                Asynchronous Processing using Event Triggers
              
          

        

      

        

  

      

    


Asynchronous Processing using Event Triggers


September 21, 2018
    Published.

Kanshi Tanaike




  


  




    


          
    

      

        
        

          

              @deniscanevaro
          

          

            
                deniscanevaro
                / submit.md
            
            

              Created
              December 6, 2018 22:15
                — forked from tanaikech/submit.md
            

              
                Expanding A1Notations using Google Apps Script
              
          

        

      

        

  

      

    
Expanding A1Notations using Google Apps Script


This is a sample script for expanding a1Notations using Google Apps Script (GAS). In this script, for example, "A1:E3" is expanded to "A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3, C3, D3, E3". When each cell in "A1:E3" is checked, this script might be able to be used. If this was useful for your situation, I'm glad.


Script:


function expandA1Notation(a1Notations) {
  var columnToLetter = function(column) {
    var temp, letter = '';
 while (column > 0) {



  


  




    


          
    

      

        
        

          

              @deniscanevaro
          

          

            
                deniscanevaro
                / readme.md
            
            

              Created
              December 7, 2018 11:57
                — forked from tanaikech/readme.md
            

              
                Retrieving Access Token for Service Account using Google Apps Script
              
          

        

      

        

  

      

    
Retrieving Access Token for Service Account using Google Apps Script


This is a sample script for retrieving the access token for Service Account using Google Apps Script. The flow for using this script is as follows.


    

  1. At first, please create the Service Account and retrieve JSON file.
    2. 

  2. Put Scopes, private_key and client_email to the script.
    3. 

  3. Run the script.
    4. 



var private_key = "#####"; // private_key of JSON file retrieved by creating Service Account
var client_email = "#####"; // client_email of JSON file retrieved by creating Service Account