Link Search Menu Expand Document

XLSExtractor Properties

The XLSExtractor type exposes the following members.

Properties
NameDescription
Public propertyAllowStandalonePunctuation
Gets or sets whether to allow standalone punctuation characters. If false they will be merged with nearest text object.
Public propertyAutoAlignColumnsToHeader
Sets whether to align text in the columns to the header.
(Inherited from BaseTextExtractor.)
Public propertyAutoDetectNumbers
Automatically detect numbers to represent properly (as numbers) in cells in XLS and XLSX output.
Public propertyCheckPermissions
Defines whether to respect permissions set by document owner. If True, extractor throws exception when the extraction is prohibited. IMPORTANT: THIS OPTION HAVE TO BE ENABLED AND SET TO "TRUE" TO RESPECT OWNERS OF PDF DOCUMENTS. IF YOU SET IT TO FALSE TO IGNORE PERMISSIONS WHICH ARE SET IN PDF DOCUMENT THEN YOU ARE SOLELY LIABLE FOR THIS ACTION AND ANY COPYRIGHT OR OTHER VIOLATIONS AT YOUR OWN RISK. BYTESCOUT IS NOT LIABLE FOR ANY DAMAGES, LOSSES, COPYRIGHT INFRINGEMENTS OR ANY OTHER CONSEQUENCES CAUSED BY IGNORING PERMISSIONS OF PDF DOCUMENT. BY CHANGING THIS OPTION YOU ARE CONFIRMING YOU ARE UNDERSTANDING ALL WRITTEN ABOVE AND DOING IT AT YOUR OWN RISK.
(Inherited from BaseExtractor.)
Public propertyColumnDetectionByTextAlignment
Suggests the extractor the visual text alignment in table cells. It helps to detect columns when tables don't have vertical separating lines between columns and the columns are formed by text alignment.
(Inherited from BaseTextExtractor.)
Public propertyColumnDetectionMode
Sets how columns are detected. Default is 'ContentGroupsAndBorders' - columns are detected by grouping of text objects and by vertical vector lines.
(Inherited from BaseTextExtractor.)
Public propertyComHelpers
Set of utility functions and properties to use from COM/ActiveX.
(Inherited from BaseExtractor.)
Public propertyConsiderBackgroundColors
Consider background colors under text objects when detecting table structure. It can be useful for striped tables, but may degrade extraction quality on scanned documents because of uneven image background. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyConsiderFontColors
Consider font colors in document text when detecting table structure. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyConsiderFontNames
Consider font names in document text when detecting table structure. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyConsiderFontSizes
Consider font sizes in document text when detecting table structure. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyConsiderHorizontalBorders
Consider horizontal borders between text objects when detecting table structure and merging objects. Default is true.
(Inherited from BaseTextExtractor.)
Public propertyConsiderVerticalBorders
Consider vertical borders between text objects when detecting table structure and merging objects. Default is true.
(Inherited from BaseTextExtractor.)
Public propertyContentType
Returns content type of PDF document: normal document, portfolio or XFA form. To extract files from PDF portfolio use AttachmentExtractor class. To extract XFA form content use XFAFormExtractor class.
(Inherited from BaseExtractor.)
Public propertyCustomColumnWidths
Sets custom column widths for generated Excel spreadsheet.
Public propertyCustomExtractionColumns
Allows to override automatic columns detection with custom columns coordinates.
(Inherited from BaseTextExtractor.)
Public propertyDetectLinesInsteadOfParagraphsObsolete.
Lines detection option. Obsolete: Use LineGroupingMode instead.
(Inherited from BaseTextExtractor.)
Public propertyDetectNewColumnBySpacesRatio
Space ratio between words. Large spacing is treated as column separator. Using this parameter you can control the column detection.
(Inherited from BaseTextExtractor.)
Public propertyDetectStrikeoutTextStyle
Get or sets whether to detect the "strikeout" text style. Default is false.
Public propertyDetectUnderlineTextStyle
Get or sets whether to detect the "underline" text style. Default is false.
Public propertyEmbeddedFileCountObsolete.
Property is disabled to speed up the document loading. Use AttachmentExtractor to work with attachments.
(Inherited from BaseExtractor.)
Public propertyEnableTextAnalysis
Enables or disables extracted text analysis. Check TextAnalysisResults after the extraction for analysis results.
(Inherited from BaseTextExtractor.)
Public propertyEncrypted
Gets whether the document is encrypted.
(Inherited from BaseExtractor.)
Public propertyExtractAnnotations
Sets whether to extract text from annotation objects. Default is true.
(Inherited from BaseTextExtractor.)
Public propertyExtractColumnByColumn
Sets whether we should reconstruct table structure or extract text objects as they go in the PDF document stream. Default is true.
(Inherited from BaseTextExtractor.)
Public propertyExtractInvisibleText
Sets whether to extract invisible text from a PDF document.
(Inherited from BaseTextExtractor.)
Public propertyExtractionArea
Sets the extraction area by coordinates and dimensions (left, top, width, height).
(Inherited from BaseExtractor.)
Public propertyExtractionAreaRect
Sets the extraction area by rectangle.
(Inherited from BaseExtractor.)
Public propertyExtractionAreaUsageMode
Gets or sets how to use the ExtractionArea: whether to extract any object intersecting with the area or only objects completely located inside the area.
(Inherited from BaseExtractor.)
Public propertyExtractionColumns
Contains columns detected from last processed document page.
(Inherited from BaseTextExtractor.)
Public propertyExtractShadowLikeText
Sets whether to extract shadow-like text from a PDF document (when the same text is drawn twice with small offset). Default is 'true' - includes all decoded text, regardless of its appearance.
(Inherited from BaseTextExtractor.)
Public propertyIsDocumentLoaded
Get the document loaded state.
(Inherited from BaseExtractor.)
Public propertyLicenseInfo
Gets license information.
(Inherited from BaseExtractor.)
Public propertyLineGroupingMode
Sets how lines are grouped into paragraphs. Default is None (no line grouping is performed).
(Inherited from BaseTextExtractor.)
Public propertyNormalizeText
Set whether the extracted text should be normalized. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyNumberDecimalSeparator
Number decimal separator.
Public propertyNumberGroupSeparator
Number group separator.
Public propertyOCRAutoModeMinExistingTextLength
Applies to OCRMode.Auto only. Sets the minimal total length of normal text objects on the current page to decide whether to perform OCR or not. If the length of the text is less than this value then extractor will use OCR for this page. Otherwise it extracts the existing normal text objects only.
(Inherited from BaseTextExtractor.)
Public propertyOCRBlackList
A set of characters not allowed to be recognized from scanned document. The resulting text will only contain characters that are not in this list. This helps improve uncertain recognition.
(Inherited from BaseTextExtractor.)
Public propertyOCRCacheMode
Sets caching of OCR results. Default is Off (no caching). In WholePage caching mode you can save processing time as the SDK will check if need to re-run OCR on the page or it can just pull results from previously cached OCR results.
(Inherited from BaseTextExtractor.)
Public propertyOCRCorrections
A set of corrections automatically applied to recognized text to fix repeating recognition errors.
(Inherited from BaseTextExtractor.)
Public propertyOCRDetectLines
Sets whether to detect horizontal and vertical lines during OCR. They help to detect the table structure in scanned documents. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyOCRDetectPageRotation
Sets whether to detect scanned page rotation. Slightly slows down the processing.
(Inherited from BaseTextExtractor.)
Public propertyOCRDisableAutoSegmentation
Sets whether to disable the automatic segmentation. All pages will be treated as containing sparse text (as a typical document such as an invoice).
(Inherited from BaseTextExtractor.)
Public propertyOCRImagePreprocessingFilters
A set of corrections automatically applied to recognized text to fix repeating recognition errors.
(Inherited from BaseTextExtractor.)
Public propertyOCRLanguage
Language of OCR (Optical Character Recognition). The valid values are:
  • "eng" - English (default)
  • "deu" - German
  • "fra" - French
  • "spa" - Spanish

Download more languages at https://github.com/bytescout/ocrdata.

(Inherited from BaseTextExtractor.)
Public propertyOCRLanguageDataFolder
Folder containing OCR language data files.
(Inherited from BaseTextExtractor.)
Public propertyOCRMaximizeCPUUtilization
Gets or sets maximum OCR performance using Intel OpenMP (if available) to accelerate to approximately 30%. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyOCRMode
Enables use of the OCR (Optical Character Recognition) which allows you to recognize text from images embedded in PDF pages. Set the language using the OCRLanguage property.

This option requires Bytescout.PDFExtractor.OCRExtension.dll assembly reference and relevant language files in OCRLanguageDataFolder folder. The SDK is shipped with language files for English, French, German and Spanish. You can download more languages at https://github.com/bytescout/ocrdata.

(Inherited from BaseTextExtractor.)
Public propertyOCROverallConfidence
Gets overall OCR confidence. This value is calculated after the extraction is performed.
(Inherited from BaseTextExtractor.)
Public propertyOCRPageCount
Gets count of processed pages for which OCR was performed. This value is calculated after the extraction is finished.
(Inherited from BaseTextExtractor.)
Public propertyOCRResolution
Resolution of OCR (Optical Character Recognition). Default is 300 DPI.
(Inherited from BaseTextExtractor.)
Public propertyOCRWhiteList
A set of characters allowed to be recognized from scanned document. Only characters from this list will appear in the result text. This helps improve uncertain recognition.
(Inherited from BaseTextExtractor.)
Public propertyOutputFormat
Gets or sets the output format (XLS or XLSX).
Public propertyPageDataCaching
Controls page data caching behavior.
(Inherited from BaseExtractor.)
Public propertyPageSeparator
Sets the page separator. If not empty and PageToWorksheet is False, the extractor will insert between pages in the generated Excel data a row that will contain specified text in the first column.
Public propertyPageToWorksheet
Gets or sets whether to create separate worksheet for each page of PDF document.
Public propertyPassword
PDF document password.
(Inherited from BaseExtractor.)
Public propertyPreserveFormattingOnTextExtraction
Sets whether to preserve the text formatting on the extraction.
(Inherited from BaseTextExtractor.)
Public propertyProfiles
Comma-separated list of profiles to apply to the extractor. Profiles must be previously loaded.
(Inherited from BaseExtractor.)
Public propertyRegistrationKey
Registration key.
(Inherited from BaseExtractor.)
Public propertyRegistrationName
Registration name.
(Inherited from BaseExtractor.)
Public propertyRemoveHyphenation
Sets whether to automatically remove hyphenations in end of lines (works when is true).
(Inherited from BaseTextExtractor.)
Public propertyRichTextFormatting
Enables/disables rich text formatting inside cells.
Public propertyRotationAngle
Sets whether to rotate document pages to specified angle before the extraction.
(Inherited from BaseTextExtractor.)
Public propertyRTLTextAutoDetectionEnabled
Enables RTL (Right-To-Left) text auto detection. Default is true.
(Inherited from BaseTextExtractor.)
Public propertyShrinkMultipleSpaces
Replaces multiple spaces in text objects with a single space. Multiple spaces affect column detection, so removing them may improve the result. Default is false.
(Inherited from BaseTextExtractor.)
Public propertyTableXMinIntersectionRequiredInPercents
During the reconstruction of table structure, sets how much of the cell rectangle should intersect (by X coordinate axis) with the previous cell to treat both cells belong to the same row.
(Inherited from BaseTextExtractor.)
Public propertyTableYMinIntersectionRequiredInPercents
During the reconstruction of table structure, sets how much of the cell rectangle should intersect (by Y coordinate axis) with the previous cell to treat both cells belong to the same column.
(Inherited from BaseTextExtractor.)
Public propertyTextAnalysisCorruptedTextThreshold
The criterion of detection of the corrupted text used in text analysis. Default is 0.5.
(Inherited from BaseTextExtractor.)
Public propertyTextAnalysisResults
Results of the text analysis. Enable the analysis using EnableTextAnalysis property.
(Inherited from BaseTextExtractor.)
Public propertyTextEncodingCodePage
Sets the default text encoding. Default encoding is "iso-8859-1".
(Inherited from BaseTextExtractor.)
Public propertyTrimSpaces
Sets whether to remove trailing and ending spaces from the text of table cells. Default is true.
(Inherited from BaseTextExtractor.)
Public propertyUnwrap
Sets whether to unwrap the contents of a multiline table cell into a single line. Default is true.
(Inherited from BaseTextExtractor.)
Public propertyVersion
Gets the component version number.
(Inherited from BaseExtractor.)
Public propertyXCoordinateToleranceFactor
Sets X coordinate tolerance to use when constructing table structure of PDF page.
(Inherited from BaseTextExtractor.)
Public propertyYCoordinateToleranceFactor
Sets Y coordinate tolerance to use when constructing table structure of PDF page.
(Inherited from BaseTextExtractor.)
Top
See Also

Reference