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

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

共同探索软件研发!敬请关注【宝码香车】
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>

📚四、用excel进行数据分析

📖1.把下载好的数据用excel打开

描述

📖2.选择合适的格式

描述

📖3.分析数据

描述


到此这篇文章就介绍到这了,更多精彩内容请关注本人以前的文章或继续浏览下面的文章,创作不易,如果能帮助到大家,希望大家多多支持宝码香车~💕


整理不易,点赞关注宝码香车

更多专栏订阅推荐:
👍 html+css+js 绚丽效果
💕 vue
✈️ Electron
⭐️ js
📝 字符串
✍️ 时间对象(Date())操作

本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.xdnf.cn/news/1540787.html

如若内容造成侵权/违法违规/事实不符,请联系一条长河网进行投诉反馈,一经查实,立即删除!

相关文章

Windows通过网线传文件

文章目录 网线网络中看不到另一台计算机Nginx参考文献 网线 两台电脑用网线连接 电脑A 控制面板\网络和 Internet\网络和共享中心 → 更改适配器设置 → 右键以太网&#xff08;未识别的网络&#xff09; → 属性 → Internet 协议版本 4 (TCP/IPv4) 属性 → 使用下面的 IP …

SQL编程题复习(24/9/19)

练习题 x25 10-145 查询S001学生选修而S003学生未选修的课程&#xff08;MSSQL&#xff09;10-146 检索出 sc表中至少选修了’C001’与’C002’课程的学生学号10-147 查询平均分高于60分的课程&#xff08;MSSQL&#xff09;10-148 检索C002号课程的成绩最高的二人学号&#xf…

en造数据结构与算法C# 群组行为优化 和 头鸟控制

实现&#xff1a; 1.给鸟类随机播放随机动画使得每一只鸟扇翅膀的频率都不尽相同 2.可以自行添加权重&#xff0c;并在最后 sumForce separationForce cohesionForce alignmentForce;分别乘上相应权重&#xff0c;这样鸟就能快速飞行和转向辣 using System.Collections.Ge…

小程序地图展示poi帖子点击可跳转

小程序地图展示poi帖子点击可跳转 是类似于小红书地图功能的需求 缺点 一个帖子只能有一个点击事件&#xff0c;不适合太复杂的功能&#xff0c;因为一个markers只有一个回调回调中只有markerId可以使用。 需求介绍 页面有地图入口&#xff0c;点开可打开地图界面地图上展…

安全热点问题

安全热点问题 1.DDOS2.补丁管理3.堡垒机管理4.加密机管理 1.DDOS 分布式拒绝服务攻击&#xff0c;是指黑客通过控制由多个肉鸡或服务器组成的僵尸网络&#xff0c;向目标发送大量看似合法的请求&#xff0c;从而占用大量网络资源使网络瘫痪&#xff0c;阻止用户对网络资源的正…

[Unity Demo]从零开始制作空洞骑士Hollow Knight第六集:制作小骑士完整的跳跃落地行为

提示&#xff1a;文章写完后&#xff0c;目录可以自动生成&#xff0c;如何生成可参考右边的帮助文档 文章目录 前言一、制作一个完整的小骑士跳跃落地行为 1.制作动画以及UNITY编辑器编辑2.使用代码实现完整的跳跃落地行为控制3.更多要考虑到的点总结 前言 大家好久不见&…

基于MTL的多任务视频推荐系统

多任务学习&#xff0c;也就是MTL(Multi-task Learning)&#xff0c;现在已经被用在很多领域了&#xff0c;比如处理自然语言、搞计算机视觉&#xff0c;还有语音识别这些领域。MTL在大规模的推荐系统里也玩得挺溜&#xff0c;尤其是那些做视频推荐的大家伙。 MTL的玩法就是&a…

NLP 主要语言模型分类

文章目录 ngram自回归语言模型TransformerGPTBERT&#xff08;2018年提出&#xff09;基于 Transformer 架构的预训练模型特点应用基于 transformer&#xff08;2017年提出&#xff0c;attention is all you need&#xff09;堆叠层数与原transformer 的差异bert transformer 层…

浅谈穷举法

穷举法 穷举法是一种通过逐一列举所有可能情况来寻找解决方案的方法。就像找到一把钥匙打开一把锁&#xff0c;我们会尝试每一把钥匙直到找到正确的那一把。比如&#xff0c;如果你忘记了自己的密码&#xff0c;可以尝试每一种可能的组合直到找到正确的密码为止 穷举法的结构 …

【Python】快速判断两个commit 是否存在cherry-pick 关系

判断两个提交是否有 cherry-pick 关系的 Python 脚本&#xff0c;可以基于以下三种常见情况进行优化&#xff1a; Commit Hash 一致&#xff1a;如果两个提交的 hash 完全相同&#xff0c;那么它们是相同的提交。 Commit Title 存在关联&#xff1a;如果两个提交的 commit mes…

如何下载ComfyUI开发版

看B站视频&#xff0c;见用绘世可以下载ComfyUI开发版&#xff0c;而我又不想在电脑里放太多东西&#xff0c;于是研究了一下&#xff0c;如何直接从GitHub网站下载。具体步骤看图示。 看压缩包内容&#xff0c;应该直接解压覆盖就可以了&#xff0c;暂未有时间测试。

科研绘图系列:R语言散点图和小提琴图(scatter plot violin plot)

文章目录 介绍加载R包导入数据数据预处理函数画图系统信息介绍 提取模型的结果并对模型的结果进行可视化。 加载R包 library(ggplot2) library(ggridges) library(patchwork) library(party) library(caret) library(dplyr

堆的向下调整算法和TOPK问题

目录 1.什么是堆&#xff1f; 1.1 向下调整建堆的时间复杂度计算 1.2 堆的结构体设计 2.堆的功能实现&#xff1a; 2.1 堆的插入&#xff1a; 2.2 堆的删除&#xff1a; 2.3 堆排序&#xff1a; 2.4 向下调整建堆&#xff1a; 2.5 TOPK问题&#xff1a; 2.6 向上调整算…

【Unity踩坑】UI Image的fillAmount不起作用

在游戏场景中&#xff0c;我们经常在界面上展示进度条&#xff0c;当然有各种形状的&#xff0c;线性的&#xff0c;长方形的&#xff0c;圆形&#xff0c;环形等等。 Unity中实现这种效果的话&#xff0c;最基本的方法说是改变Image的fillAmout属性。 如果你是初次使用UI Ima…

ubuntu安装SFML库+QT使用SFML库播放声音

(1)ubuntu安装SFML库 sudo apt-get install libsfml-dev (2)QT使用SFML库播放声音 在.pro文件中添加头文件路径和库文件路径 INCLUDEPATH /usr/include/SFML LIBS /usr/lib/x86_64-linux-gnu/libsfml*.so UI界面中创建一个pushbutton按钮&#xff0c;并且创建槽函数 加载…

国外大带宽服务器怎么连接

随着互联网技术的发展&#xff0c;企业和个人用户越来越依赖于高速的数据传输服务。国外的大带宽服务器因其高速度、稳定性及较低延迟等优势&#xff0c;成为了许多跨国公司、网站托管商以及数据密集型应用的选择。以下是连接国外大带宽服务器的一些常见方法及其注意事项。 选择…

STL-常用算法 遍历/查找/排序/拷贝和替换/算数生成/集合算法

STL常用算法 常用的遍历算法 for_each #define _CRT_SECURE_NO_WARNINGS #include<iostream> using namespace std; #include<vector> #include<algorithm>void myPrint(int v) {cout << v << " "; }class MyPrint { public:void op…

切换到WDDM模式,Tesla M4可以用于本地显示输出了!

正文共&#xff1a;1333 字 21 图&#xff0c;预估阅读时间&#xff1a;2 分钟 上次安装完Tesla M4显卡之后&#xff08;HPE服务器通过显卡直通安装Tesla M4&#xff0c;这算亮机成功了吗&#xff1f;&#xff09;&#xff0c;系统识别正常&#xff0c;但是不能用于显示&#x…

C语言的文件基础知识

一、文件存在的意义 ① 文件的定义是什么&#xff1f; 文件是以单个名称在计算机上存储的信息集合。文件可以是文本文档、图片、程序等等。文件通常具有三个字母的文件扩展名&#xff0c;用于指示文件类型&#xff08;例如&#xff0c;图片文件常常以 JPEG 格式保存并且文件扩…