Introduction
How to password protect some columns of Excel using java and editable some columns inside an excel sheet.
Spring MVC comes with AbstractJExcelView class to export data to Excel file via JExcelAPI library. In this tutorial, it show the use of AbstractJExcelView class in Spring MVC application to export data to Excel file for download

Write the jasper-view.xml configuration.

  

It is defined as follows

• Models: Models are object used as blueprints for all of the objects that will be used in the application. 
• Views: views are used to represent the presentational aspect of the information and data located in the models. 
• Controller: controller are act as both of the models as well as views. They serve as a connection between the models and views.

public class Collage { private String rollNo; private String name; public String getRollNo() { return rollNo; } public void setRollNo(String rollNo) { this.rollNo = rollNo; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
Step 2. Create View.
CollageView.java
public class CollageView { public void printCollageDetails(String CollageName, String CollageRollNo){ System.out.println("Collage: "); System.out.println("Name: " + CollageName); System.out.println("Roll No: " + CollageRollNo); } }
Step 3. Create Controller.
CollageController.java
public class CollageController { private Collage model; private CollageView view; public CollageController(Collage model, CollageView view){ this.model = model; this.view = view; } public void setCollageName(String name){ model.setName(name); } public String getCollageName(){ return model.getName(); } public void setCollageRollNo(String rollNo){ model.setRollNo(rollNo); } public String getCollageRollNo(){ return model.getRollNo(); } public void updateView(){ view.printCollageDetails(model.getName(), model.getRollNo()); } }
Step 4. Use the CollageController methods to demonstrate MVC design pattern usage.
MVCPatternDemo.java
public static void main(String[] args) { //fetch Collage record based on his roll no from the database Collage model = retriveCollageFromDatabase(); //Create a view : to write Collage details on console CollageView view = new CollageView(); CollageController controller = new CollageController(model, view); controller.updateView(); //update model data controller.setCollageName("Manoj"); controller.updateView(); } private static Collage retriveCollageFromDatabase(){ Collage Collage = new Collage(); Collage.setName("ABCD"); Collage.setRollNo("20"); return Collage; } }