Hi I'm reading excel range data from an excel file with an Office Script:
function main(workbook: ExcelScript.Workbook) {
let sheet = workbook.getWorksheet("Test AM");
let range = sheet.getRange("A1:A7");
let returnData = range.getValues();
return returnData;
};
This is returning the values to my flow.
I want to write this data to a destination excel file, using the same flow, but I'm not sure how to write the data-writing office script.
I'm trying to include a data array, but it isn't working and intellisense is showing errors:
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492