English
  1. Products
  2.   Aspose.Total
  3.   Android via Java
  4.   Metadata
  5.   Xlsm

View or Update XLSM Metadata Online or Update via Android Apps

Develop powerful android based XLSM document metadata management utility application. Code listed for adding and modifying XLSM file metadata.

XLSM Metadata via C# .NET XLSM Metadata via Java XLSM Metadata via C++

Download

View or Update XLSM Metadata Online

  1. Import XLSM 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 XLSM 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 XLSM Properties via Android App

  1. Add android library reference into project
  2. Load XLSM 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 XLSM document.
 

Code: Update XLSM 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
 
 

Code: Add XLSM 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 XLSM Metadata Management Android App

Need to develop a XLSM Metadata management mobile app or utility? With Aspose.Cells for Android via Java a child API of Aspose.Total for Android via Java , any android developer can integrate the above API code within its document metadata application. Powerful android library allows programming any document metadata solution. Moreover it can support many popular formats including XLSM format.

Android Utility to Manage XLSM Metadata

System Requirements

  • Android OS 2.0 or above.
  • Java package is cross-platform and runs on all operating systems with JVM implementation.

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

Explore File Metadata Options with Android

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)