Skip to main content

Create spreadsheet

Creates a new spreadsheet

Function CreateSpreadsheet(Val Token, Val Name, Val ArrayOfSheetNames) Export

ParameterCLI optionTypeRequiredDescription
Token--tokenString✔Token
Name--titleString✔Name
ArrayOfSheetNames--sheetsArray of String✔Array of names to add new sheets to the spreadsheet

Returns: Map Of KeyAndValue - serialized JSON response from Google


1C:Enterprise/OneScript code example
    Token = "ya29.a0ARW5m7702-Ib_bOq69krqD5iUx89SC2lxGPxRJoBjqvSBqE7uKghOyAjwrL7ebNf6xqPzwD4wQfZlFvBrb7QsWlw5PGW_SvkFr57Y8Js...";
    Name  = "TestTable";

    SheetArray = New Array;
    SheetArray.Add("Sheet1");
    SheetArray.Add("Sheet2");

    Result = OPI_GoogleSheets.CreateSpreadsheet(Token, Name, SheetArray);
    oint gsheets CreateSpreadsheet \
     --token "***" \
     --title "Test table (new.)" \
     --sheets "['Sheet1','Sheet2']"
Result
{
 "spreadsheetId": "1p_i-5lmOKdBEbi88O0SkXq2Q_gG0c4EY7N_wtWGKSCs",
 "properties": {
  "title": "TestTable",
  "locale": "ru_RU",
  "autoRecalc": "ON_CHANGE",
  "timeZone": "Etc/GMT",
  "defaultFormat": {
   "backgroundColor": {
    "red": 1,
    "green": 1,
    "blue": 1
   },
   "padding": {
    "top": 2,
    "right": 3,
    "bottom": 2,
    "left": 3
   },
   "verticalAlignment": "BOTTOM",
   "wrapStrategy": "OVERFLOW_CELL",
   "textFormat": {
    "foregroundColor": {},
    "fontFamily": "arial,sans,sans-serif",
    "fontSize": 10,
    "bold": false,
    "italic": false,
    "strikethrough": false,
    "underline": false,
    "foregroundColorStyle": {
     "rgbColor": {}
    }
   },
   "backgroundColorStyle": {
    "rgbColor": {
     "red": 1,
     "green": 1,
     "blue": 1
    }
   }
  },
  "spreadsheetTheme": {
   "primaryFontFamily": "Arial",
   "themeColors": [
    {
     "colorType": "TEXT",
     "color": {
      "rgbColor": {}
     }
    },
    {
     "colorType": "BACKGROUND",
     "color": {
      "rgbColor": {
       "red": 1,
       "green": 1,
       "blue": 1
      }
     }
    },
    {
     "colorType": "ACCENT1",
     "color": {
      "rgbColor": {
       "red": 0.25882354,
       "green": 0.52156866,
       "blue": 0.95686275
      }
     }
    },
    {
     "colorType": "ACCENT2",
     "color": {
      "rgbColor": {
       "red": 0.91764706,
       "green": 0.2627451,
       "blue": 0.20784314
      }
     }
    },
    {
     "colorType": "ACCENT3",
     "color": {
      "rgbColor": {
       "red": 0.9843137,
       "green": 0.7372549,
       "blue": 0.015686275
      }
     }
    },
    {
     "colorType": "ACCENT4",
     "color": {
      "rgbColor": {
       "red": 0.20392157,
       "green": 0.65882355,
       "blue": 0.3254902
      }
     }
    },
    {
     "colorType": "ACCENT5",
     "color": {
      "rgbColor": {
       "red": 1,
       "green": 0.42745098,
       "blue": 0.003921569
      }
     }
    },
    {
     "colorType": "ACCENT6",
     "color": {
      "rgbColor": {
       "red": 0.27450982,
       "green": 0.7411765,
       "blue": 0.7764706
      }
     }
    },
    {
     "colorType": "LINK",
     "color": {
      "rgbColor": {
       "red": 0.06666667,
       "green": 0.33333334,
       "blue": 0.8
      }
     }
    }
   ]
  }
 },
 "sheets": [
  {
   "properties": {
    "sheetId": 1448844153,
    "title": "Sheet1",
    "index": 0,
    "sheetType": "GRID",
    "gridProperties": {
     "rowCount": 1000,
     "columnCount": 26
    }
   }
  },
  {
   "properties": {
    "sheetId": 1415561922,
    "title": "Sheet2",
...