duan0065626385 2019-04-03 04:38
浏览 120
已采纳

如何识别单元格与Google Sheets API合并的单元格

I'm using Go API https://developers.google.com/sheets/api/quickstart/go

I have a sheet looks like this and want to automate some cell filling logic

  |  B   |  C   |
--+------+------+
1 |  b1  |  c1  |
--+------+      |
2 |  b2  |      |
--+------+------+
3 |  b3  |      |
--+------+------+

While using readRange := "B1:C" by

resp, _ := s.srv.Spreadsheets.Values.Get(spreadsheetId, readRange).Do()
for _, row := range resp.Values {
   ...
}

I can't tell the difference between C2 and C3. In this case, I would like to fill some values to C3 but not C2. How do I check this via API?

  • 写回答

1条回答 默认 最新

  • duan5731 2019-04-04 06:52
    关注
    • You want to retrieve the information of merge cells in a sheet using Sheets API.

    From your replying, I could understand like above. If my understanding is correct, the method of spreadsheets.values.get cannot retrieve the information of merge cells. In this case, please use the method of spreadsheets.get. The modified script is as follows.

    Modified script:

    ranges := []string{"B1:C"}
    resp, _ := s.srv.Spreadsheets.Get(spreadsheetId).Ranges(ranges...).Do()
    for _, sheet := range resp.Sheets {
        for _, merge := range sheet.Merges {
            fmt.Printf("%#v
    ", merge)
        }
    }
    

    Note:

    • This modified script supposes that you have already used Sheets API.
    • Range of B1:C means B1:C of the first tab.
    • When you run above script, you can retrieve the coordinates of the merged cells as the GridRange like below.

      {
        "sheetId": 0,
        "startRowIndex": 0,
        "endRowIndex": 2,
        "startColumnIndex": 2,
        "endColumnIndex": 3
      }
      
      • This GridRange is C1:C2 of sheet ID 0 as the a1Notation.
        • From above result, it is found that C1:C2 is the merged cell.
        • In this case, when the value is put in C1, the value is displayed. But when the value is put in C2, the value is not displayed. Please be careful this.
      • If you want to put the value using the GridRange, you can use the method of spreadsheets.batchUpdate.

    References:

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 metadata提取的PDF元数据,如何转换为一个Excel
  • ¥15 关于arduino编程toCharArray()函数的使用
  • ¥100 vc++混合CEF采用CLR方式编译报错
  • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
  • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
  • ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
  • ¥50 如何openEuler 22.03上安装配置drbd
  • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
  • ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
  • ¥15 Windows11, backspace, enter, space键失灵