当前位置：首页 > news >正文

前端JavaScript导出excel,并用excel分析数据，使用SheetJS导出excel

news 来源：原创 2024/9/21 0:57:05

前言：哈喽，大家好，今天给大家分享今天给大家分享一篇文章！并提供具体代码帮助大家深入理解，彻底掌握！创作不易，如果能帮助到大家或者给大家一些灵感和启发，欢迎收藏+关注哦 💕

共同探索软件研发！敬请关注【宝码香车】
csdngif标识

前端js导出excel,并用excel分析数据，使用SheetJS导出excel
📚一、效果
📚二、信息
- 💡1.核心：
📚三、源代码，上代码，可以直接复制使用
- ✍️html
📚四、用excel进行数据分析
- 📖1.把下载好的数据用excel打开
- 📖2.选择合适的格式
- 📖3.分析数据

📚💡📝🗂️✍️🛠️💻🚀🎉🏗️🌐🖼️🔗📊👉🔖⚠️🌟🔐⬇️·正文开始⬇️·🎥😊🎓📩😺🌈🤝🤖📜📖📋🔍✅🧰❓📄📢📈 🙋1️⃣2️⃣3️⃣

前端js导出excel,并用excel分析数据，使用SheetJS导出excel

sheetjs文档1：https://github.com/rockboom/SheetJS-docs-zh-CN
sheetjs文档2：https://xlsx.nodejs.cn/
sheetjs文档3：https://xlsx.nodejs.cn/docs/csf/cell/

📚一、效果

📚二、信息

💡1.核心：

引入sheetjs库

<script lang="javascript" src="https://cdn.sheetjs.com/xlsx-0.20.1/package/dist/xlsx.full.min.js"></script>

  const dataDemo = [['公司名称', '职位', '薪资'],['正大国际', '工程监理', '10-20k'],['依茨法尔', '研发工程师', '15-25k'],]// 将二维数组转换为工作表对象const ws = XLSX.utils.aoa_to_sheet(dataDemo)// 创建一个新的工作簿对象const wb = XLSX.utils.book_new()// 将工作表对象添加到工作簿中，'Sheet1'为工作表的名称XLSX.utils.book_append_sheet(wb, ws, 'Sheet1')// 将工作簿数据写入文件，'exported_data.xlsx'为导出文件的名称XLSX.writeFile(wb, '招聘.xlsx')

📚三、源代码，上代码，可以直接复制使用

✍️html

<!doctype html>
<html lang="en">
<head><meta charset="UTF-8"><meta name="viewport"content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"><meta http-equiv="X-UA-Compatible" content="ie=edge"><title>Document</title>
</head>
<body></body>
<!-- use version 0.20.1 -->
<script lang="javascript" src="https://cdn.sheetjs.com/xlsx-0.20.1/package/dist/xlsx.full.min.js"></script>
<script>const data = [["公司名称","职位","薪资"],["金正大国际","仪表工程师","10-15K"],["山东金正阳","矿石加工工程师","7-10K"],["山田新材料","机械工程师","6-11K"],["申正机械","申正机械招聘焊工","5-10K"],["盈盛泰","消防工程师","4-5K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东米娅","研发工程师","6-11K"],["史丹利","史丹利招聘生产安全员","7-12K"],["道依茨法尔","车身研发工程师","10-15K·13薪"],["山东基彩","水性涂料研发服务工程师","9-13K"],["朗智家居","工程监理","8-13K"],["山东科翰硅源新材料","研发专员","4-8K"],["临沂临沭","临沂临沭招聘消防中控员","3-4K"],["山东昌德东","山东昌德东招聘质量管理/测试","3-4K"],["厚德","cad绘图专员","4-5K"],["临沭德艺装饰","建筑施工现场管理","5-6K"],["富联","富联招聘生产安全员","5-9K"],["山东久固钢结构工...","技术员","5-8K"],["中龙建材","资料员文员","3-4K"],["蒙纳德","蒙纳德招聘质量管理/测试","3-6K"],["正大工艺","产品设计师","3-5K"],["临沂雨浩商贸有限公司","云南白药招聘临沭县区经理","3-8K"],["润之升","临沭生产文员","3-4K"],["招联信息咨询","经理助理","8-10K"],["佰世利工艺品公司","业务","4-8K"],["数字奇点","销售代表","5-10K·13薪"],["上海微创投资控股...","医疗器械厂家销售-骨科关节（山东临沂）","6-10K·20薪"],["华辛商贸","医药代表","5-10K"],["临沂市硕熙医疗科...","医药地区经理","12-24K"],["金丰公社","培训经理/主管","5-8K"],["瑞纳集团","电气工程师","5-8K·14薪"],["山田研磨","机械工程师","9-14K"],["山东金正阳","矿石加工工程师","7-10K"],["临沂鹏科金属","化工工程师","6-10K"],["申正机械","申正机械招聘焊工","5-9K"],["盈盛泰","消防工程师","4-5K"],["史丹利","史丹利招聘生产安全员","7-12K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东米娅","研发工程师","6-11K"],["茸渝","机械工程师","3-4K"],["碧桂园集团山东区域","房修工程师","7-8K"],["道依茨法尔","车身研发工程师","10-15K·13薪"],["富联","富联招聘生产安全员","5-6K"],["伯乐为亮","工艺工程师（碳化硅）","25-50K"],["山东科翰硅源新材料","车间DCS系统设备工程师","5-8K"],["山东慧美","化妆品研发工程师","6-11K"],["中国电信临沭分公司","移动通信工程师","4-9K"],["临沂蔚云环保科技","大气环境治理工程师","3-7K"],["山东基彩","水性涂料研发服务工程师","9-13K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["朗智家居","工程监理","8-13K"],["山东正阳工程咨询公司","工程造价员","4-8K"],["临沂临沭","临沂临沭招聘消防中控员","3-4K"],["圣泰","机械工艺员","8-10K"],["山东昌德东","山东昌德东招聘质量管理/测试","3-4K"],["金正大国际","微生物产品研发专员","7-9K"],["厚德","cad绘图专员","4-5K"],["山东政泰建设项目...","咨询项目管理","5-8K"],["山颖建","造价师","10-15K"],["金正大国际","仪表工程师","10-15K"],["临沂中科芯华新材...","技术工程师","8-13K"],["道依茨法尔","液压工程师","9-14K·13薪"],["盈盛泰","消防工程师","4-5K"],["鹏科","化工工程师","6-10K"],["山田新材料","机械工程师","6-11K"],["瑞纳集团","暖通工程师","8-13K·14薪"],["邦旭科技","运维工程师","2-3K"],["申正机械","申正机械招聘焊工","5-9K"],["震悦减震","机械工程师","4-6K"],["山东金正阳","采矿工程师","7-10K"],["临沂金正阳管业","地质工程师","8-12K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东米娅","研发工程师","6-11K"],["茸渝","机械工程师","3-4K"],["山东科翰硅源新材料","车间DCS系统设备工程师","5-8K"],["伯乐为亮","高级机械设计工程师","20-25K"],["山东慧美","化妆品研发工程师","6-11K"],["临沂蔚云环保科技","大气环境治理工程师","3-7K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["朗智家居","工程监理","8-13K"],["山东正阳工程咨询公司","工程造价员","4-8K"],["圣泰","机械工艺员","8-10K"],["启千公司","社保主播","5-8K"],["厚德","cad绘图专员","4-5K"],["临沭德艺装饰","建筑施工现场管理","5-6K"],["艺辰影视","舞美设计执行","80-90元/天"],["富联","富联招聘生产安全员","5-9K"],["史丹利","生产管培生","5-8K"],["瑞纳集团","电气工程师","5-8K·14薪"],["山田研磨","机械工程师","9-14K"],["山东金正阳","矿石加工工程师","7-10K"],["临沂鹏科金属","化工工程师","6-10K"],["盈盛泰","消防工程师","4-5K"],["申正机械","申正机械招聘焊工","5-9K"],["震悦减震","机械工程师","4-6K"],["史丹利","史丹利招聘生产安全员","7-12K"],["山东米娅","研发工程师","6-11K"],["道依茨法尔","整机研发工程师","10-15K·13薪"],["伯乐为亮","工艺工程师（碳化硅）","25-50K"],["中国电信临沭分公司","移动通信工程师","4-9K"],["临沂蔚云环保科技","大气环境治理工程师","3-7K"],["山东基彩","水性涂料研发服务工程师","9-13K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["启千公司","跨境电商产品开发专员","5-10K"],["朗智家居","工程监理","8-13K"],["东泰包装","工程经理","18-20K"],["临沂临沭","临沂临沭招聘消防中控员","3-4K"],["金正大国际","微生物产品研发专员","7-9K"],["厚德","cad绘图专员","4-5K"],["同文","实验员","3-8K"],["临沭德艺装饰","建筑施工现场管理","5-6K"],["山东政泰建设项目...","咨询项目管理","5-8K"],["富联","富联招聘生产安全员","5-9K"],["山东伟业棉油","预算员","5-7K"],["中龙建材","资料员文员","3-4K"],["交换空间装饰","项目经理","6-10K"],["常林饲料","品牌总经理，销售主管，销售专员","8-9K"],["金正大国际","仪表工程师","10-15K"],["瑞纳集团","电气工程师","5-8K·14薪"],["山田研磨","机械工程师","9-14K"],["临沂中科芯华新材...","技术工程师","8-13K"],["道依茨法尔","液压工程师","9-14K·13薪"],["临沂鹏科金属","化工工程师","6-10K"],["盈盛泰","消防工程师","4-5K"],["邦旭科技","运维工程师","2-3K"],["震悦减震","机械工程师","4-6K"],["临沂金正阳管业","地质工程师","8-12K"],["申正机械","申正机械招聘焊工","5-10K"],["史丹利","史丹利招聘生产安全员","7-12K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东金正阳","选矿工程师","8-10K"],["伯乐为亮","工艺工程师（碳化硅）","25-50K"],["富联","富联招聘生产安全员","5-6K"],["山东基彩","水性色浆工程师","8-13K"],["山东慧美","化妆品研发工程师","6-11K"],["中国电信临沭分公司","移动通信工程师","4-9K"],["临沂蔚云环保科技","大气环境治理工程师","3-7K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["启千公司","跨境电商产品开发专员","5-10K"],["东泰包装","工程经理","18-20K"],["山东正阳工程咨询公司","工程造价员","4-8K"],["山东科翰硅源新材料","研发专员","4-8K"],["临沂临沭","临沂临沭招聘消防中控员","3-4K"],["圣泰","机械工艺员","8-10K"],["山东昌德东","山东昌德东招聘质量管理/测试","3-4K"],["厚德","cad绘图专员","4-5K"],["金正大国际","仪表工程师","10-15K"],["瑞纳集团","电气工程师","5-8K·14薪"],["山田研磨","机械工程师","9-14K"],["山东金正阳","矿石加工工程师","7-10K"],["临沂中科芯华新材...","技术工程师","8-13K"],["道依茨法尔","液压工程师","9-14K·13薪"],["临沂鹏科金属","化工工程师","6-10K"],["盈盛泰","消防工程师","4-5K"],["邦旭科技","运维工程师","2-3K"],["申正机械","申正机械招聘焊工","5-9K"],["震悦减震","机械工程师","4-6K"],["临沂金正阳管业","地质工程师","8-12K"],["史丹利","史丹利招聘生产安全员","7-12K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东米娅","研发工程师","6-11K"],["茸渝","机械工程师","3-4K"],["碧桂园集团山东区域","房修工程师","7-8K"],["伯乐为亮","工艺工程师（碳化硅）","25-50K"],["富联","富联招聘生产安全员","5-6K"],["山东科翰硅源新材料","车间DCS系统设备工程师","5-8K"],["山东基彩","水性色浆工程师","8-13K"],["山东慧美","化妆品研发工程师","6-11K"],["中国电信临沭分公司","移动通信工程师","4-9K"],["临沂蔚云环保科技","大气环境治理工程师","3-7K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["启千公司","跨境电商产品开发专员","5-10K"],["朗智家居","工程监理","8-13K"],["东泰包装","工程经理","18-20K"],["山东正阳工程咨询公司","工程造价员","4-8K"],["金正大国际","仪表工程师","10-15K"],["瑞纳集团","电气工程师","5-8K·14薪"],["山田研磨","机械工程师","9-14K"],["临沂中科芯华新材...","技术工程师","8-13K"],["临沂鹏科金属","化工工程师","6-10K"],["申正机械","申正机械招聘焊工","5-9K"],["山东金正阳","采矿工程师","7-10K"],["临沂金正阳管业","地质工程师","8-12K"],["道依茨法尔","车身研发工程师","10-15K·13薪"],["富联","富联招聘生产安全员","5-6K"],["山东慧美","化妆品研发工程师","6-11K"],["盈盛泰","盈盛泰招聘水电工","4-9K"],["山东科翰硅源新材料","研发专员","4-8K"],["临沂临沭","临沂临沭招聘消防中控员","3-4K"],["山东昌德东","山东昌德东招聘质量管理/测试","3-4K"],["启千公司","社保主播","5-8K"],["厚德","cad绘图专员","4-5K"],["临沭德艺装饰","建筑施工现场管理","5-6K"],["山颖建","造价师","10-15K"],["中龙建材","资料员文员","3-4K"],["山东久固钢结构工...","钢结构预算员","4-8K"],["蒙纳德","蒙纳德招聘质量管理/测试","3-6K"],["四川佳能达科技发展","otc医药代表","10-11K"],["临沂雨浩商贸有限公司","云南白药招聘临沭县区经理","3-8K"],["山东联易","经理助理","8-10K"],["润之升","临沭生产文员","3-4K"],["招联咨询","经理助理","7-8K"],["统一汽贸","山东统一公司招债权管理岗","4-8K"],["佰世利工艺品公司","业务","4-8K"],["伯乐为亮","博士研究员","40-70K"],["鹏科","化工工程师","6-10K"],["瑞纳集团","自控工程师","6-10K"],["茸渝","机械工程师","3-4K"],["道依茨法尔","整机研发工程师","10-15K·13薪"],["山田新材料","机器人工程师","15-20K"],["启千公司","跨境电商产品开发专员","5-10K"],["史丹利","生产管培生","5-8K"],["山东久固钢结构工...","钢结构预算员","4-8K"],["交换空间装饰","项目经理","6-10K"],["临沭锦融","信用卡客户经理","4-9K"],["临沂雨浩商贸有限公司","云南白药招聘临沭县区经理","3-8K"],["数字奇点","销售代表","5-10K·13薪"],["临沂市硕熙医疗科...","医药地区经理","12-24K"],["江西聚心同互联网...","医药销售经理","10-15K"],["山东世盛精密机械","外贸跟单专员","4-8K"],["药师帮","【药师帮+临沭县】招医药代表","7-12K"],["山田新材料","助理机械工程师","4-5K"],["道依茨法尔","驾驶室设计工程师","7-12K·13薪"],["山田新材料","销售人员(J10006)","4-8K"],["山田新材料","博士研究员(J10001)","30-40K"],["金正大国际","仪表工程师","10-15K"],["山东金正阳","矿石加工工程师","7-10K"],["临沂中科芯华新材...","技术工程师","8-13K"],["盈盛泰","消防工程师","4-5K"],["邦旭科技","运维工程师","2-3K"],["申正机械","申正机械招聘焊工","5-9K"],["震悦减震","机械工程师","4-6K"],["临沂金正阳管业","地质工程师","8-12K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东米娅","研发工程师","6-11K"],["道依茨法尔","液压工程师","9-14K·13薪"],["盈盛泰","消防工程师","4-5K"],["鹏科","化工工程师","6-10K"],["山田新材料","机械工程师","6-11K"],["瑞纳集团","暖通工程师","8-13K·14薪"],["临沂金正阳管业","地质工程师","8-12K"],["邦旭科技","运维工程师","2-3K"],["申正机械","申正机械招聘焊工","5-9K"],["震悦减震","机械工程师","4-6K"],["山东金正阳","采矿工程师","7-10K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东米娅","研发工程师","6-11K"],["茸渝","机械工程师","3-4K"],["金正大国际","仪表工程师","10-15K"],["伯乐为亮","高级机械设计工程师","20-25K"],["山东慧美","化妆品研发工程师","6-11K"],["临沂蔚云环保科技","大气环境治理工程师","3-7K"],["山东科翰硅源新材料","车间DCS系统设备工程师","5-8K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["朗智家居","工程监理","8-13K"],["山东正阳工程咨询公司","工程造价员","4-8K"],["圣泰","机械工艺员","8-10K"],["启千公司","社保销售","6-10K"],["厚德","cad绘图专员","4-5K"],["临沭德艺装饰","建筑施工现场管理","5-6K"],["艺辰影视","舞美设计执行","80-90元/天"],["富联","富联招聘生产安全员","5-9K"],["史丹利","生产管培生","5-8K"],["山东久固钢结构工...","技术员","5-8K"],["金正大国际","仪表工程师","10-15K"],["道依茨法尔","液压工程师","9-14K·13薪"],["盈盛泰","消防工程师","4-5K"],["鹏科","化工工程师","6-10K"],["山田新材料","机械工程师","6-11K"],["瑞纳集团","暖通工程师","8-13K·14薪"],["临沂金正阳管业","地质工程师","8-12K"],["邦旭科技","运维工程师","2-3K"],["申正机械","申正机械招聘焊工","5-9K"],["震悦减震","机械工程师","4-6K"],["山东金正阳","采矿工程师","7-10K"],["茸渝","机械工程师","3-4K"],["山东米娅","研发工程师","6-11K"],["伯乐为亮","高级机械设计工程师","20-25K"],["山东科翰硅源新材料","车间DCS系统设备工程师","5-8K"],["山东慧美","化妆品研发工程师","6-11K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["朗智家居","工程监理","8-13K"],["山东正阳工程咨询公司","工程造价员","4-8K"],["圣泰","机械工艺员","8-10K"],["启千公司","社保销售","6-10K"],["厚德","cad绘图专员","4-5K"],["临沭德艺装饰","建筑施工现场管理","5-6K"],["艺辰影视","舞美设计执行","80-90元/天"],["富联","富联招聘生产安全员","5-9K"],["史丹利","生产管培生","5-8K"],["蒙纳德","蒙纳德招聘质量管理/测试","3-6K"],["山东伟业棉油","预算员","5-7K"],["交换空间装饰","项目经理","6-10K"],["瑞纳集团","电气工程师","5-8K·14薪"],["金正大国际","仪表工程师","10-15K"],["道依茨法尔","液压工程师","9-14K·13薪"],["山田新材料","机械工程师","6-11K"],["盈盛泰","消防工程师","4-5K"],["临沂金正阳管业","地质工程师","8-12K"],["申正机械","申正机械招聘焊工","5-10K"],["史丹利","史丹利招聘生产安全员","7-12K"],["邦旭科技","运维工程师","2-3K"],["山东金正阳","采矿工程师","7-10K"],["伯乐为亮","工艺工程师（碳化硅）","25-50K"],["临沂金科铸造有限公司","机械工程师","6-8K"],["山东米娅","研发工程师","6-11K"],["山东基彩","水性色浆工程师","8-13K"],["中国电信临沭分公司","移动通信工程师","4-9K"],["朗智家居","工程监理","8-13K"],["东泰包装","工程经理","18-20K"],["山东科翰硅源新材料","研发专员","4-8K"],["临沂临沭","临沂临沭招聘消防中控员","3-4K"],["山东昌德东","山东昌德东招聘质量管理/测试","3-4K"],["厚德","cad绘图专员","4-5K"],["同文","实验员","3-8K"],["临沭德艺装饰","建筑施工现场管理","5-6K"],["艺辰影视","舞美设计执行","80-90元/天"],["富联","富联招聘生产安全员","5-9K"],["山东久固钢结构工...","技术员","5-8K"],["中龙建材","资料员文员","3-4K"],["蒙纳德","蒙纳德招聘质量管理/测试","3-6K"],["交换空间装饰","项目经理","6-10K"],["临沭锦融","信用卡客户经理","4-9K"],["金正大国际","仪表工程师","10-15K"],["临沂中科芯华新材...","技术工程师","8-13K"],["山田新材料","机械工程师","6-11K"],["盈盛泰","消防工程师","4-8K"],["邦旭科技","运维工程师","2-3K"],["震悦减震","机械工程师","4-6K"],["临沂金正阳管业","地质工程师","8-12K"],["申正机械","申正机械招聘焊工","5-10K"],["鹏科","化工工程师","6-10K"],["瑞纳集团","自控工程师","6-10K"],["茸渝","机械工程师","3-4K"],["山东金正阳","选矿工程师","8-10K"],["道依茨法尔","整机研发工程师","10-15K·13薪"],["富联","富联招聘生产安全员","5-6K"],["山东基彩","水性色浆工程师","8-13K"],["临沂蔚云环保科技","大气环境治理工程师","3-7K"],["山东金扬教育科技","风电/光伏运维工程师","5-6K"],["思路智园科技","化工业务工程师-工艺或消防方向","10-15K"],["启千公司","跨境电商产品开发专员","5-10K"],["山东科翰硅源新材料","研发专员","4-8K"],["圣泰","机械工艺员","8-10K"],["山东昌德东","山东昌德东招聘质量管理/测试","3-4K"],["厚德","cad绘图专员","4-5K"],["山颖建","造价师","10-15K"],["史丹利","生产管培生","5-8K"],["中龙建材","建筑资质专员","5-6K"],["山东久固钢结构工...","钢结构预算员","4-8K"],["蒙纳德","蒙纳德招聘质量管理/测试","3-6K"],["交换空间装饰","项目经理","6-10K"],["常林饲料","品牌总经理，销售主管，销售专员","8-9K"]
]// 将二维数组转换为工作表对象const ws = XLSX.utils.aoa_to_sheet(data)// 创建一个新的工作簿对象const wb = XLSX.utils.book_new()// 将工作表对象添加到工作簿中，'Sheet1'为工作表的名称XLSX.utils.book_append_sheet(wb, ws, 'Sheet1')// 将工作簿数据写入文件，'exported_data.xlsx'为导出文件的名称XLSX.writeFile(wb, '招聘.xlsx')
</script>
</html>