| .next | |
| public | |
| node_modules | |
| yarn.lock | |
| package-lock.json | |
| **/*.test.js | |
| coverage |
| //https://gist.github.com/chemiadel/bee4cb03481b580275d5296a3e7adc0d | |
| function EmailPDF() { | |
| //Get Active Spreadsheet | |
| var spreadSheet=SpreadsheetApp.getActiveSpreadsheet(); | |
| //Get All Sheets of the spreadsheets | |
| var sheets=spreadSheet.getSheets(); | |
| //Sheet wanted to export on PDF |
| sub ReadPDF() | |
| 'NOTE: Adobe Acrobat Pro XI or higher has to be installed and the following references have to be active: | |
| 'Adobe Acrobat 10.0 Type Library (acrobat.tlb) Usually found in: C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\ | |
| 'Acrobat Access 3.0 Type Library (Accessibility.api) Usually found in: C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\plug_ins\ | |
| 'To check for active references, see Tools -> References OR use the Immediate window (ctrl + G) and type "for each r in references : debug.Print r.name, r.fullpath : next r" (minus "" quotes) | |
| Dim AcroApp As Acrobat.CAcroApp 'We're going to use the Acrobat 'app', so point to that | |
| Dim theForm As Acrobat.CAcroPDDoc 'Define that we're going to use a Acrobat Form (known as PDF) |
| function exportSpreadsheet() { | |
| //All requests must include id in the path and a format parameter | |
| //https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export | |
| //FORMATS WITH NO ADDITIONAL OPTIONS | |
| //format=xlsx //excel | |
| //format=ods //Open Document Spreadsheet | |
| //format=zip //html zipped | |
| function downloadString(text, fileType, fileName) { | |
| var blob = new Blob([text], { type: fileType }); | |
| var a = document.createElement('a'); | |
| a.download = fileName; | |
| a.href = URL.createObjectURL(blob); | |
| a.dataset.downloadurl = [fileType, a.download, a.href].join(':'); | |
| a.style.display = "none"; | |
| document.body.appendChild(a); | |
| a.click(); |
People
 :bowtie: |
😄 :smile: |
😆 :laughing: |
|---|---|---|
😊 :blush: |
😃 :smiley: |
:relaxed: |
😏 :smirk: |
😍 :heart_eyes: |
😘 :kissing_heart: |
😚 :kissing_closed_eyes: |
😳 :flushed: |
😌 :relieved: |
😆 :satisfied: |
😁 :grin: |
😉 :wink: |
😜 :stuck_out_tongue_winking_eye: |
😝 :stuck_out_tongue_closed_eyes: |
😀 :grinning: |
😗 :kissing: |
😙 :kissing_smiling_eyes: |
😛 :stuck_out_tongue: |
| <!doctype html> | |
| <html> | |
| <head> | |
| <!-- Priority tags. These must come first. --> | |
| <meta charset="utf-8"> | |
| <meta http-equiv="x-ua-compatible" content="ie=edge; chrome=1"> <!-- Render Chrome if available or using latest version of Internet Explorer (Recommended). --> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no"> | |
| <!-- Document Title --> | |
| <title>Page Title</title> | |
| <!-- Allows control over where resources are loaded from. Place as early in the document as possible, only applies to content below this tag. --> |
| { | |
| "USD": { | |
| "symbol": "$", | |
| "name": "US Dollar", | |
| "symbol_native": "$", | |
| "decimal_digits": 2, | |
| "rounding": 0, | |
| "code": "USD", | |
| "name_plural": "US dollars" | |
| }, |
| // Lists of countries with ISO 3166 codes, presented in various formats. | |
| // Last Updated: July 30, 2020 | |
| // If you're using PHP, I suggest checking out: | |
| // https://github.com/thephpleague/iso3166 | |
| // or Laravel: https://github.com/squirephp/squire | |
| // | |
| // JS developers can check out: | |
| // https://www.npmjs.com/package/iso3166-2-db | |
| // |