CasusNO

Code : Tout sélectionner

function copyToRestructuredText() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  
  var tabWidth = [];
  var output = "";
  
  for (var i = 0; i < data.length; i++) {
    for (var j = 0; j < data[i].length; j++) {
      if (isNaN(tabWidth[j])) tabWidth[j] = 0;
      
      var val = data[i][j].toString(); // conversion en string
      
      tabWidth[j] = Math.max(tabWidth[j], val.length);
    }
  }
  
  var sep = separator(tabWidth);
  
  output += separator(tabWidth);
  for (var i = 0; i < data.length; i++) {
    if (i == 1) {
      output += separator(tabWidth);
    }
    var line = []
    for (var j = 0; j < data[i].length; j++) {
      line.push(padding(data[i][j].toString(), tabWidth[j]));
    }
    output += line.join(" ") + "\n";
  }
  output += separator(tabWidth);
  
  showDialog(output);
}

function showDialog(text) {
  var app = UiApp.createApplication();
  app.setTitle("Tableau à copier");
  
  var panel = app.createVerticalPanel();
  
  var textArea = app.createTextArea();
  textArea.setText(text).setSize("400", "300").setStyleAttribute("fontFamily", DocumentApp.FontFamily.COURIER_NEW);

  panel.add(textArea);
  
  app.add(panel);
  var doc = SpreadsheetApp.getActive();

  doc.show(app);
}


function separator(tabWidth) {
  function printSeparatorCol(len) {
    var col = "";
    for (var i = 0; i < len; i++) 
      col += "=";
    
    return col;
  }
  return tabWidth.map(printSeparatorCol).join(" ") + "\n";
}

function padding(value, max) {
  var l = value.toString().length
  if (l < max) {
    return padding(" " + value, max);
  }
  return value;
}

function onOpen() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var entries = [{
    name : "Copier au format texte",
    functionName : "copyToRestructuredText"
  }];
  spreadsheet.addMenu("Casus-NO", entries);
};