Breaking News: Grepper is joining You.com. Read the official announcement!

script lab excel set value

Standard DAVIation answered on July 13, 2023 Popularity 3/10 Helpfulness 1/10

answer script lab excel set value

script lab excel set value

Comment

async function run() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getActiveWorksheet();

    // Single cell
    const rowIndex = 1;
    const columnIndex = 1;
    const cell = sheet.getCell(rowIndex, columnIndex);
    cell.values = [["sample"]];

    // Range
    const range = sheet.getRange("B3:C4");
    range.values = [
      ["a", "b"], 
      ["c", "d"]
    ];

    await context.sync();
  });
}

Popularity 3/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: excel lab script set whatever

Link to this answer
Share Copy Link

Contributed on Jul 13 2023

Standard DAVIation

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

script lab excel set value

Contents

More Related Answers

script lab excel set value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.