Rename sheet based on cell value in Excel Online

[stags81]

Hello,

I am new to Excel Online scripts, and I'm trying to write a script that automatically renames a sheet based on the value in a cell on that sheet.

I assume I'd want to establish a variable with "let", so I'd think it would be something like the below. The Sheet Name, ideally, would be a date in mm-dd-yy format.

//Set Sheet1 (the original sheet name) to the value in cell H1

let = actualdate = sheet1.getRange("H1");
sheet1.setName(actual date);

Having issues since the setName function expects a string instead of a range. Can someone assist?

Thanks,

Mike

 

[severynm]

function main(workbook: ExcelScript.Workbook) {
    let worksheet = workbook.getActiveWorksheet();
    let newName = worksheet.getRange("E1").getValue().toString();
    worksheet.setName(newName);
}

You are attempting to set the range object to a parameter expecting a string, which you cannot do. In order to get the necessary value in the correct type, you'll need to use some additional functions of the range object to narrow things down. You are already selecting the range (the object) with .getRange. However, you then want to get it's value property with .getValue. Lastly, you need to return the string representation of that value, accomplished with .toString