tenderizer / src /utils /docConverter.js
ismizo's picture
Upload 32 files
0787112 verified
Raw History Blame Contribute Delete
3.06 kB
import mammoth from 'mammoth';
import ExcelJS from 'exceljs';
import puppeteer from 'puppeteer';
const HTML_TEMPLATE = `
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<script src="https://cdn.tailwindcss.com"></script>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;500;600;700&family=Merriweather:wght@400;700&family=Roboto:wght@300;400;500;700&display=swap" rel="stylesheet">
<style>
body { font-family: Arial, sans-serif; padding: 20px; font-size: 14px; }
table { border-collapse: collapse; width: 100%; margin-bottom: 20px; }
th, td { border: 1px solid #ccc; padding: 8px; text-align: left; }
th { background-color: #f4f4f4; }
</style>
</head>
<body>
{{CONTENT}}
</body>
</html>
`;
export async function convertToPdf(fileBuffer, mimeType, originalName) {
let htmlContent = '';
if (mimeType === 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' || originalName.endsWith('.docx')) {
const result = await mammoth.convertToHtml({ buffer: fileBuffer });
htmlContent = result.value;
}
else if (mimeType === 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' || originalName.endsWith('.xlsx')) {
const workbook = new ExcelJS.Workbook();
await workbook.xlsx.load(fileBuffer);
let htmlBuilder = '';
workbook.eachSheet((worksheet, sheetId) => {
htmlBuilder += `<h2>${worksheet.name}</h2><table>`;
worksheet.eachRow((row, rowNumber) => {
htmlBuilder += '<tr>';
row.eachCell({ includeEmpty: true }, (cell, colNumber) => {
const tag = rowNumber === 1 ? 'th' : 'td';
let cellValue = '';
try {
if (cell.type === 6) {
cellValue = '';
} else {
cellValue = cell.text || (cell.value != null ? cell.value.toString() : '');
}
} catch (e) {
cellValue = '';
}
htmlBuilder += `<${tag}>${cellValue}</${tag}>`;
});
htmlBuilder += '</tr>';
});
htmlBuilder += '</table><hr/>';
});
htmlContent = htmlBuilder;
}
else {
throw new Error(`Unsupported document type for conversion: ${mimeType}`);
}
const fullHtml = HTML_TEMPLATE.replace('{{CONTENT}}', htmlContent || '<p>Empty Document</p>');
const browser = await puppeteer.launch({
args: ['--no-sandbox', '--disable-setuid-sandbox']
});
const page = await browser.newPage();
await page.setContent(fullHtml, { waitUntil: 'networkidle0' });
const pdfUint8Array = await page.pdf({ format: 'A4', printBackground: true });
await browser.close();
return Buffer.from(pdfUint8Array);
}