Get value from each cell of a Range.Areas

Question

Get value from each cell of a Range.Areas

I am in the process of learning.
I have tried the following, but I would like a more effective suggestion on how to get the values from a RangeAreas and paste them into a table.
Thanks in advance

async function main(mybook: ExcelScript.Workbook)
{

let MyHoja = mybook.getWorksheet("Hoja1");

let RCell = MyHoja.getRanges("D15, D17, D19, D21, I23, O23, A59");

var vRCell = RCell.getAreas();

var i:number=0

let vRCell1 = vRCell.forEach((value, i) => {
let AreaDAT = vRCell[i];

MyHoja.getCell(29, i).setValue(AreaDAT);


i = i + 1;

});

}

Answer 1

These two samples may be helpful, depending on the format and size of your data:
https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/copy-tables-combine
https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/write-large-dataset