Types of data that can be extracted from Microsoft Excel
You can use the Excel stage to extract several types of data from a Microsoft Excel file.
- File properties
- The following table lists the information that can be extracted
as file properties:
Table 1. Data that can be extracted as file properties Data Description File name Name of the file. For example: Workbook1.xls File path Path of the file. For example: C:\excel\Workbook1.xls File size Size of the file in bytes. Last modified date The date and time that the file was last modified.
- Document properties
- The following table lists the information that can be extracted
as document properties:
Table 2. Data that can be extracted as document properties Data Description Authors Authors of the document. Document comments Comments of the document. Content creation date The date and time that the document was created. Key words Key words of the document. Revision number Revision number of the document. Subject Subject of the document. Title Title of the document. Company Company property value of the document. Category Category of the document. Manager Manager of the document. Custom properties Custom properties of the document. You must specify the name of the custom property to extract.
- Sheet information
- The following table lists the information that can be extracted
as sheet information:
Table 3. Data that can be extracted as sheet information Data Description Sheet name Name of the Microsoft Excel sheet. Header (left, center, right) Header of the specified position. Footer (left, center, right) Footer of the specified position.
- Row information
- The following table lists the information that can be extracted
as row information:
Table 4. Data that can be extracted as row information Data Description Row number Microsoft Excel row number within the sheet. The first row number is 1. Is hidden Whether the row is hidden or not. Writes true if the row or the sheet to which this row belongs is hidden.
- Cell information
- You can extract the cell information based on the Microsoft Excel column or the cell position. You can specify the source Microsoft Excel column based on the relative position within the data range when extracting the cell information based on the Microsoft Excel column.