Giter VIP home page Giter VIP logo

excelmergetool's Introduction

基于nodejs的excel表格合并工具

背景

最近在搞基于NodeJs的爬虫抓取数据
为了让抓取数据更加稳定且不导致nodejs线程阻塞，所以进行了分段抓取
例如抓取1万条数据，分成了20个excel文件
但是几十个excel文件分别导入到数据库中，操作繁琐且麻烦，那么将多个excel文件合并后导入数据库是一个不错的方法（大家如果有其他好的方法可以在评论里聊一聊哈）
本想用wps去合成，结果发现它居然要登录且开会员！！又懒得去装新版的office（手动滑稽）

正确的食用姿势

  1. 把需要合并的文件放到excel文件夹里
  2. 运行start.bat文件
  3. 到result下拿到合并完成的excel

运行

$ npm i
$ npm run start

注意

excel文件里的字段要保持一致哦

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.