Export to PDF

[joaquinniicolas]

I'm new here. What's the best way to export a spreadsheet to PDF?

Advice please.

[joaquinniicolas]

a bit of the logic i was doing:

const rangePrintable = sheet.getSheet().getCellMatrixPrintRange();
       if (!rangePrintable) {
         continue;
       }

       const range: IRange = {
         startRow: rangePrintable?.startRow,
         startColumn: rangePrintable?.startColumn,
         endRow: rangePrintable.endRow,
         endColumn: rangePrintable.endColumn
       };
       const columnWidthAcc = sheet.getSkeleton()?.columnWidthAccumulation[range.endColumn];
       const currentTableWidth = columnWidthAcc ? columnWidthAcc : MAX_PRINT_WIDTH_PX;

       if (currentTableWidth > MAX_PRINT_WIDTH_PX) {
         let requiredScaleFactor = (MAX_PRINT_WIDTH_PX / currentTableWidth) * 1;
         if (finalScaleFactor === 1.0 || requiredScaleFactor < finalScaleFactor) {
           finalScaleFactor = requiredScaleFactor;
         }
       }


       const rawData = sheet.getRange(range).generateHTML();
       const tempWrapper = document.createElement('div');
       tempWrapper.innerHTML = rawData;
       const tableElement = tempWrapper.querySelector('table');

       if (!tableElement) {
         continue; 
       }
       tableElement.style.width = 'auto';
       tableElement.style.minWidth = '100%';
       tableElement.style.borderCollapse = 'collapse';
       const sheetHtml = `
       <div class="chapter-container ${sheetProgress === 1 ? 'first-chapter' : ''}">
         <h2 class="chapter-title">${sheet.getSheetName()}</h2>
         ${tableElement.outerHTML}
       </div>`;