itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Run the code from down to top or vice versa using office script in an excel report

Generally, the code is running from top to down but sometimes, I want the code to run in the contrary way, from down to top.

 

When I use the script ?

When I want to run it from down to top.

 

How to create the script ?

Read How to create, edit and select an Office Script in an excel report

 

How to create the button to associate it with the script ?

Read How to create a button and associated it to an Office Script in an excel report

 

How is/are the script(s) ?

Copy the code below and paste it into your script. You will see my comments in green if exist so follow the help to adapt to your need.


function main(workbook: ExcelScript.Workbook) {
    // from down to top
    let valuedowntop = workbook.getWorksheet("Sheet1").getRange("A2:A10").getValues();
    for (let i = valuedowntop.length - 1; i >= 0; i--) {
    }
    // from top to down 
    let valuetopdown = workbook.getWorksheet("Sheet1").getRange("A2:A10").getValues();
    for (let i = 0; i < valuetopdown.length; i++) {
    }
}

Interesting Topics