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

script lab excel set text

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

answer script lab excel set text

script lab excel set text

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 2/10 Helpfulness 3/10 Language typescript

Source: Grepper

Tags: excel lab script set text typescript

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 text

Contents

More Related Answers

script lab excel set text

Grepper

Documentation

Social

Legal

Contact

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