excel office scripts documentation
async function main(context: Excel.RequestContext) {
// Get the cells at A1 and B1.
let dateRange = context.workbook.worksheets.getActiveWorksheet().getRange("A1");
let timeRange = context.workbook.worksheets.getActiveWorksheet().getRange("B1");
// Get the current date and time with the JavaScript Date object.
let date = new Date(Date.now());
// Add the date string to A1.
dateRange.values = [[date.toLocaleDateString()]];
// Add the time string to B1.
timeRange.values = [[date.toLocaleTimeString()]];
}
async function main(context: Excel.RequestContext) {
// Get the current worksheet.
let selectedSheet = context.workbook.worksheets.getActiveWorksheet();
// Get the value of cell A1.
let range = selectedSheet.getRange("A1");
range.load("values");
await context.sync();
// Print the value of A1.
console.log(range.values);
}