Draw Slicer while rendering Excel to PDF
Contents
[
Hide
]
Draw Slicer while rendering Excel to PDF
If you have an Excel file which has slicer applied to it and you want to export the Excel to PDF with the slicer settings, Aspose.Cells for JavaScript via C++ now supports this by default. You simply export the Excel file with slicer to PDF, the generated PDF will show the slicer applied.
The following sample code loads the sample Excel file that contains an existing slicer. It then saves the workbook as output PDF file. The following screenshot compares the source Excel file and the generated PDF file.
Sample Code
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Save as PDF</title>
</head>
<body>
<h1>Save Excel as PDF Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to PDF</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
const fileInput = document.getElementById('fileInput');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiating a Workbook object by loading the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save the workbook to PDF format
const outputData = workbook.save(SaveFormat.Pdf);
const blob = new Blob([outputData], { type: 'application/pdf' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'SampleSlicerChart.pdf';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download PDF File';
document.getElementById('result').innerHTML = '<p style="color: green;">Conversion completed successfully! Click the download link to get the PDF file.</p>';
});
</script>
</html>