AttributeError when using batch_merge

[Demsli]

---

Describe the bug
Getting Attribute error when trying to use the new feature batch_merge inside a created worksheet. Error text: AttributeError: 'Worksheet' object has no attribute 'batch_merge'

To Reproduce
Steps to reproduce the behavior:

1. Create a list of dictionaries (ex, name merge_request) with keys 'range' and 'mergeType'
2. Pass it to the worksheet variable: worksheet.batch_merge(merge_request)
3. Recieve AttributeError

Expected behavior
All of my selected ranges to be merged with one call.

Code example*
https://pastebin.com/jZLTrZwP

Environment info:

• Operating System [e.g. Linux, Windows, macOS]: Windows
• Python version: 3.11.9
• gspread version: 6.1.4

[alifeee]

hi, you are using

    {
        "range": table_formatter.a1_range_to_grid_range("A1:M1", new_worksheet),
        "mergeType": table_formatter.MergeType.merge_rows,
    },

this expands to:

    {
        'range': {
            'startRowIndex': 0,
            'endRowIndex': 1,
            'startColumnIndex': 0,
            'endColumnIndex': 13,
            'sheetId': <Worksheet 'gspread test spreadsheet' id:1061285825>
        },
        'mergeType': <MergeType.merge_rows: 'MERGE_ROWS'>
    },

whereas this is what you want:

    {
        "range": "A1:M1",
        "mergeType": table_formatter.MergeType.merge_rows,
    },

I hope this helps

I have also added an example to the docstring to help others with this function in future -> #1542

[Demsli]

Hi, thanks for the correction. However I am still getting the error: new_worksheet.batch_merge(merge_request), AttributeError: 'Worksheet' object has no attribute 'batch_merge'. Here is the updated code: https://pastebin.com/s5j5XiUv. Maybe I am executing the batch_metge function wrong?

[Demsli]

It is not the spreadsheet attribute, is it? Cause batch_update is worksheet attribute and it does work. I am using vs code, when looking at attributes for spreadsheet - I see batch_update, values_batch_get, values_batch_clear, values_batch_update. No batch_merge. For worksheet attributes it shows batch_update, batch_format, batch_get, batch_clear. No batch_merge either. I am using version 6.1.4 which is latest release. Can it be that batch_merge is still in dev branch and not in 6.1.4?

[alifeee]

you are right, it does not exist in a version yet

we should release v6.2.0 soon. see #1516 for tracking of this

I consider this replaced by that issue