Code.gs
function showDialog() {
var template = HtmlService.createTemplateFromFile("MenuOpload").evaluate();
SpreadsheetApp.getUi().showModalDialog(template, "File Upload");
}
function uploadFileToGoogleDrive(data, name, type) {
var datafile = Utilities.base64Decode(data);
var blob2 = Utilities.newBlob(datafile, type, name);
var folder = DriveApp.getFolderById("1xlIHqLzja2liarS6soL4nTNjfqfVjA9F");
var newFile = folder.createFile(blob2);
var id1 = newFile.getId();
var imageRange = SpreadsheetApp.getActive().getSheetByName("FORM").getRange("H5");
imageRange.setFormula("=Image(\"http://drive.google.com/uc?export=view&id=" + id1 + "\",1)");
var rowData = [
newFile.getName(),
newFile.getId(),
newFile.getUrl(),
newFile.getSize(),
newFile.getDateCreated()
];
SpreadsheetApp.getActive().getSheetByName("DATAFILEFOTO").appendRow(rowData);
return newFile.getUrl()
}
Index.html
<input type="file" id="file">
<input type="button" id="upload" value="Upload" class="action" onclick="uploadFiles()">
<p id="msg"></p>
<script>
var fileUploader = document.getElementById("file");
var msg = document.getElementById("msg");
function uploadFiles(){
msg.innerHTML = "Uploading file . . . . .";
var file = fileUploader.files[0];
var reader = new FileReader();
reader.readAsDataURL(file)
reader.onload = function() {
var rawLog = reader.result.split(',')[1];
google.script.run
.withSuccessHandler(function (a){
msg.innerHTML = "Uploaded at <a href="+a+" target='_blank'>"+a+"</a>";
})
.uploadFileToGoogleDrive(rawLog,file.name, file.type );
};
}
</script>
Tidak ada komentar:
Posting Komentar