exceljs-export

Exceljs-export

Exceljs-export is a library to export data to an automatically generated excel with only sending 3 parameters

Installation

To install, you can use npm

$ npm install exceljs-export

Usage

//sent data from local
import SaveExcel from 'exceljs-export'
const titlesProps =['n1', 'n2', 'n3'];
const dataProps =[[1,2,3],[4,5,6]];
SaveExcel({ data: dataProps, documentName: 'exportacionExcel', titles:titlesProps });

//sent data from endpoint
import SaveExcel from 'exceljs-export'
import axios from 'axios'

const exportUsers = () => {
    const users = async () => {
      const res = await axios.get('https://jsonplaceholder.typicode.com/todos?_limit=10') 
      return res.data.map(item => Object.values(item))
    }
    users().then(res=>SaveExcel({ data: res, documentName: 'prueba', titles: ['User ID', 'ID', 'Title','Completado'] }))
}

exportUsers();

Examples

Data exported from endpoint

Data exported from local

Props

Properties required by the library, data type, definition and examples.

Name	Type	Description	Examples
titles	Array of number or string	Title of the columns to show in the excel document	['User ID', 'ID', 'Title','Completado']
data	Array of Arrays of number or string	Data to export to excel document	[[1,2,3],[4,5,6]]
documentName	String	This is the name of the document	'testDocument'

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

Created by Rafael Martinez