Add the following script to try the sample yourself! Sample code: Add comments function main(workbook: ExcelScript.Workbook) `Ĭonsole.log("No match for: " + employeeId) Existing comments in the cell are removed before adding the new comment.ĭownload excel-comments.xlsx for a ready-to-use workbook.The script then adds a comment (including the relevant employee email) to the appropriate cell in the shift record.The script extracts employee information from the employee worksheet.Subsequently, the employee can view the workbook and respond to the comment at their convenience.By adding a comment that the employee, the employee is emailed with a custom message from the worksheet.
The team lead wishes to notify the employee.The team lead assigns an employee ID to the shift record. The team lead maintains the shift schedule.This sample shows how to add comments to a cell including a colleague.
0 kommentar(er)
