前端 js处理table数据转化为导出Excel文件

最新推荐文章于 2024-10-08 11:19:12 发布
最新推荐文章于 2024-10-08 11:19:12 发布
阅读量907 收藏
点赞数
文章标签： 前端 javascript excel
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wmw_wmw/article/details/128952408
版权

新建Export2Excel.js

require('script-loader!file-saver') //保存文件用
require('script-loader!@/vendor/Blob') //转二进制用
require('script-loader!xlsx/dist/xlsx.core.min') //xlsx核心
require('script-loader!xlsx-style/dist/xlsx.full.min')
function generateArray(table) {
  var out = []
  var rows = table.querySelectorAll('tr')
  var ranges = []
  for (var R = 0; R < rows.length; ++R) {
    var outRow = []
    var row = rows[R]
    var columns = row.querySelectorAll('td')
    for (var C = 0; C < columns.length; ++C) {
      var cell = columns[C]
      var colspan = cell.getAttribute('colspan')
      var rowspan = cell.getAttribute('rowspan')
      var cellValue = cell.innerText
      if (cellValue !== '' && cellValue == +cellValue) cellValue = +cellValue

      //Skip ranges
      ranges.forEach(function (range) {
        if (R >= range.s.r && R <= range.e.r && outRow.length >= range.s.c && outRow.length <= range.e.c) {
          for (var i = 0; i <= range.e.c - range.s.c; ++i) outRow.push(null)
        }
      })

      //Handle Row Span
      if (rowspan || colspan) {
        rowspan = rowspan || 1
        colspan = colspan || 1
        ranges.push({ s: { r: R, c: outRow.length }, e: { r: R + rowspan - 1, c: outRow.length + colspan - 1 } })
      }
      //Handle Value
      outRow.push(cellValue !== '' ? cellValue : null)

      //Handle Colspan
      if (colspan) for (var k = 0; k < colspan - 1; ++k) outRow.push(null)
    }
    out.push(outRow)
  }
  return [out, ranges]
}

function datenum(v, date1904) {
  if (date1904) v += 1462
  var epoch = Date.parse(v)
  return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000)
}
//通用的数据和格式 (表头合并)
function sheet_from_array_of_arrays_mergeheader(data, ArrMerge) {
  var ws = { s: { '!row': [{ wpx: 67 }] } }
  ws['!cols'] = []
  var range = { s: { c: 10000000, r: 10000000 }, e: { c: 0, r: 0 } } //c是列-1  r是内容行
  for (var R = 0; R != data.length; ++R) {
    for (var C = 0; C != data[R].length; ++C) {
      if (range.s.r > R) range.s.r = R
      if (range.s.c > C) range.s.c = C
      if (range.e.r < R) range.e.r = R
      if (range.e.c < C) range.e.c = C
      var cell = { v: data[R][C], s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '13' } } }
      if (R == 0) {
        cell = {
          v: data[R],
          s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
        }
      }
      if (R == 1) {
        ws['!cols'].push({ wpx: 120 })
        cell = {
          v: data[R][C],
          s: { alignment: { horizontal: 'center', vertical: 'center', wrapText: true }, font: { sz: '16', bold: true } }
        }
      }
      if (R == data.length - 1) {
        if (data[R][1] == '合计')
          cell = {
            v: data[R][C],
            s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
          }
      }
      if (cell.v == null) continue
      var cell_ref = XLSX.utils.encode_cell({ c: C, r: R })
      if (typeof cell.v === 'number') cell.t = 'n'
      else if (typeof cell.v === 'boolean') cell.t = 'b'
      else if (cell.v instanceof Date) {
        cell.t = 'n'
        cell.z = XLSX.SSF._table[14]
        cell.v = datenum(cell.v)
      } else cell.t = 's'
      ws[cell_ref] = cell
    }
  }
  ws['!merges'] = ArrMerge
  if (range.s.c < 10000000) ws['!ref'] = XLSX.utils.encode_range(range)
  return ws
}

//通用的数据和格式
function sheet_from_array_of_arrays(data, colNum) {
  var ws = { s: { '!row': [{ wpx: 67 }] } }
  ws['!cols'] = []
  var range = { s: { c: 10000000, r: 10000000 }, e: { c: 0, r: 0 } } //c是列-1  r是内容行
  for (var R = 0; R != data.length; ++R) {
    for (var C = 0; C != data[R].length; ++C) {
      if (range.s.r > R) range.s.r = R
      if (range.s.c > C) range.s.c = C
      if (range.e.r < R) range.e.r = R
      if (range.e.c < C) range.e.c = C
      var cell = { v: data[R][C], s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '13' } } }
      if (R == 0) {
        cell = {
          v: data[R],
          s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
        }
      }
      if (R == 1) {
        ws['!cols'].push({ wpx: 120 })
        cell = {
          v: data[R][C],
          s: { alignment: { horizontal: 'center', vertical: 'center', wrapText: true }, font: { sz: '16', bold: true } }
        }
      }
      if (R == data.length - 1) {
        if (data[R][1] == '合计')
          cell = {
            v: data[R][C],
            s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
          }
      }
      if (cell.v == null) continue
      var cell_ref = XLSX.utils.encode_cell({ c: C, r: R })
      if (typeof cell.v === 'number') cell.t = 'n'
      else if (typeof cell.v === 'boolean') cell.t = 'b'
      else if (cell.v instanceof Date) {
        cell.t = 'n'
        cell.z = XLSX.SSF._table[14]
        cell.v = datenum(cell.v)
      } else cell.t = 's'
      ws[cell_ref] = cell
    }
  }
  ws['!merges'] = [{ s: { c: 0, r: 0 }, e: { c: range.e.c, r: 0 } }]
  if (range.s.c < 10000000) ws['!ref'] = XLSX.utils.encode_range(range)
  return ws
}
//个性化数据和格式（1）
function sheet_from_array_of_arrays_jmmxb(data, colNum) {
  var ws = { s: { '!row': [{ wpx: 67 }] } }
  ws['!cols'] = []
  var range = { s: { c: 10000000, r: 10000000 }, e: { c: 0, r: 0 } } //c是列-1  r是内容行
  for (var R = 0; R != data.length; ++R) {
    for (var C = 0; C != data[R].length; ++C) {
      if (range.s.r > R) range.s.r = R
      if (range.s.c > C) range.s.c = C
      if (range.e.r < R) range.e.r = R
      if (range.e.c < C) range.e.c = C
      var cell = { v: data[R][C], s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '13' } } }
      if (R == 0) {
        cell = {
          v: data[R],
          s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
        }
      }
      if (R == 1) {
        cell = { v: data[R], s: { alignment: { horizontal: 'left', vertical: 'left' }, font: { sz: '13' } } }
      }
      if (R == 2) {
        ws['!cols'].push({ wpx: 120 })
        cell = {
          v: data[R][C],
          s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
        }
      }
      if (R == data.length - 1) {
        if (data[R][1] == '合计')
          cell = {
            v: data[R][C],
            s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
          }
      }
      if (cell.v == null) continue
      var cell_ref = XLSX.utils.encode_cell({ c: C, r: R })
      if (typeof cell.v === 'number') cell.t = 'n'
      else if (typeof cell.v === 'boolean') cell.t = 'b'
      else if (cell.v instanceof Date) {
        cell.t = 'n'
        cell.z = XLSX.SSF._table[14]
        cell.v = datenum(cell.v)
      } else cell.t = 's'
      ws[cell_ref] = cell
    }
  }
  ws['!merges'] = [
    { s: { c: 0, r: 0 }, e: { c: range.e.c, r: 0 } },
    { s: { c: 0, r: 1 }, e: { c: range.e.c, r: 1 } }
  ]
  if (range.s.c < 10000000) ws['!ref'] = XLSX.utils.encode_range(range)
  return ws
}
//个性化数据和格式（2）
function sheet_from_array_of_arrays_hmzcjm(data) {
  var ws = { s: { '!row': [{ wpx: 67 }] } }
  ws['!cols'] = []
  var range = { s: { c: 10000000, r: 10000000 }, e: { c: 0, r: 0 } }
  var n = 0
  for (var R = 0; R != data.length; ++R) {
    for (var C = 0; C != data[R].length; ++C) {
      if (range.s.r > R) range.s.r = R
      if (range.s.c > C) range.s.c = C
      if (range.e.r < R) range.e.r = R
      if (range.e.c < C) range.e.c = C
      var cell = { v: data[R][C], s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '13' } } }
      if (R == 0) {
        ws['!cols'].push({ wpx: 140 })
        cell = {
          v: data[R][C],
          s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '16', bold: true } }
        }
      }
      if (R == data.length - 1) {
        cell = {
          v: '备注：' + data[R][C],
          s: { alignment: { horizontal: 'center', vertical: 'center' }, font: { sz: '14' } }
        }
      }
      if (cell.v == null) continue
      var cell_ref = XLSX.utils.encode_cell({ c: C, r: R })
      if (typeof cell.v === 'number') cell.t = 'n'
      else if (typeof cell.v === 'boolean') cell.t = 'b'
      else if (cell.v instanceof Date) {
        cell.t = 'n'
        cell.z = XLSX.SSF._table[14]
        cell.v = datenum(cell.v)
      } else cell.t = 's'
      ws[cell_ref] = cell
    }
  }
  // ec控制横向几格。sr控制竖向几格
  ws['!merges'] = [
    { s: { c: 0, r: 0 }, e: { c: 3, r: 0 } },
    { s: { c: 0, r: 1 }, e: { c: 0, r: 1 } },
    { s: { c: 0, r: 2 }, e: { c: 0, r: 4 } },
    { s: { c: 0, r: 5 }, e: { c: 0, r: 7 } },
    { s: { c: 0, r: 8 }, e: { c: 0, r: 10 } },
    { s: { c: 0, r: 11 }, e: { c: 0, r: 13 } },
    { s: { c: 0, r: 14 }, e: { c: 0, r: 16 } },
    { s: { c: 0, r: 17 }, e: { c: 0, r: 19 } },
    { s: { c: 0, r: 20 }, e: { c: 0, r: 22 } },
    { s: { c: 0, r: 23 }, e: { c: 0, r: 25 } },
    { s: { c: 0, r: 26 }, e: { c: 3, r: 26 } }
  ]
  if (range.s.c < 10000000) ws['!ref'] = XLSX.utils.encode_range(range)
  return ws
}

function Workbook() {
  if (!(this instanceof Workbook)) return new Workbook()
  this.SheetNames = []
  this.Sheets = {}
}

function s2ab(s) {
  var buf = new ArrayBuffer(s.length)
  var view = new Uint8Array(buf)
  for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xff
  return buf
}

export function export_table_to_excel(id) {
  var theTable = document.getElementById(id)
  var oo = generateArray(theTable)
  var ranges = oo[1]

  /* original data */
  var data = oo[0]
  var ws_name = 'SheetJS'

  var wb = new Workbook(),
    ws = sheet_from_array_of_arrays(data)

  /* add ranges to worksheet */
  // ws['!cols'] = ['apple', 'banan'];
  ws['!merges'] = ranges

  /* add worksheet to workbook */
  wb.SheetNames.push(ws_name)
  wb.Sheets[ws_name] = ws

  var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: false, type: 'binary' })

  saveAs(new Blob([s2ab(wbout)], { type: 'application/octet-stream' }), 'test.xlsx')
}

function formatJson(jsonData) {
  // console.log(jsonData)
}
//2003excel
export function export_json_to_excelFapiao(headerList, dataList, defaultTitle, colNum, div) {
  /* original data */
  var filterVal = []
  var tHeader = []
  for (var i = 0; i < headerList.length; i++) {
    if (headerList[i].ColumnKey === '') {
      /* 处理二级列项 */
      for (var j = 0; j < headerList[i].ColumnChild.length; j++) {
        tHeader = Boolean(headerList[i].ColumnName.replace(/\s/g, ''))
          ? tHeader.concat(`${headerList[i].ColumnName}(${headerList[i].ColumnChild[j].ColumnName})`)
          : tHeader.concat(headerList[i].ColumnChild[j].ColumnName)
        filterVal = filterVal.concat(headerList[i].ColumnChild[j].ColumnKey)
      }
      /* 处理一级列项 */
    } else {
      tHeader = tHeader.concat(headerList[i].ColumnName)
      filterVal = filterVal.concat(headerList[i].ColumnKey)
    }
  }
  // console.log("dataList",dataList)
  var data = dataList.map(v => filterVal.map(j => v[j]))
  data.unshift(tHeader)
  data.unshift([defaultTitle])
  if (colNum === undefined) colNum = 1
  var ws_name = 'SheetJS'
  var wb = new Workbook(),
    ws
  if (div === undefined) {
    ws = sheet_from_array_of_arrays(data, colNum)
  } else if (div === 'hmzcjm') {
    ws = sheet_from_array_of_arrays_hmzcjm(data)
  } else if (div === 'jmmxb') {
    var name = localStorage.username
    var zbdw = localStorage.orgname
    data.splice(1, 0, ['制表单位:' + zbdw + '          ' + '制表人：' + name])
    ws = sheet_from_array_of_arrays_jmmxb(data)
  }
  /* add worksheet to workbook */
  wb.SheetNames.push(ws_name)
  wb.Sheets[ws_name] = ws
  var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: false, type: 'binary' })

  var title = defaultTitle || '列表'
  saveAs(new Blob([s2ab(wbout)], { type: 'application/octet-stream' }), title + '.xls')
}
export function export_json_to_excel(headerList, dataList, defaultTitle, colNum, div) {
  /* original data */
  var filterVal = []
  var tHeader = []
  for (var i = 0; i < headerList.length; i++) {
    if (!headerList[i].ColumnKey) {
      /* 处理二级列项 */
      for (var j = 0; j < headerList[i].ColumnChild.length; j++) {
        tHeader = Boolean(headerList[i].ColumnName.replace(/\s/g, ''))
          ? tHeader.concat(`${headerList[i].ColumnName}(${headerList[i].ColumnChild[j].ColumnName})`)
          : tHeader.concat(headerList[i].ColumnChild[j].ColumnName)
        filterVal = filterVal.concat(headerList[i].ColumnChild[j].ColumnKey)
      }
    } else {
      /* 处理一级列项 */
      tHeader = tHeader.concat(headerList[i].ColumnName)
      filterVal = filterVal.concat(headerList[i].ColumnKey)
    }
  }
  // console.log("dataList",dataList)
  var data = dataList.map(v => filterVal.map(j => v[j]))
  data.unshift(tHeader)
  data.unshift([defaultTitle])
  if (colNum === undefined) colNum = 1
  var ws_name = 'SheetJS'
  var wb = new Workbook(),
    ws
  if (div === undefined) {
    ws = sheet_from_array_of_arrays(data, colNum)
  } else if (div === 'hmzcjm') {
    ws = sheet_from_array_of_arrays_hmzcjm(data)
  } else if (div === 'jmmxb') {
    var name = localStorage.username
    var zbdw = localStorage.orgname
    data.splice(1, 0, ['制表单位:' + zbdw + '          ' + '制表人：' + name])
    ws = sheet_from_array_of_arrays_jmmxb(data)
  }
  /* add worksheet to workbook */
  wb.SheetNames.push(ws_name)
  wb.Sheets[ws_name] = ws
  var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: false, type: 'binary' })

  var title = defaultTitle || '列表'
  saveAs(new Blob([s2ab(wbout)], { type: 'application/octet-stream' }), title + '.xlsx')
}
export function export_json_to_excel_Merge(headerList, dataList, defaultTitle, colNum, div) {
  /* original data */
  var filterVal = []
  var tHeader = []
  var tHeader2 = []
  var ArrMerge = []
  var numberone = 0
  var numbertwo = 0
  headerList.forEach((item, index) => {
    if (item.ColumnKey === '') {
      ArrMerge.push({
        s: { c: numberone + numbertwo, r: 1 },
        e: { c: numberone + numbertwo + item.ColumnChild.length - 1, r: 1 }
      })
      item.ColumnChild.forEach((items, indexs) => {
        ;(tHeader2 = tHeader2.concat(items.ColumnName)),
          (filterVal = filterVal.concat(items.ColumnKey)),
          (tHeader = tHeader.concat(item.ColumnName)),
          numberone++
      })
    } else {
      tHeader2 = tHeader2.concat(item.ColumnName)
      filterVal = filterVal.concat(item.ColumnKey)
      tHeader = tHeader.concat(item.ColumnName)
      numbertwo++
      ArrMerge.push({ s: { c: numberone + numbertwo - 1, r: 1 }, e: { c: numberone + numbertwo - 1, r: 2 } })
    }
  })
  ArrMerge.unshift({ s: { c: 0, r: 0 }, e: { c: numberone + numbertwo - 1, r: 0 } })
  var data = dataList.map(v => filterVal.map(j => v[j]))
  data.unshift(tHeader2)
  data.unshift(tHeader)
  data.unshift([defaultTitle])
  if (colNum === undefined) colNum = 1
  var ws_name = 'SheetJS'
  var wb = new Workbook(),
    ws
  if (div === undefined) {
    ws = sheet_from_array_of_arrays(data, colNum)
  } else if (div === 'mergeheader') {
    ws = sheet_from_array_of_arrays_mergeheader(data, ArrMerge)
  } else if (div === 'hmzcjm') {
    ws = sheet_from_array_of_arrays_hmzcjm(data)
  } else if (div === 'jmmxb') {
    var name = localStorage.username
    var zbdw = localStorage.orgname
    data.splice(1, 0, ['制表单位:' + zbdw + '          ' + '制表人：' + name])
    ws = sheet_from_array_of_arrays_jmmxb(data)
  }
  /* add worksheet to workbook */
  wb.SheetNames.push(ws_name)
  wb.Sheets[ws_name] = ws
  var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: false, type: 'binary' })

  var title = defaultTitle || '列表'
  saveAs(new Blob([s2ab(wbout)], { type: 'application/octet-stream' }), title + '.xlsx')
}

在需要使用的地方复制使用

	let headList=[{
	ColumnAlign: "center",
	ColumnKey:"a",
	ColumnName: "测试a",
	ColumnOrder: "CDHSTATUS",
	ColumnWidth: 90},
	{
	ColumnAlign: "center",
	ColumnKey:"b",
	ColumnName: "测试b",
	ColumnOrder: "CDHSTATUS",
	ColumnWidth: 90
	}]
	let OutDataExcel=[{a:1,b:2....}]
	let header = '测试表格' //文件名字
      if (dataList.length === 0) {
        this.$message.error('无导出数据！')
        return
      }
      require.ensure([], () => {
        const { export_json_to_excel } = require('@/vendor/Export2Excel')
        export_json_to_excel(headList, OutDataExcel, header)
      
      })

导出的就是正常的Excel文件

哆比哆比
关注
js操作table导出excel
05-27
资源提供js操作html、table导出生成excel文件，代码简介易懂
vue el-table前端 file-saver 导出excel可导出分页数据.zip
12-11
本篇文章将深入探讨如何在Vue.js项目中结合`el-table`和`file-saver`库，实现前端导出分页数据到Excel的功能。 首先，我们需要了解`el-table`。它是Element UI的一部分，提供了一种灵活的方式来展示和操作表格数据...
js把table导出为excel
楠辞琦咎 难上加楠 出琦止胜
07-10 823
直接把html里的table导出成excel
js把数据导出excel表格并给表格设置样式
最新发布
qq_68155756的博客
10-08 323
// 整理表格 const formatExcel = (data, name) => { // 创建一个新的工作簿 const workbook = XLSXS.utils.book_new(); // 创建数据 const worksheetData = data; // 将数据转换为工作表 const worksheet = XLSXS.utils.aoa_to_sheet(worksheetData); // 设置样式 cons
JS直接导出excel 兼容ie、chrome、firefox
热门推荐
85-专栏
04-08 4万+
<html> <head> <script type="text/javascript" language="javascript"> var idTmr; function getExplorer() { var explorer = window.navigator.userAgent ; //ie
js将表格数据导出为excel数据
qq_56105902的博客
05-18 325
function ToExcel(){ //要导出的json数据 var jsonData = [ { name:'张三', id:'621' }, { name:'李四', id:'622' }, { name:'王五', id:'623' }, { name:'赵刘', id:'624' } ] //导出前要将json转成table格式...
js javascript 导出table表中数据到Excel中
黑色头发
11-17 186
[code="js"] 导出到Excel function toExcel(inTblId, inWindow) { try { var allStr = ""; var curStr = ""; i...
js实现数据导出为EXCEL（支持大量数据导出）
10-15
总结来说，JavaScript实现数据导出为Excel涉及多种技术，包括DOM操作、CSV生成、Base64编码、以及跨浏览器的兼容性处理。对于大量数据，需要特别关注性能优化，如分块处理和服务器端处理，以提供更好的用户体验。
前端导出Excel table2excel
11-20
"前端导出Excel table2excel"就是这样一个解决方案，它实现了在浏览器端将HTML表格直接转换为Excel文件，实现了“所见即所得”的效果。这个功能对于数据展示和分析非常有用，比如用户可以在查看完网页上的数据后，...
前端页面导出table中的内容到excel
10-26
在前端开发中，有时我们需要将用户在网页上看到的表格数据导出到Excel文件中，以便用户可以离线查看或进一步处理。这个过程涉及到的技术主要包括HTML表格操作、数据转换和文件下载。以下是对这个主题的详细说明： 1...
aaaaa.rar_JavaScript Excel_Table_table 导出excel_导出excel
09-14
这个"aaaaa.rar_JavaScript Excel Table_table 导出excel_导出excel"的主题涉及了如何利用JavaScript来实现从HTML表格（TABLE）导出数据到Excel文件的功能。下面将详细解释这一过程以及相关的技术知识点。 首先，...
【JavaScript源代码】纯JS将table表格导出到excel的方法.docx
12-30
纯JS将table表格导出到excel的方法 　　html　　<div >　　    <button type="button" onclick="getXlsFromTbl('tableExcel','myDiv')">IE导出Excel方法</button>　　    <button type="button" onclick="method5('tableExcel')">Chrome导出Excel</button>　　</div>　　<div id="myDiv">　　    <table id="tableExcel" width="100%" border="1" cellspac
js将table数据导出到excel
08-29
js导出excel，若果导不出excel，修改一下浏览器的安全级别到最低试试。
js前端导出table到excel
03-07
这是一个前端通过js导出页面的table生成并下载excel的demo
jquery.table2excel.js（用于table导出Excel文件）
01-11
里面包含了jquery.table2excel.js，用于table直接导出Excel文件，有例子可以参考
基于JS实现table导出Excel并保留样式
11-20
浏览器环境：谷歌浏览器 1.在导出Excel的时候，保存table的样式，有2种方法，①是在table的行内写style样式，②是在模板里面添加样式 2.第一种方式：行内添加样式 公司一 效果： 完整代码： <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> <style> table td { font-size: 12px; width: 200px; height: 30px; tex
使用JS将table表格导出为excel
AnglerS的博客
05-20 2898
之前都是用Java在后端做的导出，这次表格数据做的比较麻烦，就直接在前端把table导出了，非常方便。 博客文章链接:https://www.zjhuiwan.cn/info/20200212/4004242219096560.html html表格代码 导出 ...... <c:if test="${name!='admin1'&&name!='丽水市' }"> <tr> &
JS实现把表格数据导出，并生成为excel下载到本地
weixin_45392969的博客
02-24 4855
js成功实现导出excel功能
使用JS导出表格为Excel
hellotutu的博客
04-26 6491
使用JS导出表格为Excel HTML部分 js方法： var idTmr; function getExplorer() { var userAgent = navigator.userAgent; //取得浏览器的userAgent字符串 var isOpera = userAgent.indexOf(“Opera”) > -1; //判断是否Opera浏览器 var isIE = userAgent.indexOf(“compatible”) > -1 && user
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值