Thursday 22 September 2022

How to create password Protected Excel for some Column Label in java

September 22, 2022 Excel Code , java , Spring MVC 1 comment :

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.

Import Jar Name jxl-2.6.12.jar and spring-webmvc-4.3.7.RELEASE.jar and call Some classes

package dms.a143mk.excel;
import java.util.ArrayList;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.web.servlet.view.document.AbstractJExcelView;
import antlr.Utils;
import jxl.CellView;
import jxl.Sheet;
import jxl.SheetSettings;
import jxl.format.Colour;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.NumberFormats;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class PasswordProteExcelDemo extends AbstractJExcelView {
	@Override
	protected void buildExcelDocument(WritableWorkbook workbook, HttpServletRequest request, 
	HttpServletResponse response) throws Exception {
          
		  Map<Integer, ArrayList<String>> viewCustomer = new HashMap<Integer, ArrayList<String>>();
			ArrayList<String> recvReportList = new ArrayList<String>();
				recvReportList.add("a143mk");
				recvReportList.add("Programming");
				recvReportList.add("");
				viewCustomer.put(1, recvReportList);
		
		    WritableSheet sheet = null;
		    response.setHeader("content-disposition", "attachment; filename=FineName.CSV");
			sheet = workbook.createSheet("Excel_View", 0);
			sheet.getSettings().setPassword("a143mk");
			sheet.getSettings().setProtected(true);
			sheet.setColumnView(0, 30);
			sheet.setColumnView(1, 30);
			sheet.setColumnView(2, 30);
			
			
			WritableCellFormat readonly = new WritableCellFormat();
			readonly.setBackground(Colour.GRAY_25);
			readonly.setLocked(true);
			
			
			WritableCellFormat cellNumberFor = new WritableCellFormat(NumberFormats.INTEGER);
			cellNumberFor.setBackground(Colour.GRAY_25);
			cellNumberFor.setLocked(true);
		    
			WritableCellFormat unlockedresion = new WritableCellFormat();
			unlockedresion.setLocked(false);
			WritableCellFormat untpCell = new WritableCellFormat(NumberFormats.INTEGER);
			untpCell.setLocked(false);
			
			if(!viewCustomer.isEmpty()){
				sheet.addCell(new Label(0, 0, "Password_Protected_Column_1",readonly));	
				sheet.addCell(new Label(1, 0, "Password_Protected_Column_2",readonly));
			    sheet.addCell(new Label(3, 0, "EDIT_ABLE_COLUMN",unlockedresion));
            	int rowCount = 1;
				for (Map.Entry<Integer, ArrayList<String>> entry : viewCustomer.entrySet()) {
					
					sheet.addCell(new Label(0, rowCount,  entry.getValue().get(0),readonly));
					sheet.addCell(new Label(1, rowCount,  entry.getValue().get(1),readonly));
					sheet.addCell(new Label(2, rowCount,  entry.getValue().get(2),unlockedresion));
						
					rowCount++;
				}
			}
		
	}

}

Thursday 22 September 2022

How to create password Protected Excel for some Column Label in java

1 comment :

OUR TECH-PROJECTS

DOWNLOAD ANY ONLINE VIDEOS

LABELS

Development Accessories

POPULAR POSTS