Creating Java Model ClassWe will generate an Excel document that contains a list of Java books, so create the following model class ( Book.java): package

We will end up with the following project structure: The jar files used are: However, you can also download a JExcelApi version of the project in the Attachments section.In Eclipse IDE, create a Dynamic Web Project called SpringMvcExcelViewDemo. And Spring provides an abstract class called AbstractJExcelView which should be extended to generate an Excel document using JExcelApi, similarly to the case of Apache POI.This tutorial will use Apache POI for the sample application. You can download JExcelApi from the following link: JExcelApi DownloadTo work with JExcelApi, you need to add its only jar file: jxl.jar - to your project’s classpath.

It supports Excel 2003 file format and older versions. About JExcelApi: JExcelApi is a Java library that is dedicated for reading, writing and modifying Excel spreadsheets. Then using Apache POI’s Excel API to generate the excel document. To generate an Excel document using Apache POI within Spring, we need to create a view class that extends from the AbstractExcelView class and override its method buildExcelDocument(). Click the following link to download its latest distribution (which is Apache POI 3.9, as of this writing):Īpache POI DownloadThe distribution comes with several jar files, but the only the poi-VERSION.jar file is required for typical usage of generating Excel documents (if you want to generate Excel XML format such as *.xlsx files, use the poi-ooxml-VERSION.jar file). NOTE: If you're looking for code example exporting Excel in Spring Boot, refer to this article: Spring Boot Export Data to Excel ExampleThis tutorial is going to help you in understanding how to configure Spring MVC to work with these libraries in order to deliver dynamic content in form of Excel document to the users, by developing a sample Spring MVC application that allows the users to download an Excel document generated on the fly: Clicking on the download link will prompt the users for downloading/opening the document which looks like the following screenshot in Microsoft Excel program: About Apache POI: Apache POI is a set of pure Java libraries for reading and writing Microsoft Office documents such as Word, Excel, Powerpoint, Outlook, etc. For working with Excel view, Spring supports two popular libraries such as Apache POI and JExcelApi (Both are free and open source). When configured properly, a Spring’s view resolver can generate an Excel document from model data and send it to the client for downloading or opening by a spreadsheet program like Microsoft Excel. Spring MVC offers seamless integration with different view technologies, including Excel document view.

Download apache poi jar