(Solves the word document attached)
Reading data from an Excel sheet and writing the data to an Excel sheet.
The output sheet should have below mentioned things:
- Header should have some background color and text in header should be bold.
- Header text should be center aligned.
- If a cell contains number, it should be right aligned.
- If a cell contains text, it should be left aligned.
- Data should be in sorted order of Genre and then in descending order of Credit Score.
- Each Genre’s rows should have different background color
-> Read and write excel files using exceljs and xlsx. -> npm install exceljs, xlsx