table2excel

text and image save to excel

Installation

npm install js-table2excel

Usage

import table2excel from 'js-table2excel'

const column = [
  {
    title: '宠物',
    key: 'name',
  },
  {
    title: '图例',
    key: 'pic',
    type: 'image',
  }
]

const data = [
  {
    name: 'dog',
    pic: 'https://t7.baidu.com/it/u=848096684,3883475370&fm=193&f=GIF',
    size: [100, 60], // image size for picture
  },
  {
    name: 'cat',
    pic: 'https://t7.baidu.com/it/u=2272690563,768132477&fm=193&f=GIF',
  }
]

const excelName = '爱宠'

const captionName = '爱宠一览图'

table2excel({
    column,
    data,
    excelName,
    captionName: '爱宠列表',
})
// you can also use
// table2excel(column, data, excelName, captionName)

table2excel options

	type	default
column	Array	[]
data	Array	[]
excelName	String	-
captionName	String	-

column options

	introduction	type	default
title	name for column	String	-
key	key for column	String	-
type	text|image	String	text