Git Product home page Git Product logo

nodehandleexcel's Introduction

这是一个用Nodejs来操作excel表格的项目(练手)

使用class的方式进行编程(面向对象的方式)

  1. 文件读读取是有一个excel文件存放位置,通过node内置的fs方法来读取文件流,在通过xlsx插件对excel表格进行读取。
  2. 使用了dayjs对日期进行计算,主要是为了拿去表格中的月份,然后匹配月份是否匹配天数来捕获边界条件。
  3. 使用lodash简化计算能力。

注意!! 这个脚本只是针对我现在处理的表格数据。 不同的表格,数据处理也不一样。

不过, 读取文件路径,操作excel等操作请前往xlsx文档。可以尝试用js对进行处理 处理完在丢到xlsx生成新的excel表格。

nodehandleexcel's People

Watchers

James Cloos avatar Bigjocker avatar

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.