jsonToExcel 生成excel文件下载

horizon_zpy

已于 2022-09-23 09:13:45 修改

阅读量287

点赞数

分类专栏：笔记文章标签： javascript json 前端

于 2022-09-23 09:11:37 首次发布

本文链接：https://blog.csdn.net/horizon_zpy/article/details/127003945

版权

JSON Excel HTML表格数据转换文件下载

关键词由CSDN通过智能技术生成

笔记专栏收录该内容

24 篇文章 0 订阅

订阅专栏

function ToExcel(JSONData, FileName, ShowLabel) {
// 先转化json
var arrData = JSONData

var excel = '<table>'

// 设置表头
var row = '<tr>'
for (var i = 0, l = ShowLabel.length; i < l; i++) {
    if (typeof ShowLabel[i] === 'object') {
        row += `<th ${ShowLabel[i].width ? `width=${ShowLabel[i].width}` : ''}>` + ShowLabel[i].value + '</th>'
    } else {
        row += '<th>' + ShowLabel[i] + '</th>'
    }
    
}
// 换行
excel += row + '</tr>'

// 设置数据
for (var i = 0; i < arrData.length; i++) {
    var row = '<tr>'
    let labelIndex = 0
    for (var index in arrData[i]) {
        var value = arrData[i][index] === '.' ? '' : arrData[i][index]
        if (typeof value === 'object') {
            row += `<td style="text-align:center;background-color:${value.backgroundColor};color:${value.color}" ${value.rowspan ? `rowspan=${value.rowspan}` : ''} ${value.colspan ? `colspan=${value.colspan}` : ''} ${value.width ? `width=${value.width}` : ''} >` + value.value + '</td>'
        } else {
            row += `<td style="text-align:center">` + value + '</td>'
        }
        labelIndex++
    }
    excel += row + '</tr>'
}

excel += '</table>'

var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>"
excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">'
excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel'
excelFile += '; charset=UTF-8">'
excelFile += '<head>'
excelFile += '<!--[if gte mso 9]>'
excelFile += '<xml>'
excelFile += '<x:ExcelWorkbook>'
excelFile += '<x:ExcelWorksheets>'
excelFile += '<x:ExcelWorksheet>'
excelFile += '<x:Name>'
excelFile += '{worksheet}'
excelFile += '</x:Name>'
excelFile += '<x:WorksheetOptions>'
excelFile += '<x:DisplayGridlines/>'
excelFile += '</x:WorksheetOptions>'
excelFile += '</x:ExcelWorksheet>'
excelFile += '</x:ExcelWorksheets>'
excelFile += '</x:ExcelWorkbook>'
excelFile += '</xml>'
excelFile += '<![endif]-->'
excelFile += '</head>'
excelFile += '<body>'
excelFile += excel
excelFile += '</body>'
excelFile += '</html>'

var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile)

var link = document.createElement('a')
link.href = uri

link.style = 'visibility:hidden'
link.download = FileName + '.xls'

document.body.appendChild(link)
link.click()
document.body.removeChild(link)

}