Wednesday 28 September 2022

How to upload password Protected Excel Using java

In the previous post, we saw how some columns were made password protected, now we will see how to upload the created file.

First of all we make brows form.

Uploading Excel

NPOIFSFileSystem class is inside the "org.apache.poi.poifs.filesystem.NPOIFSFileSystem" package Biff8EncryptionKey class is inside the "org.apache.poi.hssf.record.crypto.Biff8EncryptionKey" package

Import Jar Name is poi-3.17.jar and call Some class

import org.apache.poi.hssf.record.crypto.Biff8EncryptionKey;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.poifs.filesystem.NPOIFSFileSystem;

import org.apache.poi.ss.usermodel.DataFormatter;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

Java controlling Method is uploadFile:

@RequestMapping(value = "/uploadFile", method = RequestMethod.POST)
	public ModelAndView uploadFile(
	@ModelAttribute("SlrUploadxlsFromBean") SlrUploadxlsFromBean mvcJavaBeanObj) throws Exception {
	
                CommonsMultipartFile filePath = mvcJavaBeanObj.getFilePath();
				mvcJavaBeanObj.setFileName(filePath.getOriginalFilename());
				String FILE_PATH = contextPath.getRealPath("/WEB-INF/downloads/" + filePath.getOriginalFilename());
				byte[] bytes = filePath.getBytes();
				FileCopyUtils.copy(bytes, new File(FILE_PATH));
				String FILE_PATH2 = contextPath.getRealPath("/WEB-INF/downloads/" + mvcJavaBeanObj.getFileName());
				File fiobj = new File(FILE_PATH2);
				NPOIFSFileSystem fileSystem = new NPOIFSFileSystem(fiobj, true);
				Biff8EncryptionKey.setCurrentUserPassword("a143mk");
				Workbook crdeitdebitbook = new HSSFWorkbook(fileSystem);
				String name = crdeitdebitbook.getSheetAt(0).getSheetName();
				Sheet mySheet = crdeitdebitbook.getSheet(name);
				List<Row> rows = Lists.newArrayList(mySheet.rowIterator());
				final DataFormatter df = new DataFormatter();
				Iterator<Row> rowIterator = rows.iterator();
				System.out.println("Password_Protected_Column_1 |Password_Protected_Column_2 | EDIT_ABLE_COLUMN");
				while (rowIterator.hasNext()) {
					Row row = rowIterator.next();
					if (rowRounter == 0) {
						rowRounter++;
					} else {
					     String colum_obj1 = row.getCell(0).toString().trim();
						String colum_obj2 = row.getCell(1).toString().trim();
						String colum_obj3 = row.getCell(2).toString().trim();
					System.out.println(colum_obj1+" | "+colum_obj2+" | "+colum_obj3);
					}
					}
					
					}

Output:

Wednesday 28 September 2022

How to upload password Protected Excel Using java

No comments :

Post a Comment

OUR TECH-PROJECTS

DOWNLOAD ANY ONLINE VIDEOS

LABELS

Development Accessories

POPULAR POSTS