AngularGenerateXLSX.ts

import { Component } from "@angular/core";

@Component({
  selector: "app-root",
  templateUrl: "./app.component.html",
  styleUrls: ["./app.component.css"]
})
export class AppComponent {
  title = "CodeSandbox";

  constructor() {
    this.base64();
  }

  base64() {
    const base64 =
      "UEsDBBQAAAgIAFhdX1UMH9+5+wAAALcBAAAPAAAAeGwvd29ya2Jvb2sueG1sjZBBbwIhEIX/Cpl7Zd1E22xEL714aUw07RlhcIkLbBjU/fmFXY2mp554M8P35sFqM7iOXTGSDV7AfFYBQ6+Ctv4k4JLM2wds1quhuYV4PoZwZvm+pyYKaFPqG85JtegkzUKPPs9MiE6mXMYTD8ZYhZ9BXRz6xOuqWvKInUx5F7W2J7i7Df9xoz6i1NQiJtdNZk5aD6/pdpHl7PglHQo4tJZ+7gNgvNwr8tvijV6h0mDGRkr7Yi4g/4FUyV7xII9jlVn+Bx5zPBXz48odhr5DYGNvqwXUwGJjs4hbnfVk9GQ1GutRl7w0JVSyU+UV+Sj8vF6814sH+Ei8/gVQSwMEFAAACAgAWF1fVfGnpqVXAQAANwMAABAAAABkb2NQcm9wcy9hcHAueG1snZNvT8IwEMa/yux76EBizLKNEDXxjboI0Zfm7G7QuLVNeyzgp7cbCANEE9/dPff07td/8XhVlUGN1kmtEjbohyxAJXQu1TxhSyp612ycxmCizGqDliS6wC9RLqopYQsiE3HuxAIrcH3vUL5YaFsB+dTOuS4KKfBWi2WFivgwDK94rkXTzb3M1gYd2/YD899+uCJUOeY9s2NkLfPEmFIKIL+39EEKq50uKLhbCSxjflRv/DNJJbqnIgNLLo1rimoUpG3wDg4b2ISVxpFlgZOfPrlkranV0gy1KTHmO+G4dJFZqehtYhH+dm1Quj6+w/HxKaxX7hGae8tA2jP0NVgJir75Rxv+rdpBedX2wy0Q6ZQA9t5uLEfpoDX44FfjptcjVJgHz6DmP2zy/IjhzyOOj+bwILzg38sUxdJKWqdha+kqjWMqoMQb/37SAkrnr/FAa9P9D0i/AFBLAwQUAAAICABYXV9VP13/aMEAAADHAQAAFAAAAHhsL3NoYXJlZFN0cmluZ3MueG1slY7BTsQwDER/pcqdpnBYQdV2kdAeOCz/YKXeTUTilNhF4e9JQHCLEJcZjZ80numYg+/eMbGLNKvbflAdkomro+usdrnc3KvjMuWRWToTd5JZPahuJ/e249NvLiXEY56VFdlGrdlYDMB93JAKu8QUQEpMV81bQljZIkrw+m4YDjqAI/X1xFWV5XmddPWq37cf8gIBW+xUenwLniG52IKhwkeL4MUaEPAfLL2JobnCmdcWo8L+UXWG3F6V/yyqxrJ8AlBLAwQUAAAICABYXV9V/05ZzDYCAABJBgAADQAAAHhsL3N0eWxlcy54bWy9VduK2zAQ/RWh966TQEsJcZZ2i2Fh2ZZuCn2V7bGtri5GGmed/frqZjubh5ZAaV40czxnNDdNdrejFOQIxnKtcrq+WVECqtI1V21OB2zefaS3+924tXgS8NQBIHEMZbdjTjvEfptltupAMnuje1DuW6ONZOhU02a2N8Bq62lSZJvV6kMmGVfUe1SDLCRaUulBobv6DCTxuK9z6uKJDu90DTmlJNvvspnsKY1Wl1485E+XF34SvFXkyEROS2ZBcAXBiUvpNcLrdQIqLbQhpi1zWhSr8EtfFJMQje+Y4KXhCW+Y5OIUv2ym2OLtSYghciHmEDd0gvzZM0QwqnAqSfLh1LtMlU6BZovxX0mtYaf15v1bXhJCJKU2tWv223JFkNSctVox8aMPZZ/UL/rFTcYqWApokIRRSAH+qWxZtPcmhrfdVcRA8Dao+2t4zjxmhKjlNcTI8EZT3tewJ05y5ct5JobKVyDEk/f4s7ko/9hczruaRde3JEZXSWF9L06PgyzBFOF1eF8R9UOxaJ8Da+GE1yAhXh6hb0YjVBjffwionxEidPUMdTDueF1DmISU9NiE4zyxKdF/kePY/Jdk2WREOm34q4vLP+YWFBgmqF+NyKuwPcKEUIIw4neNLDpxd70Y1h8cGBSuXJGiaEA4oyPcL9CvwSJvTg/M4oNbRAGzneHq+aALPtGY375f51zCprm+J2ftCO256MiME7/ccvroS+sSnsteDlwgV0mL7hdnQV3+FPa/AVBLAwQUAAAICABYXV9VYtg+fi8CAACyBQAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbI2Ub2/aMBDGv0qU9yMp0D9CQAVU1SZtomqn7bWbXIiF47POTqH99DvbUEHlVnvnuzx57neW76a3+05lL0BWop7lF4Myz0BXWEu9meW9a77d5Lfz6X6yQ9raFsBl/IO2E5rlrXNmUhS2aqETdoAGNH9rkDrhOKRNgU0jK7jDqu9Au2JYllcFgRKOi9lWGpsf3Pb/42YNgagDRKeiWSekzj1eyD6QP2LvlNTwQJntu07Q6xIU7ri3/Jh4lJvWhUQxnxZnP9eSSf1dZATNLF9cTFbjIDuo/kjY2bMo8zfzjLj1wY96lpdntuc/3Id2GK2GRvTKPeLuOxxoLk/r3AknfEC4yyiyG6Etnyaj0HDl0wufDxXZwIb8y7z0tV8CQfWuXKaUFynlKqUcnimLwHWCN/wEb3hipb8quhwmio6SeCnl+Gu80Sd4owTeMIk3ShS9TOKllFdf440/wRsn8JJ3shwnil4n8VLKmyRe8eElGpLarU0Y3axFkm+onVArHmwgiO+e94iT1Ydky0PL2ySW3ZCsf/J0xii8dyM28EvQRrKvgobBysE1DwPFuYiBQ3M8PqNz2PmIA28O3FgIGkQue9S9mz+B601mhAF6km8Qp4kp/alkCq9ZU7Cpcad/t6DX3EmecZPcSNhW/ClOLNdXotoudP23lY4t2KAmEbDzrAKlVtj5bccdatTA65QIiaNaWqPEK9QHtIh+H5hjxolnBQ+CnM0q7HW0jLvkff3O/wFQSwMEFAAACAgAWV1fVWBMh7OyBQAAuBsAABMAAAB4bC90aGVtZS90aGVtZTEueG1s7VlNjxs1GP4r1txpMvnq7qpptckmLbTbrnZDUY/OxJlx4xmPbGe3uaH2iISEKIgLEjcOCKjUSlzKr1kogiL1L/DaM5kZJzNtlm4FiM0h8cfzfr9+/ZEr1x6EDB0TISmPuo57qe4gEnl8QiO/68zV9L0t59rVK3hHBSQkCMCR3MFdJ1Aq3qnVpAfDWF7iMYlgbspFiBV0hV+bCHwCTEJWa9TrnVqIaeSgCIek69yZTqlH0EizdDLmAwZfkZJ6wGPiSLMmFoXBTmau/pEL2WcCHWPWdUDOhJ+MyAPlIIalgomuUzcfB9WuXqllVExVEBcIh+azJEwpJrOGIRT+OKN0h63ty3u5BINgah04GAz6AzfnaBDY88Badw3cGm65vYxrAZU017n36+16a4WgIKG5RrDd6/Xa2zaBQSXN1hrBVr3T2m3YBAaVNNvrNvR2+/2OTWBQSbOzRjC8vN1prRAYVMBoNFuD68jmIcowU85ulOK3AL+V5UIOqxUyLWEQqaq8C/F9LoYAMFHGikZILWIyxR7g+jgcC4qNBLxDcGEqHfPk+pgWh6QnaKy6zgcxhgWSY149//7V86fo1fMnpw+fnT786fTRo9OHP5ZR3sCRX6R8+e1nf379Mfrj6TcvH39RQSCLBL/+8MkvP39egVRF5Isvn/z27MmLrz79/bvHZfhdgcdF/IiGRKLb5AQd8lDbVyKCjMUZSUYBphYJDgBahhyowELeXmBWCuwR24d3BZSFUuT1+X1L36NAzBUtQ94MQgu5zznrcVFu000jrmDTPPIr5It5EXiI8XGp+P5KlAfzGDI7S1IbGxBL1QMGgcc+iYhCeo7PCCmju0ep5d996gku+VShexT1MC13zIiOVTnVDRpCgBa4IuqWh/bvoh5npQL2yLENhRWCWSlTwixvXsdzhcNyrXHIitBbWAWlih4thGc5XioIuk8YR4MJkbKU6I7QVudENzGUqPIM2GeL0IYKRWel0FuY8yJ0j8/6AQ7jcr1pFBTB78sZZCxGB1yV68HtNaP7EBAcVUf+LiXqjIv9Q+oH5cmiZ+ZiWdWt+hzS6HXFmlGo1hfFeqVY78IOxjYp0ZXA/2hh3sPz6IDo5L+oyxd1+aIuv2aFb1yN8wJcK56rDcOw8pA9pYwdqQUjt6Qp3RL2k8kQBk3HEGWH+jiA5lKeBfQFNm0kuPqIquAowDHIcY0IX6a8fYliLuEy4VQyN3dTCuabsXZ2oQQ4Vvt8kow3rZtmxsj0fFkU1dQsNhXXvPy24twEuaE8t10hr/16ebWCT+HMguCoA8w6cOs3ZNLDjEy091MOy+ice6RkgCckDZVbbovb3NR3+sq4ubzt5tvK2yRWRYGtKoHt8whWfT1YtfXVySK7h05AsXaj7SAPx11nCgcvaIYxMJR6F8fMhzcmT6XWvHFtr9pckaBuvdpmS0gspNrDMkjIzFT2KBPlJjTa4NzzsqGsPm2oR3PL/Uf1qK1GmEynxFMVI3k3neNzRcRRMDlBYzYXhxg010kLFk2ohK2ksezAm5v2uOnZdSBdD6tPP+k6wSwOcFqj9HLNbEzwpp0pYXoF/WoVyv9NW5rnaIuVzf83W3T6wrNDc2IezeB8IDDSedp1uFABh3oUB9QbCjhRGGGgGDzdwjSIYfoJWytLjgslLGGSFDw/UIfUR4JC1VOBIORApZa+gZu7rJDp8kg5pRUnU1jGye+YHBM20ou4o13goCArK6kvDHA1cHY/9cfYH/6bT0Vp7pz52JCLSjhsKq64CRT2hu231eKMG3BavdYENtqbb8AxvCAh/QWFnAqP5WfgET+ELED5oRNS8r3kSIL0skxaY9A6HUzEaV7v9oyVByIX/C6PpwWPN6s8Xtefd+HxtGU53MqnEn9DZ3XB6pPT8spjemt/d/HxfRC+B3eqOVMy/RPhAbwagh0JHTBKZRriq38BUEsDBBQAAAgAAFldX1VOTjEU2gEAANoBAABRAAAAcGFja2FnZS9zZXJ2aWNlcy9tZXRhZGF0YS9jb3JlLXByb3BlcnRpZXMvYmFhYzliMGE1NjM5NGVlYmI4ZDgxN2I0OTgyMjFkODgucHNtZGNw77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz48Y29yZVByb3BlcnRpZXMgeG1sbnM6ZGM9Imh0dHA6Ly9wdXJsLm9yZy9kYy9lbGVtZW50cy8xLjEvIiB4bWxuczpkY3Rlcm1zPSJodHRwOi8vcHVybC5vcmcvZGMvdGVybXMvIiB4bWxuczp4c2k9Imh0dHA6Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hLWluc3RhbmNlIiB4bWxucz0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL3BhY2thZ2UvMjAwNi9tZXRhZGF0YS9jb3JlLXByb3BlcnRpZXMiPjxkY3Rlcm1zOmNyZWF0ZWQgeHNpOnR5cGU9ImRjdGVybXM6VzNDRFRGIj4yMDIyLTEwLTMxVDE2OjQyOjUwLjM0ODM4MjdaPC9kY3Rlcm1zOmNyZWF0ZWQ+PGRjdGVybXM6bW9kaWZpZWQgeHNpOnR5cGU9ImRjdGVybXM6VzNDRFRGIj4yMDIyLTEwLTMxVDE2OjQyOjUwLjM0ODM4MzVaPC9kY3Rlcm1zOm1vZGlmaWVkPjwvY29yZVByb3BlcnRpZXM+UEsDBBQAAAgAAFldX1XXEdqCnAIAAJwCAAALAAAAX3JlbHMvLnJlbHPvu788P3htbCB2ZXJzaW9uPSIxLjAiIGVuY29kaW5nPSJ1dGYtOCI/PjxSZWxhdGlvbnNoaXBzIHhtbG5zPSJodHRwOi8vc2NoZW1hcy5vcGVueG1sZm9ybWF0cy5vcmcvcGFja2FnZS8yMDA2L3JlbGF0aW9uc2hpcHMiPjxSZWxhdGlvbnNoaXAgVHlwZT0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL29mZmljZURvY3VtZW50LzIwMDYvcmVsYXRpb25zaGlwcy9vZmZpY2VEb2N1bWVudCIgVGFyZ2V0PSIveGwvd29ya2Jvb2sueG1sIiBJZD0iUmRmMTA1OTFhNThlNzRjM2IiIC8+PFJlbGF0aW9uc2hpcCBUeXBlPSJodHRwOi8vc2NoZW1hcy5vcGVueG1sZm9ybWF0cy5vcmcvb2ZmaWNlRG9jdW1lbnQvMjAwNi9yZWxhdGlvbnNoaXBzL2V4dGVuZGVkLXByb3BlcnRpZXMiIFRhcmdldD0iL2RvY1Byb3BzL2FwcC54bWwiIElkPSJySWQxIiAvPjxSZWxhdGlvbnNoaXAgVHlwZT0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL3BhY2thZ2UvMjAwNi9yZWxhdGlvbnNoaXBzL21ldGFkYXRhL2NvcmUtcHJvcGVydGllcyIgVGFyZ2V0PSIvcGFja2FnZS9zZXJ2aWNlcy9tZXRhZGF0YS9jb3JlLXByb3BlcnRpZXMvYmFhYzliMGE1NjM5NGVlYmI4ZDgxN2I0OTgyMjFkODgucHNtZGNwIiBJZD0iUmI1MzA2OWI0MzQ0ZTRhNmYiIC8+PC9SZWxhdGlvbnNoaXBzPlBLAwQUAAAICABZXV9VDNxIs+MAAAC+AgAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxztZJBTsMwEEWvYs2eTFpQhVDdbrrptvQCljOJoya25ZnS9mwsOBJXwAQJYcSCTTa2/Mfz9Mby++vbensdB/VCifvgNSyqGhR5G5redxrO0t49wnazPtBgJN9g10dWucWzBicSnxDZOhoNVyGSz5U2pNFIPqYOo7En0xEu63qF6ScDSqY63iL9hxjatre0C/Y8kpc/wMjOJGqeJeUJGNTRpI5EA16HslRlMqh9oyHtm3tQOJ+R3Ab6rTJlhcPDnA6XkE7siKTU+I4/3y1vi8JoOaeR5F4qbaboay1FVpMIFr9w8wFQSwMEFAAACAgAWV1fVVo7UkA8AQAANwQAABMAAABbQ29udGVudF9UeXBlc10ueG1srZRNTsMwEIWvEnmLYrcsEEJNuwC2UAkuYNmTxKr/5JmW9mwsOBJXYJqiglBFBe3GljMz73se23l/fZvM1sFXKyjoUmzEWI5EBdEk62LXiCW19bWYTSfPmwxYcWrERvRE+UYpND0EjTJliBxpUwmaeFk6lbVZ6A7U5Wh0pUyKBJFq2mqI6eQOWr30VN2v+fMOy+Wiut3lbVGN0Dl7ZzRxWK2i/QGpU9s6AzaZZeASibmAttgDUPBymGXQLl4MwuogM2OwJv8N+7kvaVKBOheOFnKAv2EKePwfhCuHHOxd/kI88lkVZ6Ga60IPOrCe4j7M2QwqVpan9hK23i3YQ/s7BF97hb0uYJ+o8KVBee7D/KZ91AhtPJzdwSB6DP2SymKoQG4HT+Mzu9jrHzNC/CphN57uYZDZE9XwG5h+AFBLAQIUABQAAAgIAFhdX1UMH9+5+wAAALcBAAAPAAAAAAAAAAAAAAAAAAAAAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAICABYXV9V8aempVcBAAA3AwAAEAAAAAAAAAAAAAAAAAAoAQAAZG9jUHJvcHMvYXBwLnhtbFBLAQIUABQAAAgIAFhdX1U/Xf9owQAAAMcBAAAUAAAAAAAAAAAAAAAAAK0CAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQIUABQAAAgIAFhdX1X/TlnMNgIAAEkGAAANAAAAAAAAAAAAAAAAAKADAAB4bC9zdHlsZXMueG1sUEsBAhQAFAAACAgAWF1fVWLYPn4vAgAAsgUAABgAAAAAAAAAAAAAAAAAAQYAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLAQIUABQAAAgIAFldX1VgTIezsgUAALgbAAATAAAAAAAAAAAAAAAAAGYIAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAhQAFAAACAAAWV1fVU5OMRTaAQAA2gEAAFEAAAAAAAAAAAAAAAAASQ4AAHBhY2thZ2Uvc2VydmljZXMvbWV0YWRhdGEvY29yZS1wcm9wZXJ0aWVzL2JhYWM5YjBhNTYzOTRlZWJiOGQ4MTdiNDk4MjIxZDg4LnBzbWRjcFBLAQIUABQAAAgAAFldX1XXEdqCnAIAAJwCAAALAAAAAAAAAAAAAAAAAJIQAABfcmVscy8ucmVsc1BLAQIUABQAAAgIAFldX1UM3Eiz4wAAAL4CAAAaAAAAAAAAAAAAAAAAAFcTAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQIUABQAAAgIAFldX1VaO1JAPAEAADcEAAATAAAAAAAAAAAAAAAAAHIUAABbQ29udGVudF9UeXBlc10ueG1sUEsFBgAAAAAKAAoAwAIAAN8VAAAAAA==";
    const name = "name.xlsx";
    const blob = this.dataURItoBlob(base64);
    const file = new File([blob], name, {
      type:
        "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,"
    });

    const link = document.createElement("a");
    link.href = window.URL.createObjectURL(file);
    link.download = `report_${new Date().getTime()}.xlsx`;
    link.click();

    console.log(file);
  }

  dataURItoBlob(dataURI) {
    const byteString = window.atob(dataURI);
    const arrayBuffer = new ArrayBuffer(byteString.length);
    const int8Array = new Uint8Array(arrayBuffer);
    for (let i = 0; i < byteString.length; i++) {
      int8Array[i] = byteString.charCodeAt(i);
    }
    const blob = new Blob([int8Array], { type: "" });
    return blob;
  }
}