Signaturzeile zum Arbeitsblatt mit JavaScript via C++ hinzufügen
Contents
[
Hide
]
Einführung
Aspose.Cells stellt die Eigenschaft Picture.signatureLine bereit, um die Signaturlinie des Arbeitsblatts hinzuzufügen.
Wie fügt man eine Signaturlinie zum Arbeitsblatt hinzu
Der folgende Beispielcode zeigt, wie man die Picture.signatureLine Eigenschaft verwendet, um die Signaturzeile des Arbeitsblatts hinzuzufügen. Das Bild zeigt die Wirkung des Beispielcodes auf die Beispiel-Excel-Datei nach der Ausführung.
Beispielcode
<!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>