New to Telerik Document Processing? Download free 30-day trial

Telerik Document Processing - SpreadProcessing Add Comments

Loading Demo...

EXAMPLE
VIEW SOURCE

                    comments.cshtml
                
                    CommentsController.cs
                
                    CreateWorkbookDocument.cs
                
                    ProductService.cs

API REFERENCE

Configurator

Cell

Comment

Author

$(document).ready(function () { $('#addComment').click(function () { // Clear previous error messages $('.validation-error').text('').hide(); const cell = $('#cell').val(); const comment = $('#comment').val(); const author = $('#author').val(); let isValid = true; if (!cell.trim()) { $('#cell-error').text('Please enter a cell reference.').show(); isValid = false; } if (!comment.trim()) { $('#comment-error').text('Please enter a comment.').show(); isValid = false; } if (!author.trim()) { $('#author-error').text('Please enter an author name.').show(); isValid = false; } if (!isValid) { return; } const newEntry = { cell, comment, author }; let existingData = sessionStorage.getItem('dplSpread'); let dataArray = existingData ? JSON.parse(existingData) : []; dataArray.push(newEntry); sessionStorage.setItem('dplSpread', JSON.stringify(dataArray)); $('#cell').val(''); $('#comment').val(''); $('#author').val(''); }); $('#exportDocument').click(function () { let existingData = sessionStorage.getItem('dplSpread'); let dataArray = existingData ? JSON.parse(existingData) : []; if (!dataArray || dataArray.length === 0) { alert('No comments to export. Please add some comments first.'); return; } // Create a hidden form to handle the file download const form = document.createElement('form'); form.method = 'POST'; form.action = '/spreadprocessing/generatedocumentwithcomments'; form.style.display = 'none'; // Add the data as a hidden input const input = document.createElement('input'); input.type = 'hidden'; input.name = 'json'; input.value = JSON.stringify(dataArray); form.appendChild(input); document.body.appendChild(form); form.submit(); document.body.removeChild(form); sessionStorage.removeItem('dplSpread'); }) }); .page-container { display: flex; flex-wrap: nowrap; width: 100%; } .demo-section { flex: 1; display: flex; justify-content: center; padding-right: 20px; box-sizing: border-box; } .configurator { box-sizing: border-box; margin-left: auto; width: 179px; flex-shrink: 0; margin: -18px -14px -18px -14px; background-color: white; border-left-style: solid; border-left-color: #e2e5eb; border-left-width: 1px; } .form-comments.k-widget.k-form.k-form-md { margin-left: 10px; margin-right: 10px; width: 100%; } .k-form .k-form-legend { margin-bottom: 10px; border-width: 0 0 1px; } .validation-error { color: #e4444c; font-size: 12px; margin-top: 4px; display: none; }

Description

With RadSpreadProcessing, you can insert a Comment related to a cell on a specific document position. The current example demonstrates how you can add comments with custom Author and Text while generating a document, and then export it to Xlsx format.

Additional Libraries

This SpreadProcessing example is part of Document Processing demos, with which you can see all Telerik Document Processing libraries and their features in action.

Telerik Document Processing - SpreadProcessing Add Comments

Description

Additional Libraries

Support & Learning Resources

Additional Resources