GeneralException when copying range from/to column H about office-js

[shanshanzheng-dev]

Hi @manuelsidler Thanks for confirming. I can repro this problem. We'll be looking into the issue and report back if we have a suggestion for you. Thanks.

[shanshanzheng-dev]

Hi @manuelsidler Thanks for reporting. About this API, you can follow this reference: https://learn.microsoft.com/en-us/javascript/api/excel/excel.range?view=excel-js-preview#excel-excel-range-copyfrom-member(1),
you could try this code snippet, seem you have to set an initial range:

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

    const range = "A1:H1"; // more examples that won't work: 'H1', 'H1:M2', 'A1:H2', ...
    const sourceRange = sheet.getRange(range);

    sheet.getRange("A2").copyFrom(sourceRange, Excel.RangeCopyType.all);
    
    await context.sync();
  });
}

Please let me know if resolve your problem. Thanks.

[manuelsidler]

@shanshanzheng-dev using an initial range helps, thank you. But I still don't understand why the error occurs only when I explicitly use the "H" column for the range. The snippet I posted works fine with ranges like A1:K1, G1:I1 and so on (without specifying an initial range):

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

    const range = 'A1:I1' // works without specifying an initial range
    const sourceRange = sheet.getRange(range)

    sheet.getRange().copyFrom(sourceRange, Excel.RangeCopyType.all)

    await context.sync();
  });