Here’s a sample OfficeScript that compares two sheets and highlights the differences in range A1:D100: function compareSheets() { // Get the active workbook var workbook = context.workbook; // Get the first and second sheets var sheet1 = workbook.getWorksheets().getAt(0); var sheet2 = workbook.getWorksheets().getAt(1); // Get the range A1:D100 in both sheets var range1 = sheet1.getRange("A1:D100"); var range2 = sheet2.getRange("A1:D100"); // Load the values of both ranges var range1Values = range1.load("values"); var range2Values = range2.load("values"); return context.sync() .then(function() { // Iterate over each cell in the ranges and compare values for (var i = 0; i < range1Values.length; i++) { for (var j = 0; j < range1Values[i].length; j++) { var cellValue1 = range1Values[i][j]; var cellValue2 = range2Values[i][j]; // Compare the cell values if (cellValue1 !== cellValue2) { // Highlight the cells that differ range1.getCell(i, j).format.fill.color = "yellow"; range2.getCell(i, j).format.fill.color = "yellow"; } } } }) .then(context.sync); } In this example, the compareSheets function performs the following steps: It gets the active workbook using the context.workbook property. It retrieves the first and second sheets from the workbook using the getWorksheets().getAt() method. Adjust the index as needed. It defines the range A1:D100 in both sheets using the getRange() method. It loads the values of both ranges using the load(“values”) method. It synchronizes the context to ensure the values are retrieved. It iterates over each cell in the ranges, compares the values, and highlights the cells that differ. Finally, it synchronizes the context again to apply the formatting changes. You can call the compareSheets function to compare the two sheets and highlight any differences in the range A1:D100. The cells with different values will be highlighted in yellow. Please note that this example assumes you have an active workbook with at least two sheets, and the code compares the values cell by cell. Adjust the range and other parameters as needed for your specific use case. Additionally, remember to set up the necessary context and load the OfficeScript runtime to ensure the script executes successfully.

Here’s a sample OfficeScript that demonstrates how to read various properties of a pivot table in Excel: function readPivotTableProperties() { // Get the active worksheet var worksheet = context.workbook.getActiveWorksheet(); // Get a pivot table to read properties from var pivotTable = worksheet.getPivotTables().getAt(0); // Assuming the first pivot table in the worksheet // Read pivot table properties var pivotTableName = pivotTable.getName(); var pivotTableSourceRange = pivotTable.getSourceData(); var pivotTableColumnCount = pivotTable.getColumns().getCount(); var pivotTableRowCount = pivotTable.getRows().getCount(); var pivotTableValueCount = pivotTable.getValues().getCount(); // Logging the pivot table properties console.log(“Pivot Table Name: ” + pivotTableName); console.log(“Pivot Table Source Range: ” + pivotTableSourceRange); console.log(“Pivot Table Column Count: ” + pivotTableColumnCount); console.log(“Pivot Table Row Count: ” + pivotTableRowCount); console.log(“Pivot Table Value Count: ” + pivotTableValueCount); } In this example, the readPivotTableProperties function performs the following steps: It gets the active worksheet using the getActiveWorksheet method. It retrieves the first pivot table in the worksheet using the getPivotTables().getAt(0) method. If you have multiple pivot tables, adjust the index as needed. It reads various properties of the pivot table, such as the name, source range, column count, row count, and value count. The pivot table properties are stored in variables: pivotTableName, pivotTableSourceRange, pivotTableColumnCount, pivotTableRowCount, and pivotTableValueCount, respectively. Finally, it logs the pivot table properties to the console. You can call the readPivotTableProperties function to see the pivot table properties in the console output. Please note that this example assumes that you have a workbook open and a worksheet with at least one pivot table in Excel for the web or Excel Online, where you can execute the OfficeScript. Additionally, remember to set up the necessary context and load the OfficeScript runtime to ensure the script executes successfully.

 Here’s a sample OfficeScript that demonstrates how to read various properties of a range in Excel: function readRangeProperties() { // Get the active worksheet var worksheet = context.workbook.getActiveWorksheet(); // Get a range to read properties from var range = worksheet.getRange("A1:C3"); // Read range properties var rangeAddress = range.getAddress(); var rangeValues = range.getValues(); var rangeNumberFormat = range.getNumberFormat(); var rangeFontColor = range.getFormat().getFont().getColor(); var rangeBackgroundColor = range.getFormat().getFill().getColor(); // Logging the range properties console.log("Range Address: " + rangeAddress); console.log("Range Values: "); console.log(rangeValues); console.log("Range Number Format: " + rangeNumberFormat); console.log("Range Font Color: " + rangeFontColor); console.log("Range Background Color: " + rangeBackgroundColor); } In this example, the readRangeProperties function performs the following steps: It gets the active worksheet using the getActiveWorksheet method. It defines a range (A1:C3) within the worksheet using the getRange method. It reads various properties of the range, such as the address, values, number format, font color, and background color. The range properties are obtained using appropriate methods like getAddress, getValues, getNumberFormat, getFont().getColor, and getFill().getColor. Finally, it logs the range properties to the console. You can call the readRangeProperties function to see the range properties in the console output. Please note that this example assumes that you have a workbook open and a worksheet active in Excel for the web or Excel Online, where you can execute the OfficeScript. Additionally, remember to set up the necessary context and load the OfficeScript runtime to ensure the script executes successfully.

Here’s a sample OfficeScript that demonstrates how to create a PowerPoint presentation, add shapes, and add text to the slides: function createPowerPoint() { // Create a PowerPoint presentation var presentation = context.presentation.create(); // Add a slide to the presentation var slide = presentation.slides.add(); // Add a rectangle shape to the slide var rectangle = slide.shapes.addShape("Rectangle", 100, 100, 200, 100); // Add text to the rectangle shape var textFrame = rectangle.textFrame; textFrame.textRange.text = "Hello, PowerPoint!"; // Save the presentation presentation.save("SamplePresentation.pptx"); } In this example, the createPowerPoint function performs the following steps: It creates a new PowerPoint presentation using the context.presentation.create() method. It adds a slide to the presentation using the slides.add() method. It adds a rectangle shape to the slide using the shapes.addShape() method. The parameters specify the position and dimensions of the rectangle. It accesses the text frame of the rectangle shape using the textFrame property. It sets the text of the rectangle shape using the textRange.text property. Finally, it saves the presentation with the specified file name using the presentation.save() method. You can call the createPowerPoint function to create the PowerPoint presentation with a rectangle shape and text. The presentation will be saved with the name “SamplePresentation.pptx”. Please note that OfficeScripts for PowerPoint are currently only supported in PowerPoint for the web, and you need to have the appropriate permissions to create and save presentations.

Here’s a sample OfficeScript that demonstrates how to read various properties of a range in Excel: function readRangeProperties() { // Get the active worksheet var worksheet = context.workbook.getActiveWorksheet(); // Get a range to read properties from var range = worksheet.getRange("A1:C3"); // Read range properties var rangeAddress = range.address; var rangeValues = range.values; var rangeNumberFormat = range.numberFormat; var rangeFontColor = range.format.font.color; var rangeBackgroundColor = range.format.fill.color; // Logging the range properties console.log("Range Address: " + rangeAddress); console.log("Range Values: "); console.log(rangeValues); console.log("Range Number Format: " + rangeNumberFormat); console.log("Range Font Color: " + rangeFontColor); console.log("Range Background Color: " + rangeBackgroundColor); } In this example, the readRangeProperties function performs the following steps: It gets the active worksheet using the getActiveWorksheet method. It defines a range (A1:C3) within the worksheet using the getRange method. It reads various properties of the range, such as the address, values, number format, font color, and background color. The range properties are stored in variables: rangeAddress, rangeValues, rangeNumberFormat, rangeFontColor, and rangeBackgroundColor, respectively. Finally, it logs the range properties to the console. You can call the readRangeProperties function to see the range properties in the console output. Please note that this example assumes that you have a workbook open and a worksheet active in Excel for the web or Excel Online, where you can execute the OfficeScript. Additionally, remember to set up the necessary context and load the OfficeScript runtime to ensure the script executes successfully.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo. function readSheetProperties() { // Get the active worksheet var worksheet = context.workbook.getActiveWorksheet(); // Read sheet properties var sheetName = worksheet.name; var sheetIndex = worksheet.position; var sheetVisibility = worksheet.visibility; var sheetProtection = worksheet.protection.isProtected; // Logging the sheet properties console.log("Sheet Name: " + sheetName); console.log("Sheet Index: " + sheetIndex); console.log("Sheet Visibility: " + sheetVisibility); console.log("Sheet Protection: " + sheetProtection); } In this example, the readSheetProperties function performs the following steps: It gets the active worksheet using the getActiveWorksheet method. It reads various properties of the sheet, such as the name, position (index), visibility, and protection. The sheet properties are stored in variables: sheetName, sheetIndex, sheetVisibility, and sheetProtection, respectively. Finally, it logs the sheet properties to the console. You can call the readSheetProperties function to see the sheet properties in the console output. Please note that this example assumes that you have a workbook open and a worksheet active in Excel for the web or Excel Online, where you can execute the OfficeScript. Additionally, remember to set up the necessary context and load the OfficeScript runtime to ensure the script executes successfully.

 Here’s a sample OfficeScript that demonstrates how to compare various types of data using logical operators such as AND, OR, NOT, and comparison operators like equal to (=), not equal to (<>), greater than (>), less than (<), etc. function compareData() { // Sample variables var number1 = 10; var number2 = 20; var string1 = "Hello"; var string2 = "World"; var boolean1 = true; var boolean2 = false; // Comparisons using logical operators and comparison operators var result1 = (number1 > number2) && (string1 === "Hello"); var result2 = (string1 !== string2) || (boolean1 && boolean2); var result3 = !(boolean1 && boolean2); // Logging the comparison results console.log(result1); console.log(result2); console.log(result3); } In this example, the compareData function performs the following comparisons: It compares number1 and number2 using the greater than (>) operator, and string1 with the string “Hello” using the strict equality (===) operator. The result is stored in result1. It compares string1 and string2 using the not equal to (!==) operator, and compares boolean1 and boolean2 using the logical AND (&&) operator. The overall result is computed using the logical OR (||) operator and stored in result2. It performs a logical NOT (!) operation on the result of boolean1 && boolean2, and stores the inverted result in result3. Finally, the example logs the comparison results to the console. You can call the compareData function to see the comparison results in the console output. Please note that OfficeScripts are only supported in Excel for the web and Excel Online, and they may have limitations compared to other programming environments.

Here’s a sample OfficeScript that demonstrates how to store data in Range objects and read data from them: function storeAndReadDataFromRange() { // Get the active worksheet var worksheet = context.workbook.getActiveWorksheet(); // Get a range to store data var range = worksheet.getRange("A1:B2"); // Data to be stored in the range var data = [ ["John", 30], ["Jane", 35] ]; // Store the data in the range range.values = data; // Read the data from the range var storedData = range.values; // Logging the stored data console.log(storedData); } In this example, the storeAndReadDataFromRange function performs the following steps: It gets the active worksheet using the getActiveWorksheet method. It defines a range (A1:B2) within the worksheet using the getRange method. It creates a 2D array called data with sample values that will be stored in the range. It assigns the data array to the values property of the range, effectively storing the data in the range. It reads the stored data from the range by accessing the values property of the range. Finally, it logs the stored data to the console. You can call the storeAndReadDataFromRange function to see the stored data in the console output. Please note that this example assumes that you have a workbook open and a worksheet active in Excel for the web or Excel Online, where you can execute the OfficeScript. Additionally, remember to set up the necessary context and load the OfficeScript runtime to ensure the script executes successfully.

Here are some examples of creating sample objects: function createSampleObjects() { // Object with string values var person = { name: "John Doe", age: "30", occupation: "Engineer" }; // Object with number values var product = { id: 12345, price: 9.99, quantity: 5 }; // Object with boolean values var settings = { isEnabled: true, isEditable: false, isResizable: true }; // Object with mixed value types var car = { make: "Toyota", model: "Camry", year: 2022, isElectric: false }; // Logging the objects console.log(person); console.log(product); console.log(settings); console.log(car); } In this example, four different objects are created with different types of values: person is an object that stores information about a person, such as their name, age, and occupation. The values are of type string. product is an object that represents a product, with properties like ID, price, and quantity. The values are of type number. settings is an object that holds various settings, such as whether certain options are enabled, editable, or resizable. The values are of type boolean. car is an object that represents a car, with properties like make, model, year, and whether it is electric. The values are of different types, including string, number, and boolean. After creating the objects, the example logs the objects to the console, displaying their key-value pairs. You can call the createSampleObjects function to see the objects and their properties in the console output. Please note that OfficeScripts are only supported in Excel for the web and Excel Online, and they may have limitations compared to other programming environments.

OfficeScripts does not natively support 3D arrays. However, you can achieve similar functionality by using nested arrays within nested arrays. Here’s an example of how you can create a data structure that behaves like a 3D array: function create3DArray() { // Define the dimensions of the 3D "array" var dim1 = 2; var dim2 = 3; var dim3 = 4; // Create the 3D "array" using nested arrays var array3D = new Array(dim1); for (var i = 0; i < dim1; i++) { array3D[i] = new Array(dim2); for (var j = 0; j < dim2; j++) { array3D[i][j] = new Array(dim3); } } // Assign values to the 3D "array" for (var i = 0; i < dim1; i++) { for (var j = 0; j < dim2; j++) { for (var k = 0; k < dim3; k++) { array3D[i][j][k] = "Value: " + i + "-" + j + "-" + k; } } } // Logging the 3D "array" console.log(array3D); } In this example, the create3DArray function creates a “3D array” using nested arrays. It defines the dimensions of the “array” as dim1, dim2, and dim3, representing the number of elements in each dimension. The function then creates the “3D array” structure by using nested loops to create arrays within arrays. The outermost loop iterates over the first dimension (dim1), the middle loop iterates over the second dimension (dim2), and the innermost loop iterates over the third dimension (dim3). After creating the “3D array” structure, the function assigns values to the individual elements of the “array” using the loop variables i, j, and k. In this example, each element is assigned a string value based on its indices. Finally, the “3D array” is logged to the console. Keep in mind that this approach does not provide native 3D array functionality, but it allows you to create a data structure that simulates a 3D array using nested arrays. Please note that OfficeScripts are only supported in Excel for the web and Excel Online, and they may have limitations compared to other programming environments.