====== Google Apps-script ====== * [[https://developers.google.com/apps-script/reference/|Apps-script Reference]] * Une excellente série d'articles: http://googleappscripting.com/doget-dopost-tutorial-examples/ ===== Scripts ===== Les projets: * Sheets to PDF https://gitlab.com/Artefacts/google-apps-scripts/sheets-to-pdf * Search a Sheet https://gitlab.com/Artefacts/google-apps-scripts/search-a-sheet ==== Exporter en PDF chaque feuille d'un classeur ==== Il n'y a pas de fonction dans [[https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app|SpreadsheetApp]] pour exporter en PDF, il faut passer par [[https://developers.google.com/apps-script/reference/drive/drive-app|DriveApp]]. Inspirations: * [[https://gist.github.com/primaryobjects/6370689c6f5fd3799ea53f89551eced7|Export a Google Drive spreadsheet to PDF in Google Drive in the same folder]] * [[https://www.drzon.net/posts/export-all-google-sheets-to-csv/|Export all Google Sheets to csv]] * [[https://stackoverflow.com/questions/17644554/how-to-download-export-sheets-in-spreadheet-via-google-apps-script|How To Download / Export Sheets In Spreadheet Via Google Apps Script]] * [[https://stackoverflow.com/questions/11619805/using-the-google-drive-api-to-download-a-spreadsheet-in-csv-format/22885826#22885826|Using the google drive API to download a spreadsheet in csv format]] *