Skip to content

README.md

Latest commit

 

History

History
26 lines (16 loc) · 872 Bytes

README.md

File metadata and controls

26 lines (16 loc) · 872 Bytes
Raw

ng-xls-chartjs

About

NodeJS application to render data arranged in sheets in XLS file as line or bar chart using ChartJS

Usage

Important Use npm install --legacy-peer-deps to avoid peer dependency issue with NPM >= 7.

ng serve -o - Starts the user interface in your browser.

  1. Browse and upload a sample data file (i.e. ./data/sample.xlsx)
  2. Click Plot button to render graphs

Data format

Will render data from XLSX workbooks with sheets named CamelPrefix_LineChart or CamelPrefix_BarChart, other tabs will be ignored.

Sample data

  • ./data/sample.xlsx - Two sheets correctly formatted, will not return errors.
  • ./data/sample_corrupt.xlsx - Several correct sheets, corrupt sheets as follows:
    • Incorrect hoursEndings X column label (suffix s added)
    • Missing Y data columns
    • Incorrect sheet suffix (_linchart)