Welcome to our comprehensive guide on how to view, edit, and remove Excel metadata using both an online tool and coding solutions with Aspose.Cells. Whether you’re a casual user looking for a quick Excel Metadata Viewer or a developer seeking a robust Excel Metadata Editor, this guide has you covered. You can choose to use a straightforward online converter for immediate results or automate the process through programming for greater efficiency. Let’s dive in!
Online Excel Metadata Viewer & Editor
For those who prefer a quick and easy solution, Aspose provides a free online tool that allows you to view and edit Excel metadata effortlessly.
- Quick & Easy: No need to install software. View, edit, and remove metadata in a few clicks.
- Privacy Protection: Ensure confidential details are not shared with recipients.
- Free & Secure: The Aspose tool offers a secure way to view, modify, and remove metadata without altering file content.
View Built-in Properties of Excel Metadata
View Built-in Properties of Excel File Metadata
View and Edit Custom Properties of Excel Metadata
View and Edit Custom Properties of Excel File Metadata
How to View and Edit Excel Metadata Online
Follow this simple step-by-step guide to view and edit Excel metadata online:
- Navigate to Aspose Metadata Viewer.
- “Drop or upload” your Excel files.
- Review the displayed metadata.
- Switch between “View Built-In Properties” or “View Custom Properties”.
- Edit the metadata fields as needed. You may also add a property as well.
- Click “Save” to save your changes. You will be automatically redirected to download the updated file.
We prioritize security by implementing advanced measures to protect your data. Our system keeps your Excel files safe and automatically deletes them after 24 hours.
How to Remove Metadata from Excel Files
Metadata in Excel files contains details such as author name, company information, and last modified date. To protect your privacy and prevent the exposure of sensitive details, removing metadata is crucial. Fortunately, you can use the Aspose.Cells Metadata Editor to easily delete metadata from Excel files online without installing any software.
Follow these simple steps to remove metadata from your Excel files:
- Open the Aspose.Cells Metadata Editor in your web browser.
- “Drop or upload” your Excel file (.XLSX or .XLS) from your device.
- After uploading, view the existing metadata fields such as author, title, subject, and company information.
- To remove metadata, simply delete the values from the respective fields or select the “Clear All” option.
- Click on the “Save” button to finalize the changes.
- Finally, download the updated file.
By following these steps, you can efficiently remove metadata from your Excel files to protect sensitive information before sharing them.
In the next section, we’ll show you how to achieve the same result using code-based solutions in C#, Java, and Python, giving you greater flexibility and automation.
Working with Excel Metadata: A Developer’s Guide
Developers often prefer a programmatic approach to viewing and editing the metadata of Excel files because it enables automation, customization, and efficient bulk processing. Aspose.Cells, a robust library supporting multiple programming languages such as C#, Java, and Python, empowers developers to seamlessly integrate metadata management into their applications. Let’s dive into viewing and editing metadata of an Excel workbook with C#, Java, and Python!
- Excel File Metadata Viewer and Editor in C#
- Working with Excel File Metadata in Java
- Working with Excel File Metadata in Python
- Get a Free License
Excel Metadata Viewer and Editor in C#
Please follow the step below to view and edit the metadata of an Excel workbook with Aspose.Cells for .NET using C#.
- Step 1: Install Aspose.Cells for .NET. Use NuGet Package Manager to install it:
Install-Package Aspose.Cells
- Step 2: Use the following C# code to view and edit the metadata of an Excel workbook.
| using Aspose.Cells; | |
| // Open Workbook metadata | |
| MetadataOptions options = new MetadataOptions(MetadataType.DocumentProperties); | |
| WorkbookMetadata meta = new WorkbookMetadata("workbook.xlsx", options); | |
| // Set some properties | |
| meta.CustomDocumentProperties.Add("Author", "Jane Doe"); | |
| // Save the metadata info | |
| meta.Save("workbook.out.xlsx"); | |
| // Open the workbook | |
| Workbook w = new Workbook("workbook.out.xlsx"); | |
| // Read document property | |
| Console.WriteLine(w.CustomDocumentProperties["Author"]); |
Working with Excel Metadata in Java
Here’s how you can work with the metadata of an Excel workbook using Aspose.Cells for Java:
- Step 1: Add Aspose.Cells for Java dependency. For Maven projects, add this dependency:
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>25.3</version>
</dependency>
- Step 2: Use the following Java code to view and edit the metadata of an Excel.
| // Open Workbook metadata | |
| MetadataOptions options = new MetadataOptions(MetadataType.DOCUMENT_PROPERTIES); | |
| WorkbookMetadata meta = new WorkbookMetadata("workbook.xlsx", options); | |
| // Set some properties | |
| meta.getCustomDocumentProperties().add("Author", "Jane Doe"); | |
| // Save the metadata info | |
| meta.save("workbook.out.xlsx"); | |
| // Open the workbook | |
| Workbook w = new Workbook("workbook.out.xlsx"); | |
| // Read document property | |
| System.out.println(w.getCustomDocumentProperties().get("Author")); |
Working with Excel Metadata in Python
To work with the metadata of an Excel in Python using Aspose.Cells for Python, follow these steps:
- Step 1: Install Aspose.Cells for Python
pip install aspose-cells
- Step 2: Use the following Python code to view and edit the metadata of an Excel workbook.
| import aspose.cells as cells | |
| # Open Workbook metadata | |
| options = cells.metadata.MetadataOptions(cells.metadata.MetadataType.DOCUMENT_PROPERTIES) | |
| meta = cells.metadata.WorkbookMetadata("workbook.xlsx", options) | |
| # Set some properties | |
| meta.custom_document_properties.add("Author", "Jane Doe") | |
| # Save the metadata info | |
| meta.save("workbook.out.xlsx") | |
| # Open the workbook | |
| workbook = cells.Workbook("workbook.out.xlsx") | |
| # Retrieve a list of all custom document properties of the Excel file | |
| customProperties = workbook.worksheets.custom_document_properties | |
| # Accessing a custom document property by using the property name | |
| print(customProperties.get("Author")) |
Get a Free License
Ready to explore the full potential of Aspose products? Visit the License page to obtain your free temporary license. It’s quick and easy, allowing you to test all the features without any limitations!
Excel File Metadata Viewer & Editor: Free Resources
In addition to viewing, editing, and removing Excel workbook metadata, we offer a wealth of resources to enhance your understanding of Aspose.Cells. Refer to our documentation, tutorials, and community forums for more insights and tips.
Conclusion
In summary, using an online Excel Metadata Viewer & Editor tool is perfect to quickly view, edit, and remove metadata without installing any software. Developers can automate metadata management in Excel with Aspose’s programmatic solutions, which support C#, Java, and Python. Now that you know how to view, edit, and remove Excel metadata, you can protect your information effortlessly. Choose the method that best suits your needs, and explore advanced features to streamline your Excel file processing.
If you have any questions or need further assistance, please feel free to reach out at our free support forum.