Grooper Help - Version 25.0
25.0.0017 2,127
  • Overview
  • Help Status

Excel Document

Office Document Grooper.Office

Represents a Microsoft Excel document, enabling spreadsheet-centric processing, extraction, and integration in Grooper.

Remarks

The ExcelDocument class provides support for Microsoft Excel and related spreadsheet formats (e.g., .xls, .xlsx, .xlsm, .ods, .csv, and others) within Batch Folders. It enables Grooper to recognize, process, and extract content from Excel documents as attachments, supporting downstream extraction, conversion, and export workflows.

Overview

  • ExcelDocument is automatically selected for files with supported Excel and related extensions or MIME types.
  • Integrates with Batch Folders to enable document-centric workflows, including classification, extraction, and export of spreadsheet content.
  • Exposes key spreadsheet statistics (such as worksheet count) as viewable properties for downstream processing and review.

Excel Document Handling

  • Loads and parses Excel documents as attachments to Batch Folders.
  • Provides access to worksheet data for reporting, extraction, or workflow decisions.
  • Supports conversion of Excel documents to CSV for standardized export and downstream processing.

Available Commands

  • Convert To CSV: Converts the attached Excel document to CSV, with options for saving as child documents, files, or replacing the attachment.
    • Use for workflows requiring CSV normalization, data extraction, or downstream CSV-based processing.

Usage Notes

  • Use ExcelDocument to enable spreadsheet-aware processing in Grooper, including extraction and export of tabular data.
  • Combine with Content Type and Data Model configuration to extract structured data from Excel documents.
  • Suitable for processing financial records, reports, data exports, and other spreadsheet-based content in batch workflows.

For more information, see the documentation for Batch Folder and Attachment Type.

Properties

NameTypeDescription
General
Document
Subject String

The subject metadata property for an Office document.

Title String

The title metadata property for an Office document.

Description String

The description metadata property for an Office document.

Category String

The category metadata property for an Office document.

Content Status String

The contentStatus metadata property for an Office document.

History
Created String

The created metadata property for an Office document.

Creator String

The creator metadata property for an Office document.

Last Modified String

The modified metadata property for an Office document.

Last Modified By String

The lastModifiedBy metadata property for an Office document.

Revision String

The revision metadata property for an Office document.

Version String

The version metadata property for an Office document.

Application Info
Application Name String

The Application metadata property for an Office document.

Application Version String

The AppVersion metadata property for an Office document.

Company String

The Company metadata property for an Office document.

Context Menu Commands

Command Shortcut Description
csv Convert to CSV Converts an Excel spreadsheet to a Comma-Separated Values (CSV) file.
Notification