Trasforma Grafico in PDF con JavaScript tramite C++
Contents
[
Hide
]
Rendering del grafico in PDF
Per rendere il grafico in formato PDF, le API Aspose.Cells hanno esposto il metodo Chart.toPdf(string) con la capacità di memorizzare il PDF risultante su percorso disk o Stream.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Chart to PDF</title>
</head>
<body>
<h1>Chart to PDF Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</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, ChartType } = 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 () => {
// Create a new workbook
const workbook = new Workbook();
// Add a new worksheet
const sheetIndex = workbook.worksheets.add();
const worksheet = workbook.worksheets.get(sheetIndex);
// Adding sample values to cells
worksheet.cells.get("A1").value = 50;
worksheet.cells.get("A2").value = 100;
worksheet.cells.get("A3").value = 150;
worksheet.cells.get("B1").value = 4;
worksheet.cells.get("B2").value = 20;
worksheet.cells.get("B3").value = 50;
// Adding a chart to the worksheet
const chartIndex = worksheet.charts.add(ChartType.Column, 5, 0, 15, 5);
const chart = worksheet.charts.get(chartIndex);
// Adding Series Collection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.nSeries.add("A1:B3", true);
// Converting chart to PDF
const outputData = chart.toPdf();
const blob = new Blob([outputData], { type: 'application/pdf' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'chartPDF_out.pdf';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Chart PDF';
document.getElementById('result').innerHTML = '<p style="color: green;">Chart converted to PDF successfully! Click the download link to get the PDF.</p>';
});
</script>
</html>
Crea Grafico PDF con Dimensione Pagina Desiderata
Puoi creare il PDF del grafico con le dimensioni di pagina desiderate usando Aspose.Cells e specificare come vuoi allineare il grafico all’interno della pagina come in alto, in basso, al centro, a sinistra, a destra ecc. Inoltre, il grafico di output può essere creato in stream o su disco. Consulta il seguente esempio di codice che carica il file Excel di esempio, accede al primo grafico all’interno del foglio di lavoro e poi lo converte in PDF di output con le dimensioni di pagina desiderate. Lo screenshot seguente mostra che la dimensione della pagina nel PDF di output è 7x7 come specificato nel codice e il grafico è allineato al centro sia orizzontalmente che verticalmente.
Codice di Esempio
<!DOCTYPE html>
<html>
<head>
<title>Create Chart PDF With Desired Page Size</title>
</head>
<body>
<h1>Create Chart PDF With Desired Page Size</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.xlsm" />
<button id="runExample">Run Example</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 from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Access first worksheet.
const worksheet = workbook.worksheets.get(0);
// Access first chart inside the worksheet.
const chart = worksheet.charts.get(0);
// Create chart pdf with desired page size.
// Note: In browser API omit file path and receive output data (Uint8Array / ArrayBuffer)
const outputData = chart.toPdf(7, 7, AsposeCells.PageLayoutAlignmentType.Center, AsposeCells.PageLayoutAlignmentType.Center);
const blob = new Blob([outputData], { type: 'application/pdf' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'outputCreateChartPDFWithDesiredPageSize.pdf';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download PDF File';
document.getElementById('result').innerHTML = '<p style="color: green;">Chart exported to PDF successfully! Click the download link to get the PDF file.</p>';
});
</script>
</html>