gsheetcli - npm Package Compare versions

Comparing version 1.0.0 to 1.0.1

index.js

@@ -92,2 +92,3 @@ #!/usr/bin/env node
         }
+        // getting sheet title for constructing range
         const sheetProperty = spreadsheet.data.sheets.find(sheet => sheet.properties ? sheet.properties.sheetId === range.sheetId : false);
@@ -97,6 +98,7 @@ if (!sheetProperty || !sheetProperty.properties) {
         }
+        const finalRange = range.range ? `${sheetProperty.properties.title}!${range.range}` : sheetProperty.properties.title;
         const sheetData = yield service.spreadsheets.values.get({
             'majorDimension': 'ROWS',
             'spreadsheetId': range.spreadSheetId,
-            'range': sheetProperty.properties.title,
+            'range': finalRange,
         });
@@ -128,2 +130,3 @@ for (const row of sheetData.data.values || []) {
             }
+            // getting sheet title for constructing range
             const sheetProperty = spreadsheet.data.sheets.find(sheet => sheet.properties ? sheet.properties.sheetId === range.sheetId : false);
@@ -133,4 +136,5 @@ if (!sheetProperty || !sheetProperty.properties) {
             }
+            const finalRange = range.range ? `${sheetProperty.properties.title}!${range.range}` : sheetProperty.properties.title;
             const resp = yield service.spreadsheets.values.update({
-                'range': sheetProperty.properties.title,
+                'range': finalRange,
                 'spreadsheetId': range.spreadSheetId,
@@ -137,0 +141,0 @@ 'valueInputOption': 'RAW',

index.ts

@@ -76,2 +76,3 @@ #!/usr/bin/env node
     }
+    // getting sheet title for constructing range
     const sheetProperty = spreadsheet.data.sheets.find(sheet => sheet.properties ? sheet.properties.sheetId === range.sheetId : false);
@@ -81,6 +82,7 @@ if (!sheetProperty || !sheetProperty.properties) {
     }
+    const finalRange = range.range ? `${sheetProperty.properties.title}!${range.range}` : sheetProperty.properties.title;
     const sheetData = await service.spreadsheets.values.get({
         'majorDimension': 'ROWS',
         'spreadsheetId': range.spreadSheetId,
-        'range': sheetProperty.properties.title,
+        'range': finalRange,
     });
@@ -114,2 +116,3 @@ for (const row of sheetData.data.values || []) {
         }
+        // getting sheet title for constructing range
         const sheetProperty = spreadsheet.data.sheets.find(
@@ -121,4 +124,5 @@ sheet => sheet.properties ? sheet.properties.sheetId === range.sheetId : false,
         }
+        const finalRange = range.range ? `${sheetProperty.properties.title}!${range.range}` : sheetProperty.properties.title;
         const resp = await service.spreadsheets.values.update({
-            'range': sheetProperty.properties.title,
+            'range': finalRange,
             'spreadsheetId': range.spreadSheetId,
@@ -125,0 +129,0 @@ 'valueInputOption': 'RAW',

package.json

 {
   "name": "gsheetcli",
-  "version": "1.0.0",
+  "version": "1.0.1",
   "description": "Simple Google Sheets command line tools",
@@ -5,0 +5,0 @@ "main": "index.js",

README.md

  
- # gsheetcli
+# gsheetcli
 
-`gsheetcli` is a simple command line that manages Google Sheets.
+`gsheetcli` is a simple command line tool that manages Google Sheets.
 
@@ -6,0 +6,0 @@ ## Installation

No alert changes

Improved metrics

Total package byte prevSize

22064

increased by8.4%

Number of package files

6

increased by20%

Lines of code

446

increased by1.83%

No dependency changes