English
  1. Products
  2.   Aspose.Total
  3.   Java
  4.   Redact
  5.   Xls

Redact XLS Document Online or via Java

Develop powerful Java based XLS document redaction utility application. Code listed for search and replace text in XLS file using regular expression through Java.

XLS Redact via C# .NET XLS Redact via C++ XLS Redact in Android Apps

Download

Redact XLS Document Online

  1. Import XLS file by uploading it.
  2. Do it by clicking inside the drop area via drag and drop of annotation app.
  3. Depending on the size of XLS file and internet speed wait for few seconds.
  4. Type the text to search and redact
  5. Enter the replacing text to redact with
  6. Press the “REDACT” button
  7. Download the redaction file instantly.

Redact XLS File via Java

  1. Add library reference to Java project
  2. Load XLS file using Workbook class
  3. Get the relevant sheet using getWorksheets().get(index)
  4. Use FindOptions class and set the options
  5. Iterate through each cell and use putValue to update the value
  6. Save the XLS Spreadsheet
 

Java Code : Redact XLS Spreadsheet

Workbook workbook = new Workbook(dataDir + "sourceFile.xls");
Worksheet worksheet = workbook.getWorksheets().get(0);
CellArea area = CellArea.createCellArea("E3", "H6");
FindOptions opts = new FindOptions();
opts.setLookInType(LookInType.VALUES);
opts.setLookAtType(LookAtType.ENTIRE_CONTENT);
opts.setRange(area);
Cell cell = null;
do {
cell = worksheet.getCells().find("search", cell, opts);
if (cell == null)
break;
cell.putValue("replace");
} while (true);
workbook.save(dataDir + "output.xls");
view raw redact-excel-spreadsheet.java hosted with ❤ by GitHub
 
 

Develop XLS Redaction Application via Java

Need to develop a XLS redaction app or utility? With Aspose.Cells for Java a child API of Aspose.Total for Java , any Java developer can integrate the above API code within its document redaction application. Powerful Java library allows programming any spreadsheets redaction solution. Moreover it can support many popular formats including XLS format.

Java Utility to Redact XLS File

There are alternative options to install “ Aspose.Cells for Java ” or “ Aspose.Total for Java ” onto your system. Our Java package is designed to be cross-platform, compatible with JVM implementations on various operating systems such as Microsoft Windows, Linux, macOS, Android, and iOS. Please choose one that resembles your needs and follow the step-by-step instructions:

System Requirements

  • J2SE 6.0 (1.6)
  • J2SE 7.0 (1.7) or above

For details please refer to [Product Documentation](https://docs.aspose.com/cells/java/system-requirements/#optional-dependencies).

FAQs

  • Can I use above Java code in my application?
    Yes, you are welcome to download this code and utilize it for the purpose of developing Java-based document redaction application. This code can serve as a valuable resource to enhance the functionality and capabilities of your projects in the domain of backend document processing and manipulation.
  • Is this online document redaction app work only on Windows?
    You have the flexibility to initiate document redaction at any device, irrespective of the operating system it runs on, whether it be Windows, Linux, Mac OS, or Android. All that's required is a contemporary web browser and an active internet connection.
  • Is it safe to use the online app to manage XLS document redaction?
    Of course! The output files generated through our service will be securely and automatically removed from our servers within a 24-hour timeframe. As a result, the display links associated with these files will cease to be functional after this period.
  • What browser should to use App?
    You can use any modern web browser like Google Chrome, Firefox, Opera, or Safari for online XLS document redaction. However, if you're developing a desktop application, we recommend using the Aspose.Total document processing API for efficient management.

Explore File Redaction Options with Java

Redact DOC Files (Microsoft Word Binary Format)
Redact DOCX Files (Office 2007+ Word Document)
Redact Excel Files
Redact ODP Files (OpenDocument Presentation Format)
Redact ODS Files (OpenDocument Spreadsheet)
Redact ODT Files (OpenDocument Text File Format)
Redact PDF Files (Portable Document Format)
Redact Powerpoint Files
Redact PPT Files (PowerPoint Presentation)
Redact PPTX Files (Open XML presentation Format)
Redact Word Files
Redact XLS Files (Microsoft Excel Binary Format)
Redact XLSX Files (Open XML Workbook)