Breaking News: Grepper is joining You.com. Read the official announcement!

export data to excel using react js

Dead Dormouse answered on October 10, 2020 Popularity 10/10 Helpfulness 4/10

answer export data to excel using react js

export data to excel using react js

Comment

import React from 'react'
import * as FileSaver from "file-saver";
import * as XLSX from "xlsx";
import { Button } from 'antd';
import { FileExcelOutlined } from '@ant-design/icons';

export const ExportToExcel = ({ apiData, fileName }) => {
  const fileType =
    "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8";
  const fileExtension = ".xlsx";

  const exportToCSV = (apiData, fileName) => {
    const ws = XLSX.utils.json_to_sheet(apiData);
    const wb = { Sheets: { data: ws }, SheetNames: ["data"] };
    const excelBuffer = XLSX.write(wb, { bookType: "xlsx", type: "array" });
    const data = new Blob([excelBuffer], { type: fileType });
    FileSaver.saveAs(data, fileName + fileExtension);
  };

  return (
    <Button icon={<FileExcelOutlined />} type='primary' onClick={(e) => exportToCSV(apiData, fileName)}>Exporter</Button>
  );
};

Popularity 10/10 Helpfulness 4/10 Language javascript

Source: Grepper

Tags: excel export javascript using

Link to this answer
Share Copy Link

Contributed on Apr 18 2022

Dead Dormouse

0 Answers Avg Quality 2/10

Closely Related Answers

read and save excel with react

Comment

import readXlsxFile from 'read-excel-file'
const input = document.getElementById('input') 
input.addEventListener('change', () => { 
  readXlsxFile(input.files[0]).then((rows) => { 
    // `rows` is an array of rows    // each row being an array of cells. 
  })})

Popularity 10/10 Helpfulness 2/10 Language javascript

Source: www.npmjs.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Oct 10 2020

Jittery Jellyfish

0 Answers Avg Quality 2/10

read and save excel with react

Comment

import readXlsxFile from 'read-excel-file' const input = document.getElementById('input') input.addEventListener('change', () => {  readXlsxFile(input.files[0]).then((rows) => {    // `rows` is an array of rows    // each row being an array of cells.  })})

Popularity 10/10 Helpfulness 2/10 Language javascript

Source: www.npmjs.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Oct 10 2020

Jittery Jellyfish

0 Answers Avg Quality 2/10

export data to excel using react js

Contents

More Related Answers

export data to excel using react js

Closely Related Answers

read and save excel with react

read and save excel with react

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.