Skip to main content

SetLastModifiedBy

Sets the name of the user who last modified the document.

Syntax

expression.SetLastModifiedBy(sLastModifiedBy);

expression - A variable that represents a ApiCore class.

Parameters

NameRequired/OptionalData typeDefaultDescription
sLastModifiedByRequiredstringThe name of the user who last modified the document.

Returns

This method doesn't return any data.

Example

Record the name of the person who last edited a workbook in a spreadsheet.

// How do I store the last editor's name in a workbook's metadata in a spreadsheet?

// Track who made the most recent changes by writing their name to the document properties in a spreadsheet.

const worksheet = Api.GetActiveSheet();
const core = Api.GetCore();

core.SetLastModifiedBy("Mark Pottato");
const lastModifiedBy = core.GetLastModifiedBy();

let fill = Api.CreateSolidFill(Api.RGB(100, 50, 200));
let stroke = Api.CreateStroke(0, Api.CreateNoFill());
const shape = worksheet.AddShape(
"rect",
100 * 36000, 100 * 36000,
fill, stroke,
0, 0, 3, 0
);

let paragraph = shape.GetContent().GetElement(0);
paragraph.AddText("Last modified by: " + lastModifiedBy);