Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello, i have the existing script in my workbook:
I would like to get all the worksheet names (instead of specifying as ive done), and include it in the batch details output. Thank you
function main(workbook: ExcelScript.Workbook) {
const ws = workbook.getWorksheet('Sheet1')
const starttime = ws.getRange('D95').getValue()
const endtime = ws.getRange('E95').getValue()
const batchDetails = {
start: starttime,
end: endtime
}
return batchDetails
}