public-google-sheets-parser - npm Package Compare versions

Comparing version 1.0.1 to 1.0.2

dist/index.js

@@ -5,2 +5,2 @@ // for regeneratorRuntime
 // transpiled code
-function asyncGeneratorStep(e,r,t,n,a,o,i){try{var u=e[o](i),s=u.value}catch(e){return void t(e)}u.done?r(s):Promise.resolve(s).then(n,a)}function _asyncToGenerator(u){return function(){var e=this,i=arguments;return new Promise(function(r,t){var n=u.apply(e,i);function a(e){asyncGeneratorStep(n,r,t,a,o,"next",e)}function o(e){asyncGeneratorStep(n,r,t,a,o,"throw",e)}a(void 0)})}}function _toArray(e){return _arrayWithHoles(e)||_iterableToArray(e)||_unsupportedIterableToArray(e)||_nonIterableRest()}function _nonIterableRest(){throw new TypeError("Invalid attempt to destructure non-iterable instance.\nIn order to be iterable, non-array objects must have a [Symbol.iterator]() method.")}function _unsupportedIterableToArray(e,r){if(e){if("string"==typeof e)return _arrayLikeToArray(e,r);var t=Object.prototype.toString.call(e).slice(8,-1);return"Object"===t&&e.constructor&&(t=e.constructor.name),"Map"===t||"Set"===t?Array.from(e):"Arguments"===t||/^(?:Ui|I)nt(?:8|16|32)(?:Clamped)?Array$/.test(t)?_arrayLikeToArray(e,r):void 0}}function _arrayLikeToArray(e,r){(null==r||r>e.length)&&(r=e.length);for(var t=0,n=new Array(r);t<r;t++)n[t]=e[t];return n}function _iterableToArray(e){if("undefined"!=typeof Symbol&&Symbol.iterator in Object(e))return Array.from(e)}function _arrayWithHoles(e){if(Array.isArray(e))return e}function _defineProperty(e,r,t){return r in e?Object.defineProperty(e,r,{value:t,enumerable:!0,configurable:!0,writable:!0}):e[r]=t,e}function _classCallCheck(e,r){if(!(e instanceof r))throw new TypeError("Cannot call a class as a function")}function _defineProperties(e,r){for(var t=0;t<r.length;t++){var n=r[t];n.enumerable=n.enumerable||!1,n.configurable=!0,"value"in n&&(n.writable=!0),Object.defineProperty(e,n.key,n)}}function _createClass(e,r,t){return r&&_defineProperties(e.prototype,r),t&&_defineProperties(e,t),e}var PublicGoogleSheetsParser=function(){"use strict";function r(e){if(_classCallCheck(this,r),!e)throw new Error("SheetId is required.");this.id=e}var e;return _createClass(r,[{key:"getSheetsData",value:function(){return fetch("https://docs.google.com/spreadsheets/d/".concat(this.id,"/gviz/tq?")).then(function(e){return e.ok?e.text():null}).catch(function(e){return null})}},{key:"filterUselessRows",value:function(e){return e.filter(function(e){return e&&null!==e.v&&void 0!==e.v})}},{key:"applyHeaderIntoRows",value:function(n,e){var t=this;return e.map(function(e){var r=e.c;return t.filterUselessRows(r)}).map(function(e){return e.reduce(function(e,r,t){return Object.assign(e,_defineProperty({},n[t],r.v))},{})})}},{key:"getRows",value:function(e){var r=[];try{var t,n,a,o,i,u=JSON.parse(e.split("\n")[1].replace(/google.visualization.Query.setResponse\(|\)\;/g,""));r=u.table.cols.every(function(e){return!!e.label})?(t=u.table.cols.map(function(e){return e.label}),this.applyHeaderIntoRows(t,u.table.rows)):(a=(n=_toArray(u.table.rows))[0],o=n.slice(1),i=this.filterUselessRows(a.c).map(function(e){return e.v}),this.applyHeaderIntoRows(i,o))}catch(e){}return r}},{key:"parse",value:(e=_asyncToGenerator(regeneratorRuntime.mark(function e(){var r;return regeneratorRuntime.wrap(function(e){for(;;)switch(e.prev=e.next){case 0:return e.next=2,this.getSheetsData();case 2:if(null===(r=e.sent))return e.abrupt("return",new Error("Invalid sheets ID: ".concat(this.id)));e.next=5;break;case 5:return e.abrupt("return",this.getRows(r));case 6:case"end":return e.stop()}},e,this)})),function(){return e.apply(this,arguments)})}]),r}();
+function asyncGeneratorStep(e,r,t,n,a,o,i){try{var u=e[o](i),s=u.value}catch(e){return void t(e)}u.done?r(s):Promise.resolve(s).then(n,a)}function _asyncToGenerator(u){return function(){var e=this,i=arguments;return new Promise(function(r,t){var n=u.apply(e,i);function a(e){asyncGeneratorStep(n,r,t,a,o,"next",e)}function o(e){asyncGeneratorStep(n,r,t,a,o,"throw",e)}a(void 0)})}}function _toArray(e){return _arrayWithHoles(e)||_iterableToArray(e)||_unsupportedIterableToArray(e)||_nonIterableRest()}function _nonIterableRest(){throw new TypeError("Invalid attempt to destructure non-iterable instance.\nIn order to be iterable, non-array objects must have a [Symbol.iterator]() method.")}function _unsupportedIterableToArray(e,r){if(e){if("string"==typeof e)return _arrayLikeToArray(e,r);var t=Object.prototype.toString.call(e).slice(8,-1);return"Object"===t&&e.constructor&&(t=e.constructor.name),"Map"===t||"Set"===t?Array.from(e):"Arguments"===t||/^(?:Ui|I)nt(?:8|16|32)(?:Clamped)?Array$/.test(t)?_arrayLikeToArray(e,r):void 0}}function _arrayLikeToArray(e,r){(null==r||r>e.length)&&(r=e.length);for(var t=0,n=new Array(r);t<r;t++)n[t]=e[t];return n}function _iterableToArray(e){if("undefined"!=typeof Symbol&&Symbol.iterator in Object(e))return Array.from(e)}function _arrayWithHoles(e){if(Array.isArray(e))return e}function _defineProperty(e,r,t){return r in e?Object.defineProperty(e,r,{value:t,enumerable:!0,configurable:!0,writable:!0}):e[r]=t,e}function _classCallCheck(e,r){if(!(e instanceof r))throw new TypeError("Cannot call a class as a function")}function _defineProperties(e,r){for(var t=0;t<r.length;t++){var n=r[t];n.enumerable=n.enumerable||!1,n.configurable=!0,"value"in n&&(n.writable=!0),Object.defineProperty(e,n.key,n)}}function _createClass(e,r,t){return r&&_defineProperties(e.prototype,r),t&&_defineProperties(e,t),e}var PublicGoogleSheetsParser=function(){"use strict";function r(e){if(_classCallCheck(this,r),!e)throw new Error("SheetId is required.");this.id=e}var e;return _createClass(r,[{key:"getSheetsData",value:function(){return fetch("https://docs.google.com/spreadsheets/d/".concat(this.id,"/gviz/tq?")).then(function(e){return e.ok?e.text():null}).catch(function(e){return null})}},{key:"filterUselessRows",value:function(e){return e.filter(function(e){return e&&null!==e.v&&void 0!==e.v})}},{key:"applyHeaderIntoRows",value:function(n,e){var t=this;return e.map(function(e){var r=e.c;return t.filterUselessRows(r)}).map(function(e){return e.reduce(function(e,r,t){return Object.assign(e,_defineProperty({},n[t],r.v))},{})})}},{key:"getRows",value:function(e){var r=[];try{var t,n,a,o,i,u=JSON.parse(e.split("\n")[1].replace(/google.visualization.Query.setResponse\(|\)\;/g,""));r=u.table.cols.every(function(e){return!!e.label})?(t=u.table.cols.map(function(e){return e.label}),this.applyHeaderIntoRows(t,u.table.rows)):(a=(n=_toArray(u.table.rows))[0],o=n.slice(1),i=this.filterUselessRows(a.c).map(function(e){return e.v}),this.applyHeaderIntoRows(i,o))}catch(e){}return r}},{key:"parse",value:(e=_asyncToGenerator(regeneratorRuntime.mark(function e(){var r;return regeneratorRuntime.wrap(function(e){for(;;)switch(e.prev=e.next){case 0:return e.next=2,this.getSheetsData();case 2:if(null===(r=e.sent))return e.abrupt("return",new Error("Invalid sheets ID: ".concat(this.id)));e.next=5;break;case 5:return e.abrupt("return",this.getRows(r));case 6:case"end":return e.stop()}},e,this)})),function(){return e.apply(this,arguments)})}]),r}();globalThis.PublicGoogleSheetsParser = PublicGoogleSheetsParser;

package.json

 {
   "name": "public-google-sheets-parser",
-  "version": "1.0.1",
+  "version": "1.0.2",
   "description": "Public Google sheets parser for browser",
@@ -5,0 +5,0 @@ "main": "./dist/index.js",

README.md

@@ -15,5 +15,7 @@ # Public Google sheets parser for browser
 
-```js
+```html
 // import distribution file before make PublicGoogleSheetsParser instance. (see /dist/index.js)
+<script src="https://github.com/fureweb-com/public-google-sheets-parser/blob/master/dist/index.js"></script>
 
+<script>
 const sheetsId = '10WDbAPAY7Xl5DT36VuMheTPTTpqx9x0C5sDCnh4BGps'
@@ -24,4 +26,5 @@ const parser = new PublicGoogleSheetsParser(sheetsId)
 })
+</script>
 ```
 
 **That's it!**

src/index.js

@@ -58,1 +58,3 @@ class PublicGoogleSheetsParser {
 }
+
+globalThis.PublicGoogleSheetsParser = PublicGoogleSheetsParser

No alert changes

Improved metrics

Total package byte prevSize

14261

increased by5.73%

Number of package files

5

increased by25%

Lines of code

88

increased by1.15%

Number of lines in readme file

29

increased by11.54%

No dependency changes