Hi! My flow is very straightforward. I created a simple java script code, you can check it below:
function main(workbook:
ExcelScript.Workbook,
MDName: string,
Period: string,
Trans: Trans[]
) {
let sheet = workbook.getFirstWorksheet();
//Update Payee Details
sheet.getRange("D11").setValue(Name)
sheet.getRange("D12").setValue(Period);
const transOffset = 17 //start of row to be filled
// i = 1 because this starts on the 2rd row on the inputed file
for (let i = 0; i < Trans.length; i++) {
const currentTrans = Trans[i];
const formattedTrans = [[currentTrans.transDate, currentTrans.transID, currentTrans.profFee, currentTrans.medCertFee, currentTrans.platformFee, currentTrans.vcscDiscount, currentTrans.whtrate, currentTrans.wht, currentTrans.totalDisbursement]];
const saleCell = `C${transOffset + i}:K${transOffset + i}`;
sheet.getRange(saleCell).setValues(formattedTrans);
}
}
interface Trans {
transDate: number,
transID: string,
profFee: number,
medCertFee: number,
platformFee: number,
vcscDiscount: number,
whtrate: number,
wht: number,
totalDisbursement: number,
}
Run-script flow is here:
