react-excel-jspreadsheet v1.0.2

ReactExcel

Install

Using npm:

$ npm install --save  react-excel-jspreadsheet

or using yarn:

$ yarn add react-excel-jspreadsheet

功能介绍

类似Excel的React组件，基于jspreadsheet

import React from 'react'
import ReactExcel, { ReactExcelColumn } from 'react-excel-jspreadsheet'

const columns: ReactExcelColumn[] = [
  { type: 'text', title: 'Car', width: 120 },
  { type: 'dropdown', title: 'Make', width: 200, source: [ "Alfa Romeo", "Audi", "Bmw" ] },
  { type: 'calendar', title: 'Available', width: 200, options: { format:'YYYY/MM/DD' } },
  { type: 'image', title: 'Photo', width: 120 },
  { type: 'checkbox', title: 'Stock', width: 80 },
  { type: 'numeric', title: 'Price', width: 100, mask: '$ #.##,00', decimal: ',' },
  { type: 'color', width: 100, render: 'square' },
]

const data = [
  ['Jazz', 'Honda', '2019-02-12', '', true, '$ 2.000,00', '#777700'],
  ['Civic', 'Honda', '2018-07-11', '', true, '$ 4.000,01', '#007777'],
]

const Base = () => {
  return (
    <ReactExcel data={data}
      columns={columns} />
  )
}

export default Base

API

column

实例方法