Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function extractTextOnOpen() {
  2.  
  3.     //ADD YOUR VALUES BELOW
  4.     var folderName = "stickers_png";
  5.     var sheetId = "1YgoXRf8nGVghizvS7340c9J0IAZPjVH6OlNlmKSWrvY";
  6. //
  7. //    //Define folder
  8.     var folder = DriveApp.getFoldersByName(folderName).next();
  9.     var folderId = folder.getId();
  10. //
  11.     //Find all pngs in folder
  12.     var images = folder.getFilesByType("image/png");
  13.     while (images.hasNext()) {
  14.         //Convert each jpeg to a Google Doc with OCR
  15.         var image = images.next();
  16.         var imageName = image.getName();
  17.         var docName = imageName.split("\.")[0];
  18.         var file = {
  19.             title: docName,
  20.             mimeType: "image/png"
  21.         }
  22.         Drive.Files.insert(file, image, {ocr: true , ocrLanguage: "ru"});
  23.         //Store newly-created Google Doc in project folder
  24.         var newFile = DriveApp.getFilesByName(docName).next();
  25.         folder.addFile(newFile);
  26.         var rootFolder = DriveApp.getRootFolder();
  27.         rootFolder.removeFile(newFile);
  28.     }
  29.  
  30.     //Find all Google Docs in folder
  31.     var docs = folder.getFilesByType("application/vnd.google-apps.document");
  32.  
  33.     //Set up spreadsheet
  34.     var ss = SpreadsheetApp.openById(sheetId);
  35.     SpreadsheetApp.setActiveSpreadsheet(ss);
  36.     Logger.log('File name: ' + ss.getName());
  37.     var sheet = SpreadsheetApp.getActiveSheet();
  38.     sheet.clear();
  39.     sheet.appendRow(["Filename", "Text"]);
  40.  
  41.     //Populate spreadsheet with OCR text
  42.     while (docs.hasNext()) {
  43.         var file = docs.next();
  44.         var docId = file.getId();
  45.         var doc = DocumentApp.openById(docId);
  46.         var name = doc.getName();
  47.         var body = doc.getBody().getText();
  48.         //Add item data to spreadsheet
  49.         sheet.appendRow([name, body]);
  50.     }
  51. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement