OfficeScripts

To delete data from a SQL Server database using OfficeScripts, you would typically follow a similar approach as appending data. However, instead of making a POST request, you would make a DELETE request to the server-side endpoint that handles the database operations. Here’s an example…

To append data to a SQL Server database using OfficeScripts, you can make use of the ‘node-fetch’ library to send HTTP requests to a server-side endpoint that handles the database operations. However, please note that OfficeScripts are primarily designed for automating tasks within Excel and…

To send an email using an Outlook account in OfficeScripts, you can utilize the Office.context.mailbox.item object. Here’s an example of an OfficeScript that sends an email using an Outlook account: function main() { // Create the email message var email = Office.context.mailbox.item; email.subject = "Test…

Here’s an example of an OfficeScript that copies data from one sheet to another in the same workbook: function main(workbook: ExcelScript.Workbook, sourceSheetName: string, targetSheetName: string) { // Get the source and target sheets let sourceSheet = workbook.getWorksheet(sourceSheetName); let targetSheet = workbook.getWorksheet(targetSheetName); // Get the used…

 Here’s an example of an OfficeScript that adds a chart to a worksheet in an existing workbook: function main(worksheet: ExcelScript.Worksheet) { // Define the range of data for the chart let dataRange = worksheet.getRange("A1:B5"); // Add a chart to the worksheet let chart = worksheet.addChart(ExcelScript.ChartType.ColumnClustered,…

Here’s an example of an OfficeScript that adds data to a range in an existing worksheet: function main(worksheet: ExcelScript.Worksheet) { // Define the range where you want to add data let range = worksheet.getRange("A1:C3"); // Define the data to add let data = [ ["Value…

Here’s an example of an OfficeScript that creates a copy of the current sheet in an existing workbook: function main(workbook: ExcelScript.Workbook, sheetName: string) { // Get the active sheet let activeSheet = workbook.getWorksheet(sheetName); // Create a copy of the active sheet let newSheet = activeSheet.copy();…

Here’s an example of an OfficeScript that creates a new sheet in an existing workbook: function main(workbook: ExcelScript.Workbook) { // Create a new sheet let newSheet = workbook.addWorksheet(); // Rename the new sheet newSheet.setName("NewSheet"); } To use this OfficeScript, follow these steps: Open Excel Online…

Here’s an example of an OfficeScript that loops through rows in a specific column until a cell value no longer exists: function main(worksheet: ExcelScript.Worksheet, columnLetter: string) { // Define the starting row let currentRow = 1; // Loop through rows until the cell value exists…

 Here’s an example of an OfficeScript that loops from 100 to 1: function main() { // Loop from 100 to 1 for (let i = 100; i >= 1; i--) { // Do something with the loop variable console.log(i); } } To use this OfficeScript,…