Shulou(Shulou.com)06/02 Report--

Editor to share with you how Java encrypts / decrypts Excel, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Tools

Tool: Free Spire.XLS for Java (free version)

Note 1: you can download the jar package through the official website, decompress and import the jar file in the lib folder into the java program, or download and install it through the maven warehouse.

Jar import effect:

Note 2: when setting up worksheet protection here, you can support many different types of protection (as shown in the following figure). This example takes the selection of one of them as an example.

Java code example

[example 1] encrypt the workbook

Import com.spire.xls.*; public class ProtectWb {public static void main (String [] args) {/ / load test document Workbook wb = new Workbook (); wb.loadFromFile ("sample.xlsx"); / / encrypt workbook wb.protect ("123456") with password; / / Save document wb.saveToFile ("ProtectWorkbook.xlsx", ExcelVersion.Version2010) Wb.dispose ();}}

Workbook encryption results:

[example 2] decrypt the workbook

Import com.spire.xls.*; public class UnprotectWb {public static void main (String [] args) {/ / load document Workbook wb = new Workbook (); wb.setOpenPassword ("123456"); / / Source document password wb.loadFromFile ("ProtectWorkbook.xlsx"); / / unprotect wb.unProtect () / / Save document wb.saveToFile ("UnprotectWb.xlsx"); wb.dispose ();}}

Run the program and the generated workbook files will no longer be password protected.

[example 3] encrypt worksheet

Import com.spire.xls.*; import java.util.EnumSet; public class ProtectSheet {public static void main (String [] args) {/ / load the test document Workbook wb = new Workbook (); wb.loadFromFile ("sample.xlsx"); / / get the first worksheet Worksheet sheet = wb.getWorksheets () .get (0) / / protect sheet.protect ("654321", EnumSet.of (SheetProtectionType.All)) with password encryption; / / Save document wb.saveToFile ("ProtectWorksheet.xlsx", ExcelVersion.Version2010); wb.dispose ();}}

Worksheet encryption result:

[example 4] encrypt worksheet to specify data range

Import com.spire.xls.*; import java.util.EnumSet; public class ProtectRange {public static void main (String [] args) {/ / load the test document Workbook wb = new Workbook (); wb.loadFromFile ("sample.xlsx"); / / get the first worksheet Worksheet sheet = wb.getWorksheets () .get (0) / / password encryption worksheet sheet.protect ("123654", EnumSet.of (SheetProtectionType.All)); / / specify editable region sheet.addAllowEditRange ("AllowEdit", sheet.getCellRange (3meme 1, 11)); / / Save document wb.saveToFile ("ProtectRange.xlsx", ExcelVersion.Version2010); wb.dispose ();}}

The encryption result of the specified area:

[example 5] set worksheet formula hiding

Import com.spire.xls.*; import java.util.EnumSet; public class ProtectAndHideFormula {public static void main (String [] args) {/ / load document Workbook wb = new Workbook (); wb.loadFromFile ("sample.xlsx"); / / get worksheet Worksheet sheet = wb.getWorksheets () .get (0) / / set encryption sheet.protect ("123", EnumSet.of (SheetProtectionType.All)); / / hide formula sheet.getAllocatedRange () .isFormulaHidden (true); / / Save document wb.saveToFile (" HideFormula.xlsx ", FileFormat.Version2010); wb.dispose ();}}

Set the formula to hide the results:

[example 6] decrypt the Excel worksheet

Import com.spire.xls.*; public class UnprotectSheet {public static void main (String [] args) {/ / load document Workbook wb = new Workbook (); wb.loadFromFile ("ProtectWorksheet.xlsx"); / / get worksheet Worksheet sheet = wb.getWorksheets () .get (0); / / unprotect (password required for source document) sheet.unprotect ("654321") / / Save document wb.saveToFile ("UnprotectSheet.xlsx", ExcelVersion.Version2010); wb.dispose ();}}

Run the program and the specified worksheet will no longer be protected in the generated document.

The above is all the contents of the article "how Java encrypts / decrypts Excel". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.