Çalışma sayfasına JavaScript kullanarak C++ ile İmza satırı ekleyin
Contents
[
Hide
]
Giriş
Aspose.Cells, çalışma sayfasına imza satırı eklemek için Picture.signatureLine özelliğini sağlar.
Çalışma Sayfasına İmza Çizgisi Eklemek
Aşağıdaki örnek kod, Picture.signatureLine özelliğini kullanarak çalışma sayfasının imza çizgisini eklemeyi gösterir. Çalışma sonrası ekran görüntüsü, örnek kodun etkisini gösterir.
Örnek Kod
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Signature Line</title>
</head>
<body>
<h1>Signature Line Example</h1>
<p>Optional: select an existing Excel file to add the signature line to. Otherwise a new workbook will be created.</p>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<p>Select a PFX certificate file (required):</p>
<input type="file" id="certInput" accept=".pfx" />
<br/><br/>
<button id="runExample">Add Signature Line and Sign Workbook</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, Utils, SignatureLine, DigitalSignature, DigitalSignatureCollection } = 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');
const certInput = document.getElementById('certInput');
const resultDiv = document.getElementById('result');
if (!certInput.files.length) {
resultDiv.innerHTML = '<p style="color: red;">Please select a PFX certificate file.</p>';
return;
}
const certFile = certInput.files[0];
const certArrayBuffer = await certFile.arrayBuffer();
const certBytes = new Uint8Array(certArrayBuffer);
// Instantiate or load workbook
let workbook;
if (fileInput.files.length) {
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
workbook = new Workbook(new Uint8Array(arrayBuffer));
} else {
workbook = new Workbook();
}
// Create and configure signature line
const signatureLine = new SignatureLine();
signatureLine.signer = "Aspose.Cells";
signatureLine.title = "signed by Aspose.Cells";
// Access first worksheet and add signature line
const worksheet = workbook.worksheets.get(0);
worksheet.shapes.addSignatureLine(1, 1, signatureLine);
// Create digital signature from certificate bytes
const signature = new DigitalSignature(certBytes, "aspose", "test Microsoft Office signature line", new Date());
// Add signature to collection and assign to workbook
const dsCollection = new DigitalSignatureCollection();
dsCollection.add(signature);
workbook.digitalSignature = dsCollection;
// Save the workbook and provide download link
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'signatureLine.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Signed Workbook';
resultDiv.innerHTML = '<p style="color: green;">Signature line added and workbook signed. Click the download link to get the file.</p>';
});
</script>
</html>