How to paste 1-D array into range in office script?

Question

I'm very new to office scripts. I have 1-Dimensional array that I want to paste in a range, but I'm getting the error

Line 7: Range setValues: The argument is invalid or missing or has an incorrect format.

I've found that the expected array should be of 2 dimensions like in this thread, but I don't know how to fix it in my case. Thanks for any help.

This is my current script.

function main(workbook: ExcelScript.Workbook) {

    const arr: number[] = [201, 106, 95];

    let destRange = workbook.getActiveWorksheet().getRange("A1:A3");

    destRange.setValues(arr);

}

Michal · Accepted Answer · 2025-01-23 08:00:11Z

1

You need to convert it to a 2-D array:

const twoDArray = arr.map(value => [value]);

answered Jan 23 at 8:00

Michal

7,6744 gold badges30 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to paste 1-D array into range in office script?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related