Adonis Spread Sheet

This is repo is a AdonisJs provider for simplicity work with sheets docs.
It's base on powerful SheetJS


Install

``
npm i --save adonis-spreadsheet
`

Registering provider

The provider is registered inside start/app.js file under providers array.

`js
const providers = [
'adonis-spreadsheet/providers/SpreadSheetProvider'
]
`

That's all! Now you can use the mail provider as follows.

Getting started

`js
const Route = use('Route')
const SpreadSheet = use('SpreadSheet')
const User = use('App/Models/User')

Route.get('/users/export/:format', async ({ request, response, params }) => {
const ss = new SpreadSheet(request, params.format)

const users = await User.all()
const data = []

data.push([
'id',
'First Name',
'Last Name',
'Email',
'Phone'
])

users.toJSON().forEach((user) => {
data.push([
user.id,
user.first_name,
user.last_name,
user.phone
])
})

ss.addSheet('Users', data)
ss.download('users-export')
})
`

Then you can fire url /rest/users/export/csv` and received csv file sheet.

Supported formats

- xls
- xlsx
- csv
- ods