BURHAN OWL

0 %
MUHAMMAD BURHANUDDIN RABBANI
Front-end Developer
Ui/UX Designer
  • Residence:
    Indonesia
  • City:
    Surabaya
  • Age:
    33
Indonesia
English
html
CSS
Photoshop
Photography
WordPress
Office
  • Adobe: Photoshop, Illustrator, inDesign, After Effect
  • Luminar
  • Multimedia: Vegas Pro,
  • Google: Spreadsheet, Data Studio, Script
  • Office: Excel, Word, Powerpoint

CARA MENDAPATKAN LIST FILE DI GOOGLE DRIVE MENGGUNAKAN GOOGLE SCRIPT

September 24, 2020

function myFunction() {

var ss=SpreadsheetApp.getActiveSpreadsheet();

var s=ss.getActiveSheet();

var c=s.getActiveCell();

var fldr=DriveApp.getFolderById(“paste link google drive disini hanya barisan angka dan nomor”);

var files=fldr.getFiles();

var names=[],f,str; while (files.hasNext()) {

f=files.next();

names.push([f.getUrl(), f.getName()]);

}

s.getRange(c.getRow(),c.getColumn(),names.length, 2).setValues(names); }

Posted in UncategorizedTags:
1 Comment
Write a comment
© 2022 All Rights Reserved.
Email: email Me