Exceljs-export NPM

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

sent data from endpoint

Data exported from local

sent data 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'