{"_id":"@microsoft/connected-workbooks","_rev":"30-dc67cbf7d1bbc22cd524ffdd890798e6","name":"@microsoft/connected-workbooks","dist-tags":{"latest":"3.4.2"},"versions":{"1.0.0":{"name":"@microsoft/connected-workbooks","version":"1.0.0","keywords":["Power Query","Excel","Workbook","Refresh"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@1.0.0","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"ee8b255f2f1154b07e0e935cc1e3c872f1ad4ecf","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-1.0.0.tgz","fileCount":18,"integrity":"sha512-WLb+GtgfpiKqaqHGQB8fp4LGTQWwcuhMm4raG38r8U21UI4B5QBv6LsAp3DnmCWDy4IAWFJBYLa/Jv8+/IGNng==","signatures":[{"sig":"MEUCIAukzpya8Njhy9lMP4pa4QTgiJ4ZdqLY6Wk/EgVARlyLAiEAv/HCrm/Tzn6DV61tqNFJqn/VzBo9McUZ/VWDxDFzDx4=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":79503,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJgv9R0CRA9TVsSAnZWagAA1VMP/1Bo79xfMHhuyTbUO4f+\ny9bJG0kidnNHOI2n5Acjc+YB2vUkJj/7AarbNYv6X9WWzmHd2u0dXC7YXfT8\nZlfjUe4i5Hxycr5xYK2x1n2N0puv0fyb9JJdYACs/iMWoAg/DIU8qmgTaHun\nkVi2iVOuNkeASRlwz5XPzadCitVV3JKGfn+D567EQ0m4mp+I+sU/oSK/YKGT\nstknYDM8rusKNqnFPGIWVblNUx8QR24qdoUTkvpFHStWHL21P6jhx/s8MSqo\nuzRlEgi2XT+0jNx87FxAmcOuFdYIg3gO+Zy81H4j2CCNMUSk2W3Cepl7rqQ2\n2Vtu/Jz0V9kW4GfUpnaLhJDK8hK3QwDF7clbl0nfL+ZoRQVVGFXLHB0RJVqL\nDJhL26HkPKQgcyHMDaAp5sTPEx3hCknDibCpbznKcQXGsqxYupr5meypCaz5\niHuA0u+M4/5IB2/kmSgOQNXBgZCTUvcMjrhEi+3kQrds3cGd0iER7NfUoUK6\ntUy6G3JrjvfLToAGBnjCvxrIKl6wYpao2s+o2kX03DEtzJVDkZn168zfOB5R\nsOczoplADtP84A+i5oflNGyrW3qtj7jTegx66NlxWeX5SWSTVFscpjIZ+owx\n2vaSNyPJXOJ2tVK63yOyztBRnfRsAAJp7jGoEzC2bbZOdSgr1xDPLJSiDoAE\nxSLT\r\n=6+VG\r\n-----END PGP SIGNATURE-----\r\n"},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"952db9bddfb998786a137f3d1ca974643c0bf39d","scripts":{"build":"tsc"},"_npmUser":{"name":"ron.microsoft","email":"roben@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"6.14.8","description":"Use this library to generate Excel workbooks with a custom Mashup Query loaded to the grid, to be used by applications for 'Export to Excel' features to allow refreshable workbooks","directories":{},"_nodeVersion":"12.16.1","dependencies":{"jszip":"^3.5.0","iconv-lite":"^0.6.2","byte-base64":"^1.1.0"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","chai":"^4.2.0","mocha":"^8.2.1","ts-node":"^9.0.0","prettier":"^2.2.1","typescript":"^4.0.5","@types/chai":"^4.2.14","@types/mocha":"^8.0.3"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_1.0.0_1623184499960_0.3201375460429863","host":"s3://npm-registry-packages"}},"2.1.16-beta":{"name":"@microsoft/connected-workbooks","version":"2.1.16-beta","keywords":["Power Query","Excel","Workbook","Refresh"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@2.1.16-beta","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"6ff73f1cb4c9d254891eecd04095b141a6a30d4e","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-2.1.16-beta.tgz","fileCount":41,"integrity":"sha512-4RsySgYy7v1m9PGEnyzUd8UyjeG4OIwUBV2Y2bZ2vPFLp6N+16fvqVAyTf8McdJkl6gCzd/j/NfYKaghlPBrEQ==","signatures":[{"sig":"MEUCIErYmCgjnKKUf4W6Wpbf+VHnhnPQfFEdo5VxTrVMTqVGAiEAnV6W5E2O+lUPJAsMDbhzfvNFQhAynrJwp2440tKa+JU=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":232826},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"d873a6e646ec4684de4fa9e0a2283623fd82ad4e","scripts":{"test":"jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc"},"_npmUser":{"name":"ron.microsoft","email":"roben@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"8.11.0","description":"Use this library to generate Excel workbooks with a custom Mashup Query loaded to the grid, to be used by applications for 'Export to Excel' features to allow refreshable workbooks","directories":{},"_nodeVersion":"16.15.1","dependencies":{"jszip":"^3.5.0","base64-js":"^1.5.1","iconv-lite":"^0.6.2"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","prettier":"2.3.2","babel-jest":"^27.0.6","typescript":"^4.0.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_2.1.16-beta_1686624710077_0.5530525582036057","host":"s3://npm-registry-packages"}},"2.1.24-beta":{"name":"@microsoft/connected-workbooks","version":"2.1.24-beta","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@2.1.24-beta","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"4ef714e121a37fbb1369da4dd97a2c64e9c68fbf","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-2.1.24-beta.tgz","fileCount":22,"integrity":"sha512-BtSbYXoM5FIMfMVmX2781lRAUXkydUgBwELG563YgJmOFllDC4eSPyON+W9X70vvfaGpgt+zNC+hZEKiVGD0aw==","signatures":[{"sig":"MEQCIGiIL941vKZe/1Zkxo2apAskOptTnKr/tQ2muyP5zfnrAiBcTVVOEOTKbkxc6626KUHO3qlSUQw2Yn9Yi5whud5LFA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":114976},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"718a34794b756e37b1808f470984b94cb1f355ee","scripts":{"test":"jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"ron.microsoft","email":"roben@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"8.11.0","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"16.15.1","dependencies":{"jszip":"^3.5.0","base64-js":"^1.5.1"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_2.1.24-beta_1687303180280_0.5251657309677127","host":"s3://npm-registry-packages"}},"2.1.25":{"name":"@microsoft/connected-workbooks","version":"2.1.25","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@2.1.25","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"cc52f77a5157e5d969a50bcf67cc961aa5ce5c4f","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-2.1.25.tgz","fileCount":51,"integrity":"sha512-kUiMGkcjJTadjwzij0sPUQgcwPUL4HoUCei6Yeqa/09Vz+WASl2QT/6mRjhQ6NE70fCZg/S3DOGMR68T9AtSZA==","signatures":[{"sig":"MEUCIATTRpYfE/87aKPIw2R+iyAI4WMQccb731KyaVZJobmrAiEAulyCfwc/wXyXPWooc9nzaRTIyyLwAIZKFUGPcs9yPG0=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":271472},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"17a2fbd0bc6d38a0d66953e03fc41a7145243146","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"ron.microsoft","email":"roben@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"8.11.0","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"16.15.1","dependencies":{"jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_2.1.25_1688940692071_0.7214922159977699","host":"s3://npm-registry-packages"}},"3.0.0":{"name":"@microsoft/connected-workbooks","version":"3.0.0","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.0.0","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"da91984fa22efa6f135e90135021a268ef7d6859","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.0.0.tgz","fileCount":51,"integrity":"sha512-kS2Z4PkGNy6QDpd0Y11anXx0n8PTGQXRbOvTmjZ8vhKm0eTCNOjPzsj6Wkc/kp3PgnFb4eAZXuaRrAWNJkHbZw==","signatures":[{"sig":"MEUCIAjAuXazpECS2njG5HzcOqR21/VpM8g3FyQaGanAhqgQAiEAwsVI32FGxRfo8qtzXaWk/+GrPdua1i8rBePibyYxezM=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":276653},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"032062546c8838cafa6f9e2c25d9ded447f94af8","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"ron.microsoft","email":"roben@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"8.11.0","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"16.15.1","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.0.0_1691001075913_0.12841448516749465","host":"s3://npm-registry-packages"}},"3.1.1-beta.1":{"name":"@microsoft/connected-workbooks","version":"3.1.1-beta.1","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.1.1-beta.1","maintainers":[{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"e5a98dbb3cf88d70166fb6e77036a46b97e4d1f8","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.1.1-beta.1.tgz","fileCount":54,"integrity":"sha512-vv3pNK26n/DjHhkC9TwyB9RwF6moDSf8Ui97U2Sm2iqkVE/fJmP6NC4OijdGrcE44RPyrHqdh6D2V+QGYgeqfQ==","signatures":[{"sig":"MEQCIHkikuBohgJA9R6iaUTg04kKBo5YS/kqVoB0LmHPdeKgAiB6f9AhgN4G980m/TALresjZvaIH2HNBhYH3xAtytJbKA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":702183},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"e8703046e7a125719f03a30a9702587346b0552a","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"9.5.1","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"18.16.0","dependencies":{"uuid":"^9.0.0","axios":"^1.6.8","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.1.1-beta.1_1715010052413_0.7079227177357219","host":"s3://npm-registry-packages"}},"3.1.1-beta.2":{"name":"@microsoft/connected-workbooks","version":"3.1.1-beta.2","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.1.1-beta.2","maintainers":[{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"cb35d58d49f9418aad173eda9b27e498a4aa97e2","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.1.1-beta.2.tgz","fileCount":54,"integrity":"sha512-6nJYY3oWdK7AGFOGrxfFO8+rBjJ/xS/DqepIyGSA6bQoK4i17J1qhrmgtfdPhkikqS5fINX1td39IjV8wjRZXg==","signatures":[{"sig":"MEQCIF/EIhfmw3qTvc06x0p/YPTpOfhfP+P3JXysNQMFHb3uAiANxMZvoyCDZX7tHrBWNhs4LPWneRISE1EYHs3vKMzgFg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":628451},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"4b4c59ded2f4f946fc789c691e0b933fc78ec419","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"9.5.1","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"18.16.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.1.1-beta.2_1717352413712_0.9246500812821028","host":"s3://npm-registry-packages"}},"3.1.2-beta.2":{"name":"@microsoft/connected-workbooks","version":"3.1.2-beta.2","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.1.2-beta.2","maintainers":[{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"0eb6aeb586337fbb2ba686f978f0b172cdc88953","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.1.2-beta.2.tgz","fileCount":54,"integrity":"sha512-DaP8+39J1k2H5sLcwZWFM2E3jtDvu9G+l91uZdpQHa8K9Ml92IG0Una4ZpudFDE74xRSDRfPdbKQd9JqF0QGZw==","signatures":[{"sig":"MEUCIDgkcTUzAGUBKmF6D8PP5Oma3XXH5SD+AixrCpH3YBj1AiEAy8GOhavsgFOX6T1v9JqpsHV8kF2IdQdbmikRzVMgRN4=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":639024},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"d3c84d7784e741afb56f5c27a54d0b1ba693a8c9","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"9.5.1","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"18.16.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.1.2-beta.2_1720025397101_0.36070466695432013","host":"s3://npm-registry-packages"}},"3.1.3-beta":{"name":"@microsoft/connected-workbooks","version":"3.1.3-beta","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.1.3-beta","maintainers":[{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"473b229820926fc20f10bb2857c19e556c0da02f","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.1.3-beta.tgz","fileCount":54,"integrity":"sha512-yGvsFQAJma42xoFPKi53CdaxlZZJJUDo73gJErA9aanEm+MjJQPO+hH2rCsVFfTsF6adtdsZohTgYrdzZm72Ag==","signatures":[{"sig":"MEYCIQC5kR2IDg05pRu79pFtfQwpv4SCyNfBkMF1UAI+4vfmNAIhAN2AWQneeChJVtRjR7mxHVtkprYXmbErYAUMHpsnZzU3","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":928511},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"815df6bd37b646212af53a91f356dc64c74558c0","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"9.5.1","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"18.16.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.1.3-beta_1730809323648_0.45496629610745654","host":"s3://npm-registry-packages"}},"3.2.0-beta":{"name":"@microsoft/connected-workbooks","version":"3.2.0-beta","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.2.0-beta","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"f0e4d1ec51037b456cbcab75bcece0069f1042ec","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.2.0-beta.tgz","fileCount":54,"integrity":"sha512-+CgxRjiAT/OfP20nw3gg5NBPi+ickYGlCa3imcF/Ug2xM9QuVoakoRZbuLWhPRcx0P57kra+aKqrB1LamOfRwg==","signatures":[{"sig":"MEYCIQCaEOx35iJrxp6qs0HGLVSFsl5q9KPNo/EmXr1nYrGDhwIhAPR2INxVQaOOZkm1Ua/MHkpaHapl//5bpGwno9JI7AZ4","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":930152},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"fde409fbb77e3cd5d3b46229d4eca7bebe6801c8","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"9.5.1","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"18.16.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.2.0-beta_1734881363862_0.15193187880291448","host":"s3://npm-registry-packages-npm-production"}},"3.2.2-beta":{"name":"@microsoft/connected-workbooks","version":"3.2.2-beta","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.2.2-beta","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"7b6659ffa58f8c9f56b74432d62e3483590a82f2","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.2.2-beta.tgz","fileCount":50,"integrity":"sha512-AaZqGmU/ocV1rY/xTYDb03eVpiELoiwkAajf5UN2EQ/ao5IgCaCpLb/peqe2Gt1BWP2G147jIp9JBBdd3eIbWQ==","signatures":[{"sig":"MEUCIQCKFBbFhcESiVkJKLeHCyC5omDAlV+XQxBBuP9cceja7QIgAWH9TBWJ073HmhfEZK3Z3rpaXfScqA0VLnHN2I5Ro6c=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":814009},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"3d03d13ae20c15d260ea744816332f26cef3ff57","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"10.9.2","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"22.14.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.2.2-beta_1753953216221_0.30072402710406143","host":"s3://npm-registry-packages-npm-production"}},"3.3.1-beta":{"name":"@microsoft/connected-workbooks","version":"3.3.1-beta","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.3.1-beta","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"e488622301cb29f60ba1ef7b1e6e5a553ce497b1","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.3.1-beta.tgz","fileCount":50,"integrity":"sha512-wamKWbizHLjtoSYojMj+Wu9mq3XaVoCeYEttgfVJw2Ui7zUOh/gfTQq1qD19If1M9Gbpyt386MQxdGNH8jglmQ==","signatures":[{"sig":"MEUCIBxbFB24LfEfWyG5DLAVTaoiPcU7AjoY2SgFN3lua/N2AiEA00yFyUBaMOiRxji86cg97S/jqxcHy7tfw+fz3eIiHIY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":903563},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"14535b624c836fd407d7a8af26cf9acce61ef2b6","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"overrides":{"tmp":"^0.2.4","@octokit/request":"^8.4.1","@octokit/request-error":"^5.1.1","@octokit/plugin-paginate-rest":"^9.2.2"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"10.9.2","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"22.14.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.3.1-beta_1755070819892_0.3039612360689472","host":"s3://npm-registry-packages-npm-production"}},"3.3.2-beta":{"name":"@microsoft/connected-workbooks","version":"3.3.2-beta","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.3.2-beta","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"efee6e41c1da8f8dc725fb121eec50703ed43836","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.3.2-beta.tgz","fileCount":50,"integrity":"sha512-eU2VCYikb1+ZaV99TkN1ZVM32c8DPtQ1f2JQ5ZcBIgpUWW13qOjzHbzLBk45v7bye18RxCrw7vaniY4pThD3Cw==","signatures":[{"sig":"MEYCIQCiCa2f1gGb9GvNu5l7cO1krJfMsEKwHsj/Qy1t44ruXwIhAJEX6ibhcXVuDEujOKpl/NRJvlC5R3JRuBijitHJYoXS","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":944060},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"f8247718ae93cef8a0f65c7bf2dff66a8e75e925","scripts":{"test":"tsc --project tsconfig.test.json && jest","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"overrides":{"tmp":"^0.2.4","@octokit/request":"^8.4.1","@octokit/request-error":"^5.1.1","@octokit/plugin-paginate-rest":"^9.2.2"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"10.9.2","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"22.14.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.3.2-beta_1755502904475_0.4964760251595597","host":"s3://npm-registry-packages-npm-production"}},"3.4.0-beta":{"name":"@microsoft/connected-workbooks","version":"3.4.0-beta","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.4.0-beta","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"5cade80aa4c05f726fef49e2e8c4721646311a37","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.4.0-beta.tgz","fileCount":23,"integrity":"sha512-VaSg+vhzNCKEbF3OboeJxNV6orH7BtdHflZ1A7Rs5cO7Pe+IhSiZTClwlQIny6BUSlmsoluhEfcmGYXZdufI7g==","signatures":[{"sig":"MEUCIFdoigRLhjdAQYJAsEYewvsZj4p0G6fYs16nPzXrbM+LAiEA47F+T5Ss6FujKqWnr0pYTGNzBSGWxQJzvzXpswg7Gv0=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":698036},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"b2010d29ffc6325f06673cc3ff4ff89c3246329c","scripts":{"test":"npm run test:jsdom && npm run test:node","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","test:node":"tsc && jest --config jest.config.node.js","test:jsdom":"tsc && jest --config jest.config.jsdom.js","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"overrides":{"tmp":"^0.2.4","@octokit/request":"^8.4.1","@octokit/request-error":"^5.1.1","@octokit/plugin-paginate-rest":"^9.2.2"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"10.9.2","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"22.14.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.4.0-beta_1756992580114_0.28587203630485525","host":"s3://npm-registry-packages-npm-production"}},"3.4.0":{"name":"@microsoft/connected-workbooks","version":"3.4.0","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.4.0","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"07442790767227a3694b362f88c260027fde633d","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.4.0.tgz","fileCount":23,"integrity":"sha512-+fKfzxgdUkXzJf5j4O/tdVFaAoXp/RHP+0VHMjn5bE1dfPPLGTMXA5Z507OiNt32GydBOYGTUWtcSrA/Qii+hA==","signatures":[{"sig":"MEUCIQCPoi5exAyi6rI210fNwDB1cQymSzPnyIzX1x3M39/gBwIgbjCUNFvWgCEt6ZKqtTYE50TExwI05JlArdRZRl//9gI=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":698264},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"d98e6cf1d6ce16f53beae15b2862ef639340a6d4","scripts":{"test":"npm run test:jsdom && npm run test:node","build":"tsc","clean":"jest --clearCache","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","test:node":"tsc && jest --config jest.config.node.js","test:clean":"npm run clean && npm run test","test:jsdom":"tsc && jest --config jest.config.jsdom.js","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"overrides":{"tmp":"^0.2.4","@octokit/request":"^8.4.1","@octokit/request-error":"^5.1.1","@octokit/plugin-paginate-rest":"^9.2.2"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"10.9.2","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"22.14.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.4.0_1758091660394_0.32531484926165244","host":"s3://npm-registry-packages-npm-production"}},"3.4.1":{"name":"@microsoft/connected-workbooks","version":"3.4.1","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.4.1","maintainers":[{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"98ee7a79888f156879fd88b149e7f4be28be5a48","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.4.1.tgz","fileCount":23,"integrity":"sha512-ANpy+bfhJJ9AKw7dhH+iBNkYPGbsNqBVPvz++w40AEvUtjF86rJSp9vNhRbqK3HRtt++aMwq2gQYxAANS6hkcQ==","signatures":[{"sig":"MEUCIQDx5sa1cfqMIkvFDIuw4ZPw9LqZbg38NuUCBSau2noO1wIgBHl7xf5kEzKjzkSOzsSm2EOFwENxCD7new9Ud6uonqs=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":660671},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"fdfdf0d17d517942d920124008eb3672b48f5e65","scripts":{"test":"npm run test:jsdom && npm run test:node","build":"tsc","clean":"jest --clearCache","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","test:node":"tsc && jest --config jest.config.node.js","test:clean":"npm run clean && npm run test","test:jsdom":"tsc && jest --config jest.config.jsdom.js","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"overrides":{"tmp":"^0.2.4","@octokit/request":"^8.4.1","@octokit/request-error":"^5.1.1","@octokit/plugin-paginate-rest":"^9.2.2"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"10.9.2","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"22.14.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^7.30.0","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^4.28.2","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^4.28.2"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.4.1_1759671447303_0.940305094987125","host":"s3://npm-registry-packages-npm-production"}},"3.4.2":{"name":"@microsoft/connected-workbooks","version":"3.4.2","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"author":{"name":"Microsoft"},"license":"MIT","_id":"@microsoft/connected-workbooks@3.4.2","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"},{"name":"ron.microsoft","email":"roben@microsoft.com"},{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"}],"homepage":"https://github.com/microsoft/connected-workbooks#readme","bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"dist":{"shasum":"558a76a72c1a21007bafb61d216a3f6f29ab0a18","tarball":"https://registry.npmjs.org/@microsoft/connected-workbooks/-/connected-workbooks-3.4.2.tgz","fileCount":23,"integrity":"sha512-fMw5KfXGoC4uG5rp74HKyVqpz5R5eeAQ0+ho06R9U2EBkw0ewQ2GQvAmSWYuWUtM4BzpbBEk53ZoMLiqEjNzNg==","signatures":[{"sig":"MEQCH1J1+fx+YX2i5bPrwmFZ3RazJOCDvWXlKyACGqKYvxYCIQCvA9lsB/accYpBB6DdpuFMJTLepVWsqSWz7NJkMstaRw==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":661741},"main":"./dist/index.js","types":"./dist/index.d.ts","gitHead":"f92639a798be669333ce91cd69853474e5ed3770","scripts":{"test":"npm run test:jsdom && npm run test:node","build":"tsc","clean":"jest --clearCache","format":"prettier --write \"src/**/*.ts\" \"tests/**/*.ts\" --config .prettierrc","test:node":"tsc && jest --config jest.config.node.js","test:clean":"npm run clean && npm run test","test:jsdom":"tsc && jest --config jest.config.jsdom.js","build-webpack-dev":"webpack --mode=development --node-env=development","build-webpack-prod":"webpack --mode=production --node-env=production"},"_npmUser":{"name":"mabezen.microsoft","email":"mabezen@microsoft.com"},"overrides":{"tmp":"^0.2.4","@octokit/request":"^8.4.1","@octokit/request-error":"^5.1.1","@octokit/plugin-paginate-rest":"^9.2.2"},"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"_npmVersion":"10.9.2","description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","directories":{},"_nodeVersion":"22.14.0","dependencies":{"uuid":"^9.0.0","jszip":"^3.5.0","buffer":"^6.0.3","base64-js":"^1.5.1","xmldom-qsa":"^1.1.3","@xmldom/xmldom":"~0.8.4"},"_hasShrinkwrap":false,"devDependencies":{"nyc":"^15.1.0","jest":"^27.0.6","eslint":"^9.39.2","ts-node":"^9.0.0","webpack":"^5.86.0","prettier":"2.3.2","ts-loader":"^9.4.3","babel-jest":"^27.0.6","typescript":"^4.9.5","@babel/core":"^7.14.6","@types/jest":"^26.0.24","@types/uuid":"^9.0.2","webpack-cli":"^5.1.4","@types/jszip":"^3.4.1","@types/base64-js":"^1.3.0","@babel/preset-env":"^7.14.7","eslint-plugin-jest":"^24.3.6","terser-webpack-plugin":"^5.3.9","eslint-config-prettier":"^8.3.0","eslint-plugin-prettier":"^3.4.0","@webpack-cli/generators":"^3.0.7","webpack-bundle-analyzer":"^4.9.0","@babel/preset-typescript":"^7.14.5","@typescript-eslint/parser":"^8.54.0","@types/webpack-bundle-analyzer":"^4.6.0","@typescript-eslint/eslint-plugin":"^8.54.0"},"_npmOperationalInternal":{"tmp":"tmp/connected-workbooks_3.4.2_1771139344612_0.7040889220792608","host":"s3://npm-registry-packages-npm-production"}}},"time":{"created":"2021-06-08T20:34:59.593Z","modified":"2026-07-16T15:43:47.452Z","1.0.0":"2021-06-08T20:35:00.154Z","2.1.16-beta":"2023-06-13T02:51:50.262Z","2.1.24-beta":"2023-06-20T23:19:40.513Z","2.1.25":"2023-07-09T22:11:32.225Z","3.0.0":"2023-08-02T18:31:16.193Z","3.1.0-beta.1":"2024-05-06T15:35:54.357Z","3.1.1-beta.1":"2024-05-06T15:40:52.610Z","3.1.1-beta.2":"2024-06-02T18:20:13.931Z","3.1.2-beta.2":"2024-07-03T16:49:57.314Z","3.1.3-beta":"2024-11-05T12:22:03.876Z","3.2.0-beta":"2024-12-22T15:29:24.118Z","3.2.1-beta":"2025-07-31T08:34:13.885Z","3.2.2-beta":"2025-07-31T09:13:36.464Z","3.3.1-beta":"2025-08-13T07:40:20.137Z","3.3.2-beta":"2025-08-18T07:41:44.671Z","3.4.0-beta":"2025-09-04T13:29:40.361Z","3.4.0":"2025-09-17T06:47:40.627Z","3.4.1":"2025-10-05T13:37:27.522Z","3.4.2":"2026-02-15T07:09:04.770Z"},"bugs":{"url":"https://github.com/microsoft/connected-workbooks/issues"},"author":{"name":"Microsoft"},"license":"MIT","homepage":"https://github.com/microsoft/connected-workbooks#readme","keywords":["Power Query","Excel","Office","Workbook","Refresh","Table","xlsx"],"repository":{"url":"git+https://github.com/microsoft/connected-workbooks.git","type":"git"},"description":"Microsoft backed, Excel advanced xlsx workbook generation JavaScript library","maintainers":[{"email":"npmjs@microsoft.com","name":"microsoft1es"},{"email":"microsoft-oss-publishing@microsoft.com","name":"microsoft-oss-releases"},{"email":"roben@microsoft.com","name":"ron.microsoft"},{"email":"mabezen@microsoft.com","name":"mabezen.microsoft"}],"readme":"
\r\n\r\n# Open In Excel\r\n\r\n[![TypeScript](https://img.shields.io/badge/TypeScript-007ACC?style=flat&logo=typescript&logoColor=white)](https://www.typescriptlang.org/)\r\n[![License](https://img.shields.io/github/license/microsoft/connected-workbooks)](https://github.com/microsoft/connected-workbooks/blob/master/LICENSE)\r\n[![npm version](https://img.shields.io/npm/v/@microsoft/connected-workbooks)](https://www.npmjs.com/package/@microsoft/connected-workbooks)\r\n[![Build Status](https://img.shields.io/github/workflow/status/microsoft/connected-workbooks/CI)](https://github.com/microsoft/connected-workbooks/actions)\r\n\r\n**Open your data directly in Excel for the Web with zero installation** - A JavaScript library that converts web tables and data into interactive Excel workbooks with Power Query integration and custom branded templates\r\n\r\n
\r\n\r\n \"Connected\r\n
\r\n 📺 Watch the video tutorial\r\n\r\n
\r\n\r\n\r\n
\r\n\r\n---\r\n\r\n## ✨ Key Features & Benefits\r\n\r\nTransform your web applications with enterprise-grade Excel integration that goes far beyond simple CSV exports.\r\n\r\n### 🎯 **Interactive Excel Workbooks, Not Static Files**\r\nConvert raw data or HTML tables arrays to Excel tables while preserving data types, ensuring your data maintains its structure and formatting. instead of basic CSV exports that lose all structure and functionality.\r\n\r\n### 🌐 **Zero-Installation Excel Experience**\r\nLaunch workbooks directly in Excel for the Web through any browser without requiring Excel desktop installation, making your data accessible to any user anywhere. No installation required, works on any device.\r\n\r\n### 🎨 **Corporate Branding & Custom Dashboards**\r\nInject your data into pre-built Excel templates containing your company branding, PivotTables, charts, and business logic while preserving all formatting and calculations. Use your own branded Excel templates with PivotTables and charts to maintain corporate identity and pre-built analytics.\r\n\r\n### 🔄 **Live Data Connections with Power Query**\r\nCreate workbooks that automatically refresh from your web APIs, databases, or data sources using Microsoft's Power Query technology, eliminating manual data updates. Create workbooks that refresh data on-demand using Power Query for real-time data updates and automated reporting.\r\n\r\n### ⚙️ **Advanced Configuration**\r\nFull control over document properties including title and description for professional document management, allowing you to customize metadata and maintain enterprise standards.\r\n\r\n---\r\n\r\n## 🏢 Where is this library used?\r\n\r\nOpen In Excel powers data export functionality across Microsoft's enterprise platforms:\r\n\r\n
\r\n\r\n|\"Azure|\"Log|\"Datamart\"|\"Viva|\r\n|:---:|:---:|:---:|:---:|\r\n|**Azure Data Explorer**|**Log Analytics**|**Datamart**|**Viva Sales**|\r\n\r\n
\r\n\r\n\r\n\r\n---\r\n\r\n## 🚀 Quick Start\r\n\r\n### Installation\r\n\r\n```bash\r\nnpm install @microsoft/connected-workbooks\r\n```\r\n\r\n---\r\n\r\n## 💡 Usage Examples\r\n\r\n### 📋 **HTML Table Export**\r\n\r\nPerfect for quick data exports from existing web tables.\r\n\r\n```typescript\r\nimport { workbookManager } from '@microsoft/connected-workbooks';\r\n\r\n// One line of code to convert any table\r\nconst blob = await workbookManager.generateTableWorkbookFromHtml(\r\n document.querySelector('table') as HTMLTableElement\r\n);\r\n\r\n// Open in Excel for the Web\r\n// Edit mode with full editing capabilities (default)\r\nworkbookManager.openInExcelWeb(blob, \"QuickExport.xlsx\");\r\n\r\n// View mode with typing disabled\r\nworkbookManager.openInExcelWeb(blob, \"QuickExport.xlsx\", false, false);\r\n\r\n// View mode with typing enabled\r\nworkbookManager.openInExcelWeb(blob, \"QuickExport.xlsx\", true, false);\r\n```\r\n\r\n### 📊 **Smart Data Formatting**\r\n\r\nTransform raw data arrays into professionally formatted Excel tables.\r\n\r\n```typescript\r\nimport { workbookManager } from '@microsoft/connected-workbooks';\r\n\r\nconst salesData = {\r\n config: {\r\n promoteHeaders: true, // First row becomes headers\r\n adjustColumnNames: true // Clean up column names\r\n },\r\n data: [\r\n [\"Product\", \"Revenue\", \"InStock\", \"Category\", \"LastUpdated\"],\r\n [\"Surface Laptop\", 1299.99, true, \"Hardware\", \"2024-10-26\"],\r\n [\"Office 365\", 99.99, true, \"Software\", \"2024-10-26\"],\r\n [\"Azure Credits\", 500.00, false, \"Cloud\", \"2024-10-25\"],\r\n [\"Teams Premium\", 149.99, true, \"Software\", \"2024-10-24\"]\r\n ]\r\n};\r\n\r\nconst blob = await workbookManager.generateTableWorkbookFromGrid(salesData);\r\nworkbookManager.openInExcelWeb(blob, \"SalesReport.xlsx\", true);\r\n```\r\n\r\n
\r\n\"Smart\r\n
\r\n\r\n\r\n\r\n### 🎨 **Custom Branded Templates**\r\n\r\nTransform your data using pre-built Excel templates with your corporate branding.\r\n\r\n\r\n\r\n**Steps:**\r\n\r\n1. **Prepare Your Template File**\r\n\r\n Open Excel and create (or open) your branded file.\r\n2. **Pick one sheet that will hold your data.**\r\n\r\n The default \"Sheet1\"(3)\r\n3. **Inside that sheet, choose were you want your data to be populated(1) and create a table (Insert → Table).**\r\n\r\n The default table name is Table1(2) \r\n The table need to have the same column structure as your incoming data.\r\n4. **Add any charts, formulas, or formatting that reference this table.**\r\n\r\n Example: Pie chart using Gross column(4).\r\n5. **Save the Excel file (e.g., my-template.xlsx).**\r\n6. **Use the saved file as the template for your incoming data**\r\n\r\nThe library will then populate the designated table with your data. Any functions, figures, or references linked to this table within the Excel template will automatically reflect the newly exported data.\r\n\r\n
\r\n\"Custom\r\n
\r\n\r\n
\r\n \r\n Download before.xlsx • Download after.xlsx\r\n
\r\n\r\n#### 📁 **Loading Template Files**\r\n\r\n```typescript\r\n// Method 1: File upload from user\r\nconst templateInput = document.querySelector('#template-upload') as HTMLInputElement;\r\nconst templateFile = templateInput.files[0];\r\n\r\n// Method 2: Fetch from your server\r\nconst templateResponse = await fetch('/assets/templates/sales-dashboard.xlsx');\r\nconst templateFile = await templateResponse.blob();\r\n\r\n// Method 3: Drag and drop\r\nfunction handleTemplateDrop(event: DragEvent) {\r\n const templateFile = event.dataTransfer.files[0];\r\n // Use templateFile with the library\r\n}\r\n```\r\n\r\n#### 📊 **Generate Branded Workbook**\r\n\r\n```typescript\r\nconst quarterlyData = {\r\n config: { promoteHeaders: true, adjustColumnNames: true },\r\n data: [\r\n [\"Region\", \"Q3_Revenue\", \"Q4_Revenue\", \"Growth\", \"Target_Met\"],\r\n [\"North America\", 2500000, 2750000, \"10%\", true],\r\n [\"Europe\", 1800000, 2100000, \"17%\", true],\r\n [\"Asia Pacific\", 1200000, 1400000, \"17%\", true],\r\n [\"Latin America\", 800000, 950000, \"19%\", true]\r\n ]\r\n};\r\n\r\n// Inject data into your branded template\r\nconst blob = await workbookManager.generateTableWorkbookFromGrid(\r\n quarterlyData,\r\n undefined, // Use template's existing data structure\r\n {\r\n templateFile: templateFile,\r\n TempleteSettings: {\r\n sheetName: \"Dashboard\", // Target worksheet\r\n tableName: \"QuarterlyData\" // Target table name\r\n }\r\n }\r\n);\r\n\r\n// Users get a fully branded report\r\nworkbookManager.openInExcelWeb(blob, \"Q4_Executive_Dashboard.xlsx\", true);\r\n```\r\n\r\n
\r\n\"Custom\r\n
\r\n\r\n> 💡 **Template Requirements**: Include a query named **\"Query1\"** connected to a **Table**.\r\n\r\n### 🔄 **Live Data Connections with Power Query**\r\n\r\nCreate workbooks that automatically refresh from your data sources.\r\n\r\n```typescript\r\nimport { workbookManager } from '@microsoft/connected-workbooks';\r\n\r\n// Create a workbook that connects to your API\r\nconst blob = await workbookManager.generateSingleQueryWorkbook({\r\n queryMashup: `let \r\n Source = {1..10} \r\n in \r\n Source`,\r\n refreshOnOpen: true\r\n});\r\n\r\nworkbookManager.openInExcelWeb(blob, \"MyData.xlsx\", true);\r\n```\r\n\r\n> 📚 **Learn Power Query**: New to Power Query? Check out the [official documentation](https://docs.microsoft.com/en-us/power-query/) to unlock the full potential of live data connections.\r\n\r\n
\r\n\"Live\r\n
\r\n### 📄 **Professional Document Properties**\r\n\r\nAdd metadata and professional document properties for enterprise use.\r\n\r\n```typescript\r\nconst blob = await workbookManager.generateTableWorkbookFromHtml(\r\n document.querySelector('table') as HTMLTableElement, \r\n {\r\n docProps: { \r\n createdBy: 'John Doe',\r\n lastModifiedBy: 'Jane Doe',\r\n description: 'Sales Report Q4 2024',\r\n title: 'Quarterly Sales Data'\r\n }\r\n }\r\n);\r\n\r\n// Download for offline use\r\nworkbookManager.downloadWorkbook(blob, \"MyTable.xlsx\");\r\n```\r\n\r\n
\r\n\"Professional\r\n
\r\n\r\n## 📚 Complete API Reference\r\n\r\n### Core Functions\r\n\r\n#### 🔗 `generateSingleQueryWorkbook()`\r\nCreate Power Query connected workbooks with live data refresh capabilities.\r\n\r\n```typescript\r\nasync function generateSingleQueryWorkbook(\r\n query: QueryInfo, \r\n grid?: Grid, \r\n fileConfigs?: FileConfigs\r\n): Promise\r\n```\r\n\r\n| Parameter | Type | Required | Description |\r\n|-----------|------|----------|-------------|\r\n| `query` | [`QueryInfo`](#queryinfo) | ✅ **Required** | Power Query configuration |\r\n| `grid` | [`Grid`](#grid) | Optional | Pre-populate with data |\r\n| `fileConfigs` | [`FileConfigs`](#fileconfigs) | Optional | Customization options |\r\n\r\n#### 📋 `generateTableWorkbookFromHtml()`\r\nConvert HTML tables to Excel workbooks instantly.\r\n\r\n```typescript\r\nasync function generateTableWorkbookFromHtml(\r\n htmlTable: HTMLTableElement, \r\n fileConfigs?: FileConfigs\r\n): Promise\r\n```\r\n\r\n| Parameter | Type | Required | Description |\r\n|-----------|------|----------|-------------|\r\n| `htmlTable` | `HTMLTableElement` | ✅ **Required** | Source HTML table |\r\n| `fileConfigs` | [`FileConfigs`](#fileconfigs) | Optional | Customization options |\r\n\r\n#### 📊 `generateTableWorkbookFromGrid()`\r\nTransform raw data arrays into formatted Excel tables.\r\n\r\n```typescript\r\nasync function generateTableWorkbookFromGrid(\r\n grid: Grid, \r\n fileConfigs?: FileConfigs\r\n): Promise\r\n```\r\n\r\n| Parameter | Type | Required | Description |\r\n|-----------|------|----------|-------------|\r\n| `grid` | [`Grid`](#grid) | ✅ **Required** | Data and configuration |\r\n| `fileConfigs` | [`FileConfigs`](#fileconfigs) | Optional | Customization options |\r\n\r\n#### 🌐 `openInExcelWeb()`\r\nOpen workbooks directly in Excel for the Web.\r\n\r\n```typescript\r\nasync function openInExcelWeb(\r\n blob: Blob,\r\n filename?: string,\r\n allowEdit?: boolean\r\n): Promise\r\n```\r\n\r\n| Parameter | Type | Required | Description |\r\n|-----------|------|----------|-------------|\r\n| `blob` | `Blob` | ✅ **Required** | Generated workbook |\r\n| `filename` | `string` | Optional | Custom filename |\r\n| `allowEdit` | `boolean` | Optional | Open in edit mode with full editing capabilities (default: **true**) |\r\n\r\n#### 💾 `downloadWorkbook()`\r\nTrigger browser download of the workbook.\r\n\r\n```typescript\r\nfunction downloadWorkbook(file: Blob, filename: string): void\r\n```\r\n\r\n#### 🔗 `getExcelForWebWorkbookUrl()`\r\nGet the Excel for Web URL without opening (useful for custom integrations).\r\n\r\n```typescript\r\nasync function getExcelForWebWorkbookUrl(\r\n file: Blob,\r\n filename?: string,\r\n allowEdit?: boolean\r\n): Promise\r\n```\r\n\r\n| Parameter | Type | Required | Description |\r\n|-----------|------|----------|-------------|\r\n| `file` | `Blob` | ✅ **Required** | Generated workbook |\r\n| `filename` | `string` | Optional | Custom filename |\r\n| `allowEdit` | `boolean` | Optional | Use edit URL with full editing capabilities (default: **true**) |\r\n\r\n---\r\n\r\n## 🔧 Type Definitions\r\n\r\n### QueryInfo\r\nPower Query configuration for connected workbooks.\r\n\r\n```typescript\r\ninterface QueryInfo {\r\n queryMashup: string; // Power Query M language code\r\n refreshOnOpen: boolean; // Auto-refresh when opened\r\n queryName?: string; // Query identifier (default: \"Query1\")\r\n}\r\n```\r\n\r\n### Grid\r\nData structure for tabular information.\r\n\r\n```typescript\r\ninterface Grid {\r\n data: (string | number | boolean)[][]; // Raw data rows\r\n config?: GridConfig; // Processing options\r\n}\r\n\r\ninterface GridConfig {\r\n promoteHeaders?: boolean; // Use first row as headers\r\n adjustColumnNames?: boolean; // Fix duplicate/invalid names\r\n}\r\n```\r\n\r\n### FileConfigs\r\nAdvanced customization options.\r\n\r\n```typescript\r\ninterface FileConfigs {\r\n templateFile?: File | Buffer; // Custom Excel template\r\n docProps?: DocProps; // Document metadata\r\n hostName?: string; // Creator application name\r\n TempleteSettings?: TempleteSettings; // Template-specific settings\r\n}\r\n\r\ninterface TempleteSettings {\r\n tableName?: string; // Target table name in template\r\n sheetName?: string; // Target worksheet name\r\n}\r\n```\r\n\r\n### DocProps\r\nDocument metadata and properties.\r\n\r\n```typescript\r\ninterface DocProps {\r\n title?: string; // Document title\r\n subject?: string; // Document subject\r\n keywords?: string; // Search keywords\r\n createdBy?: string; // Author name\r\n description?: string; // Document description\r\n lastModifiedBy?: string; // Last editor\r\n category?: string; // Document category\r\n revision?: string; // Version number\r\n}\r\n```\r\n\r\n---\r\n\r\n## Contributing\r\n\r\nThis project welcomes contributions and suggestions. Most contributions require you to agree to a\r\nContributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us\r\nthe rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.\r\n\r\nWhen you submit a pull request, a CLA bot will automatically determine whether you need to provide\r\na CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions\r\nprovided by the bot. You will only need to do this once across all repos using our CLA.\r\n\r\nThis project has adopted the [Microsoft Open Source Code of Conduct](https://opensource.microsoft.com/codeofconduct/).\r\nFor more information see the [Code of Conduct FAQ](https://opensource.microsoft.com/codeofconduct/faq/) or\r\ncontact [opencode@microsoft.com](mailto:opencode@microsoft.com) with any additional questions or comments.\r\n\r\n### Getting Started\r\n1. Fork the repository\r\n2. Create a feature branch\r\n3. Make your changes\r\n4. Add tests for new functionality\r\n5. Submit a pull request\r\n\r\n### Development Setup\r\n```bash\r\ngit clone https://github.com/microsoft/connected-workbooks.git\r\ncd connected-workbooks\r\nnpm install\r\nnpm run build\r\nnpm test\r\n```\r\n---\r\n\r\n## 📄 License\r\n\r\nThis project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.\r\n\r\n## 🔗 Related Resources\r\n\r\n- [📖 Power Query Documentation](https://powerquery.microsoft.com/en-us/)\r\n- [🏢 Excel for Developers](https://docs.microsoft.com/en-us/office/dev/excel/)\r\n- [🔧 Microsoft Graph Excel APIs](https://docs.microsoft.com/en-us/graph/api/resources/excel)\r\n\r\n---\r\n\r\n## Trademarks\r\n\r\nThis project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft\r\ntrademarks or logos is subject to and must follow\r\n[Microsoft's Trademark & Brand Guidelines](https://www.microsoft.com/en-us/legal/intellectualproperty/trademarks/usage/general).\r\nUse of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship.\r\nAny use of third-party trademarks or logos are subject to those third-party's policies.\r\n\r\n---\r\n\r\n## Keywords\r\n\r\nPower Query, Excel, Office, Workbook, Refresh, Table, xlsx, export, CSV, data export, HTML table, web to Excel, JavaScript Excel, TypeScript Excel, Excel template, PivotTable, connected data, live data, data refresh, Excel for Web, browser Excel, spreadsheet, data visualization, Microsoft Office, Office 365, Excel API, workbook generation, table export, grid export, Excel automation, data processing, business intelligence\r\n","readmeFilename":"README.md"}