Question 53792 in Javascript Question posted in
A very good W3school tutorial can be found here.

Office Scripts – Merge Cell – Javascript

Is there a code for repetitive merging. Like for example I want to merge A1:B1, then again A2:B2, then A3:B3 and so forth. It goes a long way up to 500th cell A500:B500?

I am familiar with this code:

    function main(workbook: ExcelScript.Workbook) {
        let selectedSheet = workbook.getActiveWorksheet();
        selectedSheet.getRange("A2:B2").merge(false);
        selectedSheet.getRange("A2:B2").getFormat().setHorizontalAlignment(ExcelScript.HorizontalAlignment.center);
    }

Are there a few lines code to apply it multiple times, to avoid actually repeating the merging of 2 cells while recording?

Tags:

2

Answers


  1. 0

    This obviously comes with caveats but the only thing I can think off is to merge the first set of cells and then copy that merge down the desired amount of rows below …

    function main(workbook: ExcelScript.Workbook) {
    let worksheet = workbook.getActiveWorksheet();

    worksheet.getRange("A2:B2").merge(false);
    worksheet.getRange("A3:B30").copyFrom(worksheet.getRange("A2:B2"), ExcelScript.RangeCopyType.formats);
}

    If the cells are populated, it will work because it’s going to copy formats only but not sure if that is acceptable for you or not.

    Login or Signup to reply.
  2. 0

    You can try using the code below

        function main(workbook: ExcelScript.Workbook) {
        let selectedSheet = workbook.getActiveWorksheet();
        let address = "A2:B500"
        selectedSheet.getRange(address).merge(true);
        selectedSheet.getRange(address).getFormat().setHorizontalAlignment(ExcelScript.HorizontalAlignment.center);
    }
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search