Office Script return multidimensional array

Question

Can you help me, how can i return a function in office script that returns an array with: a mail, and 2 array of row ranges:

the return i need is (if possible )

[["[email protected]"],["Estac","22Jan","23Jan","24Jan","25Jan"],["448 - RRHH","","R","R",""]]

an office script macro that i can use in a power automate flow — David Ricardo Menacho Vadillo
– David Ricardo Menacho Vadillo, Commented Jan 28 at 23:47

Alexander Jerabek · Accepted Answer · 2025-01-29 20:05:26Z

1

Assuming this is Office Scripts and not an Office Add-in, you can return a 2D array from the script by adding the appropriate type to the signature. This script returns the data in the used range of Sheet1:

function main(workbook: ExcelScript.Workbook): (string | number | boolean)[][] {
    let selectedSheet = workbook.getWorksheet("Sheet1");
    let range = selectedSheet.getUsedRange();
    let rangeData = range.getValues();
    return rangeData;
}

You could also wrap the array in an object to make dealing with it in Power Automate easier. This sample shows how to merge worksheets and returns 2D arrays as part of that: https://learn.microsoft.com/office/dev/scripts/resources/samples/combine-worksheets-into-single-workbook

answered Jan 29 at 20:05

Alexander Jerabek

6201 gold badge5 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Office Script return multidimensional array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related