import HTMLtoDOCX from 'html-to-docx';
import puppeteer from 'puppeteer';
import * as cheerio from 'cheerio';
import ExcelJS from 'exceljs';
// Convert HTML to DOCX Buffer
export const convertToDocx = async (htmlContent, title) => {
// html-to-docx expects a string and options
const fileBuffer = await HTMLtoDOCX(htmlContent, null, {
table: { row: { cantSplit: true } },
footer: true,
pageNumber: true,
title: title
});
return fileBuffer;
};
// Convert HTML to PDF Buffer — rasterizes Three.js canvases via Puppeteer element screenshots
export const convertToPdf = async (htmlContent) => {
const browser = await puppeteer.launch({
headless: 'new',
args: ['--no-sandbox', '--disable-setuid-sandbox', '--enable-webgl', '--use-gl=swiftshader']
});
try {
const page = await browser.newPage();
await page.setViewport({ width: 1280, height: 1800, deviceScaleFactor: 2 });
// Load page — wait for network idle so importmaps + CDN scripts resolve
await page.setContent(htmlContent, { waitUntil: 'networkidle0', timeout: 30000 });
// Check if page has any Three.js canvases
const hasThreeCanvases = await page.evaluate(
() => document.querySelectorAll('canvas[data-threejs]').length > 0
);
if (hasThreeCanvases) {
// Give Three.js time to initialise and render its first frame
console.log('PDF export: Three.js canvases detected — waiting for render...');
await new Promise(r => setTimeout(r, 4000));
// Get all canvas element handles
const canvasHandles = await page.$$('canvas[data-threejs]');
let rasterized = 0;
for (const canvasHandle of canvasHandles) {
try {
// Take a screenshot of just this element using Puppeteer's compositor capture
// This works regardless of preserveDrawingBuffer since it captures screen pixels
const screenshotBuf = await canvasHandle.screenshot({ type: 'png' });
const base64 = screenshotBuf.toString('base64');
const dataUrl = `data:image/png;base64,${base64}`;
// Replace canvas with
in the page DOM
await page.evaluate((canvas, src) => {
const img = document.createElement('img');
img.src = src;
img.style.width = Math.min(canvas.offsetWidth, 700) + 'px';
img.style.maxWidth = '100%';
img.style.height = 'auto';
img.style.display = 'block';
img.style.margin = '0 auto';
img.style.borderRadius = '4px';
img.style.border = '1px solid #d0d8e8';
img.alt = '3D Perspective View (rendered for PDF)';
canvas.parentNode.replaceChild(img, canvas);
}, canvasHandle, dataUrl);
rasterized++;
} catch (canvasErr) {
console.warn('PDF export: could not screenshot canvas, hiding it:', canvasErr.message);
// Gracefully replace with a text note
await page.evaluate((canvas) => {
canvas.style.display = 'none';
const note = document.createElement('div');
note.style.cssText = 'padding:16px;text-align:center;font-size:11px;color:#718096;font-family:Arial;border:1px dashed #e2e8f0;border-radius:4px;margin:8px auto;max-width:700px';
note.textContent = '[ 3D Perspective View — open this document in a browser for an interactive view ]';
canvas.parentNode.insertBefore(note, canvas);
}, canvasHandle);
}
}
console.log(`PDF export: rasterized ${rasterized}/${canvasHandles.length} Three.js canvas(es)`);
}
// Hide any remaining canvases that weren't tagged (safety net)
await page.evaluate(() => {
document.querySelectorAll('canvas:not(img)').forEach(c => {
if (!c.getAttribute('data-threejs')) return;
c.style.display = 'none';
});
});
const pdfBuffer = await page.pdf({
format: 'A4',
printBackground: true,
margin: { top: '15px', bottom: '20px', left: '15px', right: '15px' }
});
return pdfBuffer;
} finally {
await browser.close();
}
};
// NEW: Convert to XLSX using ExcelJS
export const convertToXlsx = async (htmlContent, title) => {
const $ = cheerio.load(htmlContent);
const table = $('table').first();
if (table.length === 0) {
throw new Error("No table found to convert.");
}
const workbook = new ExcelJS.Workbook();
const worksheet = workbook.addWorksheet(title.substring(0, 30) || 'Sheet 1'); // Excel limits sheet names to 31 chars
// Parse Headers (th)
const headerRow = [];
table.find('tr').first().find('th').each((i, el) => {
headerRow.push($(el).text().trim());
});
// If no TH, try first row TD
if(headerRow.length === 0) {
table.find('tr').first().find('td').each((i, el) => {
headerRow.push($(el).text().trim());
});
}
// Add Header Row with Styling
const header = worksheet.addRow(headerRow);
header.eachCell((cell) => {
cell.font = { bold: true, color: { argb: 'FFFFFFFF' } };
cell.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: 'FF2E7D32' } }; // Emerald Green
});
// Parse Data Rows
table.find('tr').each((i, row) => {
// Skip header row if we already parsed it
if ($(row).find('th').length > 0) return;
const rowData = [];
$(row).find('td').each((j, col) => {
// Handle basic numbers vs strings
const text = $(col).text().trim();
const num = parseFloat(text.replace(/,/g, '')); // Simple check for currency/numbers
rowData.push(!isNaN(num) && text.match(/\d/) ? num : text);
});
if (rowData.length > 0) {
worksheet.addRow(rowData);
}
});
// Auto-width columns (basic estimation)
worksheet.columns.forEach(column => {
column.width = 20;
});
// Write to buffer
const buffer = await workbook.xlsx.writeBuffer();
return buffer;
};