Posts

Generating Excel File in Angular 9 using “ExcelJs” with Custom Font Family | Devstringx

Image
  Creating A New Angular Project Let’s create a new Angular project using the Angular CLI tool by running/executing the following angular CLI command ng new export-to-excel Would you like to add Angular routing? Yes Which stylesheet format would you like to use? SCSS What’s ExcelJS? ExcelJS  is the Javascript library used to read, write and manipulate the excel spreadsheet data and styles to JSON and XLSX. We can create XLSX files easily with formatted headers, footers, and cells, and input any custom data including text, images, etc. It’s an active and community-driven library with many features. Features of ExcelJS Here are some of the awesome features of Excel JS:- View, Add, Remove, Access Worksheets, and also set the Worksheet States like hidden, visible, and veryHidden. Page setup of a worksheet includes orientation, margins, height, width, and print area. Headers and Footers configuration of the worksheet with custom style, font, color, etc. Worksheet Views to Freeze & Split