IXLSExtractor Interface
 Free Trial Web API version Licensing Request A Quote
HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM
 Defines XLS extractor interface.
Namespace:Bytescout.PDFExtractorAssembly: Bytescout.PDFExtractor (in Bytescout.PDFExtractor.dll) Version: 13.4.0.4760-master
Syntax
The IXLSExtractor type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
| AllowStandalonePunctuation |  Gets or sets whether to allow standalone punctuation characters. If false they will be merged with nearest text object.  | |
| AutoDetectNumbers |  Automatically detect numbers to represent properly (as numbers) in cells in XLS and XLSX output.  | |
| CustomColumnWidths |  Sets custom column widths for generated Excel spreadsheet.  | |
| DetectStrikeoutTextStyle |  Get or sets whether to detect the "strikeout" text style. Default is false.  | |
| DetectUnderlineTextStyle |  Get or sets whether to detect the "underline" text style. Default is false.  | |
| NumberDecimalSeparator |  Number decimal separator.  | |
| NumberGroupSeparator |  Number group separator.  | |
| OutputFormat |  Gets or sets the output format (XLS or XLSX).  | |
| PageSeparator |  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.  | |
| PageToWorksheet |  Gets or sets whether to create separate worksheet for each page of PDF document.  | |
| RichTextFormatting |  Enables/disables rich text formatting inside cells.  | 
Methods
| Name | Description | |
|---|---|---|
| GetPageXLSAsVariant |  Returns Excel data as array of bytes. This is COM/ActiveX-compatible version of the method SavePageToXLSStream(Int32, Stream) for in-memory processing of PDF documents or images.  | |
| GetXLSAsVariant |  Returns Excel data as array of bytes. This is COM/ActiveX-compatible version of the method SaveToXLSStream(Stream) for in-memory processing of PDF documents or images.  | |
| GetXLSAsVariant(String) |  Returns Excel data as array of bytes. This is COM/ActiveX-compatible version of the method SaveToXLSStream(String, Stream) for in-memory processing of PDF documents or images.  | |
| GetXLSAsVariant(Int32, Int32) |  Returns Excel data as array of bytes. This is COM/ActiveX-compatible version of the method SaveToXLSStream(Int32, Int32, Stream) for in-memory processing of PDF documents or images.  | |
| SavePageToXLSFile |  Saves document page text to Excel file. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SavePageToXLSStream |  Saves document page text as Excel spreadsheet to stream. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSFile(String) |  Saves document text as Excel file. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSFile(IListInt32, String) |  Saves data from specified pages as Excel file. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSFile(String, String) |  Saves data from specified page ranges as Excel file. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSFile(Int32, Int32, String) |  Saves data from specified page range as Excel file. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSStream(Stream) |  Saves document text as Excel spreadsheet to stream. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSStream(IListInt32, Stream) |  Saves data from specified pages as Excel spreadsheet to stream. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSStream(String, Stream) |  Saves data from specified page ranges as Excel spreadsheet to stream. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | |
| SaveToXLSStream(Int32, Int32, Stream) |  Saves data from specified page range as Excel spreadsheet to stream. The spreadsheet format (XLS/XLSX) is defined by OutputFormat property.  | 
See Also