Excel i JavaScript kullanarak C++ ile PDF ye dönüştürürken Katı Kılavuz Çizgileri Render Et
Contents
[
Hide
]
Uyumluluk için, Aspose.Cells varsayılan olarak Excel’den PDF’ye dönüştürürken ızgara çizgilerini noktalı çizgi olarak çizer. Ancak, modern Excel günümüzde ızgara çizgilerini katı çizgi olarak çizer.
PdfSaveOptions.gridlineTypes seçeneği ile, Aspose.Cells for JavaScript kullanarak C++ kılavuz çizgilerini katı çizgi olarak da render edebilir.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells Example - Generate PDF with Gridlines</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx" />
<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, PdfSaveOptions, Utils } = 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();
// Loads the workbook which contains hidden external links (as in original JavaScript example)
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Create an empty Workbook
const wb = new Workbook();
// Prepare data
const worksheet = wb.worksheets.get(0);
const cell = worksheet.cells.get("D9");
cell.value = "gridline";
// Enable to print gridline
worksheet.pageSetup.printGridlines = true;
// Set to render gridline as solid line
const pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.gridlineType = AsposeCells.GridlineType.Hair;
// Save the pdf file with PdfSaveOptions
const outputData = wb.save(SaveFormat.Pdf, pdfSaveOptions);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'test_Cs.pdf';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download PDF File';
document.getElementById('result').innerHTML = '<p style="color: green;">PDF generated successfully! Click the download link to get the file.</p>';
});
</script>
</html>
