English
  1. Products
  2.   Aspose.Total
  3.   Python via Java
  4.   Metadata
  5.   Excel

View or Update EXCEL Metadata Online or via Python

Develop powerful Python based EXCEL document metadata management utility application. Code listed for adding, deleting and viewing EXCEL file metadata through Python.

EXCEL Metadata via C# .NET EXCEL Metadata via Java EXCEL Metadata via C++ EXCEL Metadata in Android Apps

Download

View or Update EXCEL Metadata Online

  1. Import EXCEL 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 EXCEL 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 EXCEL Properties via Python

  1. Reference APIs within the project directly from PyPI ( Aspose.Cells ).
  2. Load EXCEL file using Workbook class.
  3. Get all custom properties via getWorksheets().getCustomDocumentProperties().
  4. Use get(index) method to get the property value.
  5. Use add() method to add more properties.
  6. Use remove() method to remove a property.
  7. Call the save() method to save the updated EXCEL document.
 

Python Code: View, Add and Remove EXCEL Metadata

 
 

Develop EXCEL Metadata Management Application via Python

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

Python Utility to Manage EXCEL Metadata

There are alternative options to install “ Aspose.Cells for Python via Java ” or “ Aspose.Total for Python via Java ” onto your system. Please choose one that resembles your needs and follow the step-by-step instructions:

System Requirements

  • Python 3.5 or later is installed
  • Java 1.8 or higher.



For more details please refer to Product Documentation .

FAQs

  • Can I use above Python code in my application?
    Yes, you are welcome to download this code and utilize it for the purpose of developing Python-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 EXCEL 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 EXCEL 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 Python

EXCEL Files Metadata (Spreadsheet File Formats)
ODS Files Metadata (OpenDocument Spreadsheet)
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)

What is EXCEL File Format?

Microsoft Excel is a widely used spreadsheet software known for its ability to save and share data in various file formats. The different file formats supported by Excel offer flexibility and compatibility with other software applications.

The default file format in Excel is XLS, while the newer and more efficient XLSX format has gained popularity. XLSX files have advantages such as smaller file sizes, improved data recovery, and better compatibility with other programs.

For simpler data exchange, Excel supports CSV (Comma-Separated Values) and TXT (Plain Text) formats. CSV files use commas to separate data, making them easily readable by different applications. TXT files store plain text data without any formatting.

To preserve formatting and layout when sharing data, Excel allows saving files in the PDF (Portable Document Format) format. PDF files are widely used for publishing Excel data while retaining its visual presentation.

For collaborative projects, Excel offers the ODS (OpenDocument Spreadsheet) format, which is open-source and compatible with various software applications.

DBF (dBASE File) is a less commonly used format in Excel, but it is advantageous for handling large datasets and is compatible with dBASE software.

Excel also supports formats like XLT (Excel Template), XLTX (Excel Open XML Template), XLTM (Excel Macro-Enabled Template), and XML (eXtensible Markup Language) for template usage or data exchange between different software applications.