以编程方式检索Google表格单元格边框样式 [英] Retrieving Google Sheets cell border style programmatically

问题描述

可以设置范围边框样式和颜色。现在的问题是：我们如何获得边框样式的程序化？

我正在寻找类似的东西：

  var ss = SpreadsheetApp.getActiveSpreadsheet（）; var sheet = ss.getSheets（）[0]; var b2 = sheet.getRange（ B2）; var border = b2.getBorder（）; //不存在但是b2.setBorder会： -  /  

解决方案

我不确定这是否是最好的方法。我总是使用Sheets API检索边框样式。示例脚本如下。

使用此示例脚本时，请在Advanced Google服务和API控制台中启用Sheets API。

在高级Google服务中启用表格API v4

• 在脚本编辑器中
  
  
  
  
  • 资源 - >高级Google服务
  
  
  • 开启Google表格API v4
  
  
  
  
  
  

  在API控制台中启用表格API v4
  $ b

  
  
  • 在脚本编辑器中
    
    
    
    
    • 资源 - >云平台项目
    
    
    • 查看API控制台
    
    
    • 在入门点击启用API并获取密钥等凭据。 li>
      
    • 在左侧，单击库。
    
    
    • 在Search for APIs&服务，输入表。点击启用按钮。
    
    
    • 如果API已经启用，请不要关闭。
    
    
    
    $ b

    如果您现在使用Sheets API的脚本打开脚本编辑器，则可以启用通过访问此网址 https：//控制台。 cloud.google.com/apis/library/sheets.googleapis.com/

    
    
    

    示例脚本：

    
    
    

      var spreadsheetId = SpreadsheetApp.getActiveSpreadsheet（）。getId（）; 
     var res = Sheets.Spreadsheets.get（spreadsheetId，{ranges：Sheet1！B2，fields：sheets / data / rowData / values / userEnteredFormat / borders}）; 
      

    
    
    

    参考文献：

    
    
    
    
    
    • 高级Google服务： https://developers.google.com/apps -script / guides / services / advanced
    
    
    • 表单API v4： https://developers.google.com/sheets/api/
    
    
    
    
    

    如果这没有用对你而言，我很抱歉。
    

    It is possible to set the range border style and color. Now the question is: how can we get the border style programaticaly?

    I'm looking for something like:

    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheets()[0];
    var b2 = sheet.getRange("B2");
    
    var border = b2.getBorder(); // does not exists but b2.setBorder does :-/

    解决方案

    I'm not sure whether this is the best way. I always retrieve the border style using Sheets API. The sample script is as follows.

    When you use this sample script, please enable Sheets API at Advanced Google Services and API console.

    Enable Sheets API v4 at Advanced Google Services

    • On script editor
      • Resources -> Advanced Google Services
      • Turn on Google Sheets API v4

    Enable Sheets API v4 at API console

    • On script editor
      • Resources -> Cloud Platform project
      • View API console
      • At Getting started, click Enable APIs and get credentials like keys.
      • At left side, click Library.
      • At Search for APIs & services, input "sheets". And click Google Sheets API.
      • Click Enable button.
      • If API has already been enabled, please don't turn off.

    If now you are opening the script editor with the script for using Sheets API, you can enable Sheets API for the project by accessing this URL https://console.cloud.google.com/apis/library/sheets.googleapis.com/

    Sample script :

    var spreadsheetId = SpreadsheetApp.getActiveSpreadsheet().getId();
    var res = Sheets.Spreadsheets.get(spreadsheetId, {ranges: "Sheet1!B2", fields: "sheets/data/rowData/values/userEnteredFormat/borders"});
    

    References :

    • Advanced Google Services : https://developers.google.com/apps-script/guides/services/advanced
    • Sheets API v4: https://developers.google.com/sheets/api/

    If this was not useful for you, I'm sorry.

    这篇关于以编程方式检索Google表格单元格边框样式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！