Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function extractTextOnOpen() {
- //ADD YOUR VALUES BELOW
- var folderName = "stickers_png";
- var sheetId = "1YgoXRf8nGVghizvS7340c9J0IAZPjVH6OlNlmKSWrvY";
- //
- // //Define folder
- var folder = DriveApp.getFoldersByName(folderName).next();
- var folderId = folder.getId();
- //
- //Find all pngs in folder
- var images = folder.getFilesByType("image/png");
- while (images.hasNext()) {
- //Convert each jpeg to a Google Doc with OCR
- var image = images.next();
- var imageName = image.getName();
- var docName = imageName.split("\.")[0];
- var file = {
- title: docName,
- mimeType: "image/png"
- }
- Drive.Files.insert(file, image, {ocr: true , ocrLanguage: "ru"});
- //Store newly-created Google Doc in project folder
- var newFile = DriveApp.getFilesByName(docName).next();
- folder.addFile(newFile);
- var rootFolder = DriveApp.getRootFolder();
- rootFolder.removeFile(newFile);
- }
- //Find all Google Docs in folder
- var docs = folder.getFilesByType("application/vnd.google-apps.document");
- //Set up spreadsheet
- var ss = SpreadsheetApp.openById(sheetId);
- SpreadsheetApp.setActiveSpreadsheet(ss);
- Logger.log('File name: ' + ss.getName());
- var sheet = SpreadsheetApp.getActiveSheet();
- sheet.clear();
- sheet.appendRow(["Filename", "Text"]);
- //Populate spreadsheet with OCR text
- while (docs.hasNext()) {
- var file = docs.next();
- var docId = file.getId();
- var doc = DocumentApp.openById(docId);
- var name = doc.getName();
- var body = doc.getBody().getText();
- //Add item data to spreadsheet
- sheet.appendRow([name, body]);
- }
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement