GroupDocs.Metadata for Java provides functionality that allows working with different kinds of Spreadsheet formats such as XLS, XLSX, ODS, etc. For the full list of supported document formats please refer To Supported document formats.
Detecting the exact type of a document The following sample of code will help you To detect the exact type of a loaded Spreadsheet and extract some additional file format information.
Load a Spreadsheet document Extract the root metadata package Use the getSpreadsheetType method To obtain file format information advanced_usage....metadata in Spreadsheets Working with metadata in Spreadsheets Leave...with different kinds of spreadsheet formats such as XLS, XLSX...
GroupDocs.Conversion Product Family on GroupDocs Blog | Document AuTomation Solutions for .NET & Java Developers Recent content in GroupDocs.Conversion Product Family on GroupDocs Blog | Document A...... Convert Excel Spreadsheets to PDF in Java Convert Excel...or any cell range using spreadsheet conversion Java API. Convert...
To search a keyword in Microsoft Office Excel Spreadsheets search(String) method is used. This method returns the collection of SearchResult objects. For details, see Search Text.
Here are the steps To search a keyword in Microsoft Office Excel Spreadsheet:
Instantiate Parser object for the initial Spreadsheet; Call search(String) method and obtain the collection of SearchResult objects; Iterate through the collection and get the position and text. Warning search(String) method returns null value if search isn’t supported for the Spreadsheet....from Microsoft Office Excel spreadsheets / Search text in Microsoft...Microsoft Office Excel spreadsheets Search text in Microsoft Office...
Perform word search, replace or hide text in Word DOC/DOCX files using Java. Redact and perform text, case-sensitive & RegEx search with Java Redaction API....remove private information like email addresses or identification...supports metadata, annotation, spreadsheet, and also the images redaction...