sjxlsx | Java API to read and write XLSX Excel files

by davidpelfree Java Version: Current License: No License

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

kandi X-RAY | sjxlsx Summary

sjxlsx is a Java library typically used in Telecommunications, Media, Media, Entertainment, Utilities applications. sjxlsx has no vulnerabilities, it has build file available and it has low support. However sjxlsx has 1 bugs. You can download it from GitHub.

It is a simple and efficient java tool for reading, writing and modifying XLSX. The most important purpose to code it is for performance consideration — all the popular ones like POI sucks in both memory consuming and parse/write speed. sjxlsx provides two modes (classic & stream) to read/modify sheets. In classic mode, all records of the sheet will be loaded. In stream mode (also named iterate mode), you can read record one after another which save a lot memory. Microsoft XLSX use XML+zip (OOXML) to store the data. So, to be fast, sjxlsx use STAX for XML input and output. And I recommend the WSTX implementation of STAX (it’s the fastest in my testing).

Support

Quality

Security

License

Reuse

Support

sjxlsx has a low active ecosystem.

It has 40 star(s) with 36 fork(s). There are 13 watchers for this library.

It had no major release in the last 6 months.

There are 11 open issues and 3 have been closed. On average issues are closed in 394 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of sjxlsx is current.

Quality

sjxlsx has 1 bugs (0 blocker, 0 critical, 1 major, 0 minor) and 206 code smells.

Security

sjxlsx has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

sjxlsx code analysis shows 0 unresolved vulnerabilities.

There are 3 security hotspots that need review.

License

sjxlsx does not have a standard license declared.

Check the repository for any license declaration and review the terms closely.

Without a license, all rights are reserved, and you cannot use the library in your applications.

Reuse

sjxlsx releases are not available. You will need to build from source code and install.

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

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

sjxlsx saves you 1248 person hours of effort in developing the same functionality from scratch.

It has 2807 lines of code, 281 functions and 25 files.

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

Top functions reviewed by kandi - BETA

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

Merge styles
Prepare the styles count
Serialize this cell
Serialize the pattern fill
An example of creating a comment
Writes the start document
Merges content types
Write start element
Create a new writer support instance
Creates a new WriterSupport instance
Returns a hashCode of this hashCode
Modify cell
Trims the empty string and returns null
Create a new reader support instance
Increases the row number
Get Excel extension name
Initializes the sheet
Opens the Excel file
Opens the output file
Compares this cell with another
Parses shared strings
Serialize the rich text
Merges the content of one sheet
Returns the total number of rows in the sheet
Merge shared strings
Close the workbook

Get all kandi verified functions for this library.

sjxlsx Key Features

No Key Features are available at this moment for sjxlsx.

sjxlsx Examples and Code Snippets

No Code Snippets are available at this moment for sjxlsx.

Community Discussions

Trending Discussions on sjxlsx

Java export running jar w/ project

QUESTION

Java export running jar w/ project

Asked 2018-Jul-24 at 14:29

So, I've added a git repo to my project (sjxlsx). I've then right-clicked the repo and imported into the package explorer. I then went to Project->Build path in order to make sure it's on "Required projects on the build path".

When I debug on Eclipse, works just fine.

I'm now trying to export as a running jar and when I execute it outside of Eclipse, it somehow is giving an error (empty.xlsx not found). That is, because in the XLSXWriterSupport, the open method is fetching this empty.xlsx file. On debug, it's working as expected but on converting to a running jar, it's giving me this error.

This is due to this 'empty.xlsx' file being on the resources of the other project. How can I solve this?

https://github.com/davidpelfree/sjxlsx/blob/master/src/main/java/com/incesoft/tools/excel/support/XLSXWriterSupport.java

...

ANSWER

Answered 2018-Jul-24 at 14:29

You probably have the Eclipse Project build path configured to use absolute library references. When you try to run your runnable jar, the jvm cannot find the required dependencies.

Edit:

If you want to export your software as a RUNNABLE jar file, then the jar must contain a MANIFEST file which specifies the dependencies and main class. Example:

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

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

Vulnerabilities

No vulnerabilities reported

Install sjxlsx

You can download it from GitHub.
You can use sjxlsx 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 sjxlsx 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: