excel-parser | Annotated Excel parsing library to simplify parsing excel | Parser library

by nvenky Java Version: 1.0.1 License: MIT

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | excel-parser Summary

excel-parser is a Java library typically used in Utilities, Parser applications. excel-parser has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can download it from GitHub, Maven.

HSSF - Horrible Spreadsheet Format – not anymore. With few annotations, excel parsing can be done in one line. We had a requirement in our current project to parse multiple excel sheets and store the information to database. I hope most of the projects involving excel sheet parsing would be doing the same. We built a extensible framework to parse multiple sheets and populate JAVA objects with annotations.

Support

Quality

Security

License

Reuse

Support

excel-parser has a low active ecosystem.

It has 75 star(s) with 46 fork(s). There are 11 watchers for this library.

It had no major release in the last 12 months.

There are 5 open issues and 3 have been closed. On average issues are closed in 160 days. There are 3 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of excel-parser is 1.0.1

Quality

excel-parser has 0 bugs and 0 code smells.

Security

excel-parser has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

excel-parser code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

excel-parser is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

excel-parser releases are not available. You will need to build from source code and install.

Deployable package is available in Maven.

Build file is available. You can build the component from source.

Installation instructions are not available. Examples and code snippets are available.

excel-parser saves you 345 person hours of effort in developing the same functionality from scratch.

It has 825 lines of code, 75 functions and 15 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed excel-parser and discovered the below as its top functions. This is intended to give you an instant insight into excel-parser implemented functionality, and help decide if they suit your requirements.

Adds an Excel invalid cell

Get all kandi verified functions for this library.

excel-parser Key Features

No Key Features are available at this moment for excel-parser.

excel-parser Examples and Code Snippets

No Code Snippets are available at this moment for excel-parser.

Community Discussions

Trending Discussions on excel-parser

How to loop through excel docs in Node

QUESTION

How to loop through excel docs in Node

Asked 2021-Jun-21 at 22:36

My goal is to create a script within a Node project which will loop through a directory of spreadsheets, pull a value from a cell, and add this value to a new row in a new spreadsheet... I am unable to figure out the logic.

In my root directory, I have a folder name "Timesheets" and in there a folder named "2021" which is where I store all my timesheets. Each timesheet is named as the date-span for the week (ex: June14th-18th). Each timesheet has one cell which is labeled the total hours for the week (cell D12) this is the only cell I care about.

I am using node packages 'xlsx' and 'fs'. The following code will give me the names of all the files in the timesheet directory, but I am struggling to determine how to do anything with that data. I am new to Node, so any guidance would be greatly appreciated.

read-timesheets.js

...

ANSWER

Answered 2021-Jun-21 at 22:36

You have to append the directory name to the file name inside forEach because the xlsx files are not directly near the script.

Node comes with utilities to work with paths

Source https://stackoverflow.com/questions/68075453

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install excel-parser

You can download it from GitHub, Maven.
You can use excel-parser like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the excel-parser component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: