poi-shared-strings | Memory efficient Shared Strings Table | Security Framework library

by pjfanning Java Version: 2.7.1 License: Apache-2.0

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

kandi X-RAY | poi-shared-strings Summary

poi-shared-strings is a Java library typically used in Security, Security Framework applications. poi-shared-strings 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.

Memory efficient Shared Strings Table implementation for POI streaming

Support

Quality

Security

License

Reuse

Support

poi-shared-strings has a low active ecosystem.

It has 6 star(s) with 3 fork(s). There are 2 watchers for this library.

There were 1 major release(s) in the last 12 months.

There are 0 open issues and 4 have been closed. On average issues are closed in 16 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of poi-shared-strings is 2.7.1

Quality

poi-shared-strings has no bugs reported.

Security

poi-shared-strings has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

poi-shared-strings is licensed under the Apache-2.0 License. This license is Permissive.

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

Reuse

poi-shared-strings releases are available to install and integrate.

Deployable package is available in Maven.

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

Top functions reviewed by kandi - BETA

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

Read the comments table from an XML file
Parses a single comment element
Parses a CT event item
Returns the text of the wrapped event
Parses a comment
Adjusts the namespace on an event
Parses a RichTextRun
Creates a new comment
Find the comment shape for a cell
Write this table as XML
Returns the shared string item at the specified index
Reads the shared strings table from an XML file
Override this method to ensure that POIML is required
Get the cell addresses
Return the CCT comment

Get all kandi verified functions for this library.

poi-shared-strings Key Features

No Key Features are available at this moment for poi-shared-strings.

poi-shared-strings Examples and Code Snippets

No Code Snippets are available at this moment for poi-shared-strings.

Community Discussions

Trending Discussions on poi-shared-strings

Apache POI SAX XSSFReader reads wrong date format

QUESTION

Apache POI SAX XSSFReader reads wrong date format

Asked 2020-Feb-21 at 12:27

Apache POI SAX reader implemented similar to this well known example https://github.com/pjfanning/poi-shared-strings-sample/blob/master/src/main/java/com/github/pjfanning/poi/sample/XLSX2CSV.java reads some date values not as they are presented in excel despite it is supposed to read "formatted value".

Value in excel file : 1/1/2019, "formatted value" read by reader : 1/1/19.

Any idea why there is a difference?

Apache POI version 3.17

Reader code:

...

ANSWER

Answered 2020-Feb-21 at 12:27

Difference in value displayed by excel and read by Apache POI comes from date formats that react to user language settings. From Excel:

Date formats that begin with an asterisk (*) responds to changes in regional date and time settings that are specified for the operating system.

Apache POI DataFormatter ignores these locale specific formats and returns default US format date. From Apache POI DataFormatter documentation:

Some formats are automatically "localized" by Excel, eg show as mm/dd/yyyy when loaded in Excel in some Locales but as dd/mm/yyyy in others. These are always returned in the "default" (US) format, as stored in the file.

To work around this behavior see answer to Java: excel to csv date conversion issue with Apache Poi

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

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

Vulnerabilities

No vulnerabilities reported

Install poi-shared-strings

You can download it from GitHub, Maven.
You can use poi-shared-strings 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 poi-shared-strings 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: