English
  1. Products
  2.   Aspose.Total
  3.   Java
  4.   Metadata
  5.   Xlsx

View or Update XLSX Metadata Online or Update via Java

Develop powerful Java based XLSX document metadata management utility application. Code listed for adding and modifying XLSX file metadata through Java.

XLSX Metadata via C# .NET XLSX Metadata via C++ XLSX Metadata in Android Apps

Download

View or Update XLSX Metadata Online

  1. Import XLSX file by uploading it.
  2. Do it by clicking inside the drop area via drag and drop of metadata app.
  3. Depending on the size of XLSX file and internet speed wait for few seconds.
  4. Same page will display metadata.
  5. Edit the properties as of your choice.
  6. Save the document.
  7. Download the file instantly.

Manage XLSX Properties via Java

  1. Add Java library reference into project
  2. Load XLSX file using Workbook class.
  3. Get all custom properties via getBuiltInDocumentProperties()
  4. Use relevant set method to update a property such as setLanguage
  5. Call the save() method to save the updated XLSX document.
 

Java Code: Update XLSX Metadata

//Create workbook object.
Workbook wb = new Workbook();
//Access system defined document property collection.
BuiltInDocumentPropertyCollection sdpc = wb.getBuiltInDocumentProperties();
//Set the language of the Excel file.
sdpc.setLanguage("German, French");
//Save the workbook.
wb.save(outputDir + "updated-builtin-document-properties.xlsx", SaveFormat.XLSX);
view raw update-system-defined-properties.java hosted with ❤ by GitHub
 
 

Java Code: Add XLSX Custom Properties

// Instantiate a Workbook object
// Open an Excel file
Workbook wkb = new Workbook(dataDir + "sample.xlsx");
// Retrieve a list of all custom document properties of the Excel file
CustomDocumentPropertyCollection customProperties = wkb.getWorksheets().getCustomDocumentProperties();
// Adding a custom document property to the Excel file
DocumentProperty publisher = customProperties.add("Publisher", "Aspose");
// Add link to content.
customProperties.addLinkToContent("Owner", "MyRange");
// Accessing the custom document property by using the property name
DocumentProperty customProperty1 = customProperties.get("Owner");
// Check whether the property is lined to content
Boolean islinkedtocontent = customProperty1.isLinkedToContent();
// Get the source for the property
String source = customProperty1.getSource();
// save the workbook
view raw add-custom-properties.java hosted with ❤ by GitHub
 
 

Develop XLSX Metadata Management Application via Java

Need to develop a XLSX Metadata management 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 metadata application. Powerful Java library allows programming any document metadata solution. Moreover it can support many popular formats including XLSX format.

Java Utility to Manage XLSX Metadata

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 metadata 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 metadata app work only on Windows?
    You have the flexibility to initiate document metadata management 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 XLSX document properties?
    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 XLSX document properties management. However, if you're developing a desktop application, we recommend using the Aspose.Total document processing API for efficient management.

Explore File Metadata Options with Java

DOC Files Metadata (Microsoft Word Binary Format)
DOCM Files Metadata (Microsoft Word 2007 Marco File)
DOCX Files Metadata (Office 2007+ Word Document)
DOT Files Metadata (Microsoft Word Template Files)
DOTX Files Metadata (Microsoft Word Template File)
Excel Files Metadata
ODP Files Metadata (OpenDocument Presentation Format)
ODS Files Metadata (OpenDocument Spreadsheet)
ODT Files Metadata (OpenDocument Text File Format)
PDF Files Metadata (Portable Document Format)
Powerpoint Files Metadata
PPT Files Metadata (PowerPoint Presentation)
PPTX Files Metadata (Open XML presentation Format)
RTF Files Metadata (Rich Text Format)
Word Files Metadata
XLS Files Metadata (Microsoft Excel Binary Format)
XLSB Files Metadata (Excel Binary Workbook)
XLSM Files Metadata (Macro-enabled Spreadsheet)
XLSX Files Metadata (Open XML Workbook)