Aspose.Cells FOSS
Java
Extract XML

How to Extract XML from XLSX in Java

Overview

This guide shows how to inspect and diagnose XLSX package contents using Aspose.Cells FOSS for Java. XLSX files are ZIP archives; you can verify AutoFilter elements, cell data, and structural parts using the Workbook.getLoadDiagnostics() API or standard Java ZIP utilities.

Using LoadOptions and Diagnostics

Load a file and inspect repair issues that reveal internal XML structure:

import com.aspose.cells_foss.LoadIssue;
import com.aspose.cells_foss.LoadOptions;
import com.aspose.cells_foss.Workbook;

LoadOptions options = new LoadOptions();
options.setStrictMode(false);
options.setTryRepairPackage(true);
options.setTryRepairXml(true);

try (Workbook workbook = new Workbook("input.xlsx", options)) {
    if (workbook.getLoadDiagnostics().hasRepairs()) {
        for (LoadIssue issue : workbook.getLoadDiagnostics().getIssues()) {
            System.out.println(issue.getMessage());
        }
    }
}

Inspecting Cell Values After Load

After loading the saved file, read back cell values by name to verify that typed values were preserved through the XLSX round-trip:

import com.aspose.cells_foss.Workbook;
import com.aspose.cells_foss.Worksheet;

try (Workbook workbook = new Workbook("input.xlsx")) {
    WorksheetCollection sheets = workbook.getWorksheets();
    Worksheet sheet = sheets.get(0);
    System.out.println(sheet.getCells().get("A1").getStringValue());
}

See Also

 English