Google-Sheet-OCR

gistfile1.txt

function doOCR() {
  //
    //var folder = DriveApp.getFoldersByName('sanGennaro');
    var folder = DriveApp.getFoldersByName('sanGennaro').next();
    if(folder){
      Logger.log(folder);
     
      var images = folder.getFiles();
         Logger.log(images.lenght);
        for(i = 0; i < images.length; i++) {
           var image = images[i].getBlob();
           SpreadsheetApp.getActiveSheet().insertImage(image, i, 1)
           
           var file = {
             title: 'OCR File',
             mimeType: 'image/png'
           };
          
          // OCR is supported for PDF and image formats
          file = Drive.Files.insert(file, image, {ocr: true});
          var doc = DocumentApp.openByUrl(file.embedLink);
          var body = doc.getBody().getText();
          
          
          // Print the Google Document URL in the console
          Logger.log("body: %s", body);
          Logger.log("File URL: %s", file.embedLink);
          //Get link Doc that Generated
          SpreadsheetApp.getActiveSheet().getRange(i, 2).setValue(file.embedLink);
          //Get Content of Doc that Generated
          SpreadsheetApp.getActiveSheet().getRange(i, 3).setValue(body);
        
        }
    }
  
  
}



function doOCRfromUrlImg() {
  //
  var activeCol = SpreadsheetApp.getActiveSheet().getActiveCell().getColumn();
  var activeRow = SpreadsheetApp.getActiveSheet().getActiveCell().getRow();
  
  var valueURL = "https://docs.google.com/uc?export=download&id=1ZXGiSUAlT3dYCTNGnQXwKDdG5iBaUjF_";
  
  var image = UrlFetchApp.fetch(valueURL).getBlob();

  var file = {
    title: 'OCR File',
    mimeType: 'image/png'
  };
  
  // OCR is supported for PDF and image formats
  file = Drive.Files.insert(file, image, {ocr: true});
  var doc = DocumentApp.openByUrl(file.embedLink);
  var body = doc.getBody().getText();
 
  
  // Print the Google Document URL in the console
  Logger.log("body: %s", body);
  Logger.log("File URL: %s", file.embedLink);
  //Get link Doc that Generated
  SpreadsheetApp.getActiveSheet().getRange(activeRow, activeCol + 2).setValue(file.embedLink);
  //Get Content of Doc that Generated
  SpreadsheetApp.getActiveSheet().getRange(activeRow, activeCol + 1).setValue(body);
}


function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('OCR Tools')
      .addItem('Digitaliza Etiquetas', 'main')
      .addItem('Contabiliza', 'doOCRALL')
      .addSeparator()
      .addSubMenu(ui.createMenu('Sobre')
          .addItem('Info', 'menuItem2'))
      .addToUi();
}

function menuItem2() {
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
     .alert('Fabrizio Salvade');
}