# excel-reader

> This is an angular module compatible with angular 6+ versions. It reads excel files, validate it, and show it in a tabular format.

Latest version **1.0.8** (published 2019-04-19) · 0 weekly downloads

## Install

```sh
npm install excel-reader
pnpm add excel-reader
yarn add excel-reader
bun add excel-reader
```

## Health

**Score 25/100 (F)** — status: abandoned.

Positive: has types; esm support; no vulnerabilities.

Warnings: low downloads.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.8 |
| Published | 2019-04-19 |
| First published | 2019-03-11 |
| Weekly downloads | 0 |
| TypeScript types | bundled |
| Module format | ESM + CommonJS |
| Dependencies | 1 |
| Unpacked size | 225.2 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Maintainers | gohainraj |

## Links

- npm: https://www.npmjs.com/package/excel-reader
- npm.io page: https://npm.io/package/excel-reader

## Dependencies (1)

- [tslib](https://npm.io/package/tslib.md) ^1.9.0

## Recent versions

- 1.0.8 (latest) — 2019-04-19
- 1.0.7 — 2019-04-19
- 1.0.6 — 2019-04-19
- 1.0.5 — 2019-04-19
- 1.0.4 — 2019-04-19
- 1.0.3 — 2019-04-19
- 1.0.2 — 2019-04-19
- 1.0.1 — 2019-04-02
- 1.0.0 — 2019-04-02
- 0.0.6 — 2019-04-01
- 0.0.5 — 2019-04-01
- 0.0.4 — 2019-03-12
- 0.0.3 — 2019-03-11
- 0.0.2 — 2019-03-11
- 0.0.1 — 2019-03-11

## README

#Excel-reader
This is an angular module compatible with angular 6+ versions. It reads excel files, validate it, and show it in a tabular format.

#DEMO
[https://stackblitz.com/edit/angular-5dwch5](https://stackblitz.com/edit/angular-5dwch5)

##Dependencies
1."xlsx":0.10.0<br/>
2."material-design-lite":^1.3.0

##Installation
Run the command `npm i excel-reader`
In your `app.module.ts` import the module as
`import {ExcelReaderModule} from "excel-reader"`
Add the module to the import section
```
imports: [
    BrowserModule,
    ExcelReaderModule
    .....
    
  ],
```
In your `app.html` put the code given below
```
<lib-excel-reader [xlConfig]="configXl"></lib-excel-reader>
```
Finally in your `app.component.ts` file add the configuration you want
```
this.configXl =
  {
    startingRow: 0,
    validation: [{
      fieldName: "work email",
      validationType: "email"
    },
    {
      fieldName: "personal email",
      validationType: "email"
    },
    {
      fieldName: "home phone",
      validationType: "number",
      length: 10
    }],
    showAll: true
  };
```
##Configuration Properties
 * **startingRow** holds the row number from which your excel sheet starts ( Not the headers and all)
 * **fieldName** is the name the header field in your excel sheet you want to validate
 * **validationType** is the type of validation you want to apply in the particular field of your excel-sheet
 * if **showAll** is set to true it will display all the data in the excel sheet otherwise it will only show the rows having errors.
Thats all, now you can run your application and test it.

---
_Source: https://npm.io/package/excel-reader · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._