A JADE module to download a pdf of the currently selected range

download_pdf.js

function auto_exec(){
 
    Jade.open_automations(true, "Automations", [
         {action:"Excel.run(make_pdf)",
          name:"Make a PDF",
          description:"Builds and downloads a PDF file"}
     ])  
         
     Jade.add_library('https://cdn.jsdelivr.net/npm/pdfmake@latest/build/pdfmake.min.js')
     Jade.add_library('https://cdn.jsdelivr.net/npm/pdfmake@latest/build/vfs_fonts.min.js')
     Jade.add_library('https://cdn.jsdelivr.net/npm/html-to-pdfmake/browser.js')
   }  
     
   async function make_pdf(){
     const html = await range_to_html_table()
     const val = htmlToPdfmake(html); 
     createPdf({content:val}).download();
   }
   
   async function range_to_html_table(){
     return await Excel.run(async function(excel){
       const range = excel.workbook.getSelectedRange()
       range.load("values")
       await excel.sync();
       const table=['<table style="border-collapse: collapse;border: 1px solid black;">']
       for(const row of range.values){
         table.push("<tr>")
         for(const col of row){
           table.push("<td>")
           table.push(col)
           table.push("</td>")
         }
         table.push("</tr>")
       }
       table.push("</table>")
       return table.join("")
     })
   }