Go to Java to generate an Excel table (POI vs jxl)

ArticleDirectory

• Java generates an Excel table (POI vs jxl)

Java generates an Excel table (POI vs jxl)

Article category:Java programming

Java to generate an Excel table (POI vs jxl) Java to generate an Excel table. I used to only know POI. This is an open-source project of Apache. It was originally a set, including word, but due to the complexity of word, and the lack of developers seems to be basically stagnant. Only Excel is relatively complete and easy to use.

Later, due to the relationship between projects, I learned that there is also a jxl (Java Excel), which is also an open-source project. It feels similar to poi, because the functions used are very simple, there is no big gap. Some of their differences are found on the internet, and they are offering their own literacy.

The following is a secondary sticker, marked in red.

Since the MS discloses the Office encoding format, many open-source organizations have provided plug-in packages that support read and write operations on Excel. In the Java World, Apache should be the leader in the Open Source world. HisJakarta ProjectInPoi ProjectIt provides perfect support for office (however, it seems that his support for word project has been stopped recently and people are publicly listed on the website. If you are familiar with the encoding format of Word files, you can send an email !), Of course, many other open-source organizations also provide excellent support for Excel read/write operations, among which display-tag is simple and practical,ProgramThe clerk does not need to consider how to reasonably write data into the Excel file. It is all done automatically by his servlet, but it is precisely because he is transparent to the programmer, therefore, it is inconvenient for many operations. In the following text, I will introduce another third-party plug-in jxl that provides perfect support for excel. Java Excel is an open source project, java developers can read the content of an Excel file, create a new Excel file, and update an existing Excel file. Using this API, non-Windows operating systems can also use Java-only applications to process Excel Data Tables. Because it is written in Java, we can use JSP and Servlet in web applications to call APIs to access Excel Data Tables.

JakartaOfPoi ProjectAndJava Excel APIIn the open-source world, it can be said that it is a good combination, but it also has its own advantages and disadvantages. Poi has some minor bugs in some details and does not support writing images (Poi can write images, but it is not convenient and troublesome to use jxl.), Other aspects are quite good; and jxl provides support for images (However, only images in PNG format are supported.), The problem is that it does not support formulas well, but it still supports reading simple formulas. Therefore, it is up to your application to decide what third-party plug-ins to use in your project.If your software is related to finance, we recommend that you usePoi ProjectIn my current project, because the calculation formula is not used and images may need to be exported, my choice is jxl.

Powered by zoundry