Click or drag to resize
XLSDocument Class
A class that represents a XLSX document
Inheritance Hierarchy
SystemObject
  RasterEdge.Imaging.BasicBaseDocument
    RasterEdge.XDoc.ExcelXLSDocument

Namespace: RasterEdge.XDoc.Excel
Assembly: RasterEdge.XDoc.Excel (in RasterEdge.XDoc.Excel.dll) Version: 9.8.7.60526 (9.8.7.60526)
Syntax
public class XLSDocument : BaseDocument

The XLSDocument type exposes the following members.

Constructors
  NameDescription
Public methodXLSDocument(Byte)
Create a XLS document from a .xls bytes data
Public methodXLSDocument(Stream)
Create a XLS document from a .xls stream
Public methodXLSDocument(String)
Create a XLS document from a .xls file
Public methodXLSDocument(BaseImage)
Create a new XLS document, unsupported
Public methodXLSDocument(String, Boolean)
Create a new XLS document, unsupported
Public methodXLSDocument(String, Single, Single)
this is for file import, and get windows show width and height;
Top
Methods
  NameDescription
Public methodAddPage (Overrides BaseDocumentAddPage(BasePage).)
Public methodAddPages (Overrides BaseDocumentAddPages(BasePage).)
Public methodAppendDocument
append two documents
(Overrides BaseDocumentAppendDocument(BaseDocument).)
Public methodBurnAnnotation (Overrides BaseDocumentBurnAnnotation.)
Public methodClone
clone one page
(Overrides BaseDocumentClone.)
Public methodStatic memberCombineDocument(Stream, Stream)
Combine some documents to a document,now just support the sheet string combine;
Public methodStatic memberCombineDocument(Stream, String)
Combine some documents to a document,now just support the sheet string combine;
Public methodStatic memberCombineDocument(String, Stream)
Combine some documents to a document,now just support the sheet string combine;
Public methodStatic memberCombineDocument(String, String)
Combine some documents to a document,now just support the sheet string combine;
Public methodStatic memberCombineDocument(Stream, Stream, Int32, Int32)
//非顺序合并,just use for two documents
Public methodConvertToDocument(DocumentType, Stream)
convert the file to target type document and saved in the stream.
(Overrides BaseDocumentConvertToDocument(DocumentType, Stream).)
Public methodConvertToDocument(DocumentType, String)
convert the file to the target type document and saved in the fixed file path
(Overrides BaseDocumentConvertToDocument(DocumentType, String).)
Public methodConvertToDocument(DocumentType, ImageCompress, Stream) (Overrides BaseDocumentConvertToDocument(DocumentType, ImageCompress, Stream).)
Public methodConvertToDocument(DocumentType, ImageCompress, String)
Converts document to the target file format and saves it to a file on the local disk. Throw an exception in condition: 1: the target document type has not been developed yet. 2: the required assembly has not been added.
(Overrides BaseDocumentConvertToDocument(DocumentType, ImageCompress, String).)
Public methodConvertToDocument(DocumentType, Int32, Stream) (Overrides BaseDocumentConvertToDocument(DocumentType, Int32, Stream).)
Public methodConvertToDocument(DocumentType, Int32, String) (Overrides BaseDocumentConvertToDocument(DocumentType, Int32, String).)
Public methodConvertToDocument(DocumentType, Stream, ImageOutputOption) (Overrides BaseDocumentConvertToDocument(DocumentType, Stream, ImageOutputOption).)
Public methodConvertToDocument(DocumentType, Single, Stream) (Overrides BaseDocumentConvertToDocument(DocumentType, Single, Stream).)
Public methodConvertToDocument(DocumentType, Single, String)
Converts document to the target file format with with sepcified zoom value and saves it to a file on the local disk. Throw an exception in condition: 1: the target document type has not been developed yet. 2: the required assembly has not been added. 3: the zoom value is out of 10% ~ 2000%.
(Overrides BaseDocumentConvertToDocument(DocumentType, Single, String).)
Public methodConvertToDocument(DocumentType, String, ImageOutputOption) (Overrides BaseDocumentConvertToDocument(DocumentType, String, ImageOutputOption).)
Public methodConvertToImages(ImageType, Stream) (Overrides BaseDocumentConvertToImages(ImageType, Stream).)
Public methodConvertToImages(ImageType, ImageOutputOption, Stream) (Overrides BaseDocumentConvertToImages(ImageType, ImageOutputOption, Stream).)
Public methodConvertToImages(ImageType, Int32, Stream) (Overrides BaseDocumentConvertToImages(ImageType, Int32, Stream).)
Public methodConvertToImages(ImageType, Single, Stream) (Overrides BaseDocumentConvertToImages(ImageType, Single, Stream).)
Public methodConvertToImages(ImageType, String, String) (Overrides BaseDocumentConvertToImages(ImageType, String, String).)
Public methodConvertToImages(Single, Single, ImageType, Stream)
Public methodConvertToImages(ImageType, ImageOutputOption, String, String) (Overrides BaseDocumentConvertToImages(ImageType, ImageOutputOption, String, String).)
Public methodConvertToImages(ImageType, Int32, String, String) (Overrides BaseDocumentConvertToImages(ImageType, Int32, String, String).)
Public methodConvertToImages(ImageType, Single, String, String) (Overrides BaseDocumentConvertToImages(ImageType, Single, String, String).)
Public methodConvertToImages(Single, Single, ImageType, Single, Stream)
Public methodConvertToImages(Single, Single, Boolean, ImageType, Stream)
Public methodConvertToImages(Single, Single, Boolean, ImageType, Int32, Stream)
Public methodConvertToVectorImages(ContextType, String, String, RelativeType)
Converts document to the target type file format with sepcified file name and saves it to a file on the local disk. Throw an exception in condition: 1: the target context type has not been developed yet. 2: the required assembly has not been added.
(Overrides BaseDocumentConvertToVectorImages(ContextType, String, String, RelativeType).)
Public methodConvertToVectorImages(ContextType, String, String, RelativeType, RELength, RELength) (Overrides BaseDocumentConvertToVectorImages(ContextType, String, String, RelativeType, RELength, RELength).)
Public methodStatic memberConvertToXLSXDocument(Stream, Stream)
Public methodStatic memberConvertToXLSXDocument(String, String)
Public methodDeletePage (Overrides BaseDocumentDeletePage(Int32).)
Public methodDeletePages (Overrides BaseDocumentDeletePages(Int32, Int32).)
Public methodDispose
dispose the document
(Overrides BaseDocumentDispose.)
Public methodDuplicatePage
copy one page according to the page index
(Overrides BaseDocumentDuplicatePage(Int32).)
Public methodExtractPages(Int32, Stream) (Overrides BaseDocumentExtractPages(Int32, Stream).)
Public methodExtractPages(Int32, String) (Overrides BaseDocumentExtractPages(Int32, String).)
Public methodGetCharsRectangle (Overrides BaseDocumentGetCharsRectangle(Int32).)
Public methodGetDocumentType (Overrides BaseDocumentGetDocumentType.)
Public methodGetFontGlyphWidths (Overrides BaseDocumentGetFontGlyphWidths(String).)
Public methodGetHyperlink (Overrides BaseDocumentGetHyperlink.)
Public methodGetNewPage (Overrides BaseDocumentGetNewPage.)
Public methodGetOutline (Overrides BaseDocumentGetOutline.)
Public methodGetPage(Int32)
get one docx page by page index.
(Overrides BaseDocumentGetPage(Int32).)
Public methodGetPage(String)
get one docx page by page index string and default separator(,);
Public methodGetPage(String, Char)
get one docx page by page index string and separator
Public methodGetPageCount
get the sheet count of excel.
(Overrides BaseDocumentGetPageCount.)
Public methodStatic memberGetPreviewImage(Byte, Size)
Public methodStatic memberGetPreviewImage(Stream, Size)
Public methodStatic memberGetPreviewImage(String, Size)
Public methodGetSheetCount
Public methodGetSheetCount(Boolean)
get sheet count. if include hidden, return all sheet count,or return only visible sheet count;
Public methodGetWorkBook
Public methodInsertPage (Overrides BaseDocumentInsertPage(BasePage, Int32).)
Public methodInsertPages (Overrides BaseDocumentInsertPages(BasePage, Int32).)
Public methodStatic memberIsEXCELXDocument
Public methodIsPageExist
judge whether the page has existed by page index
(Overrides BaseDocumentIsPageExist(Int32).)
Public methodIsPageLoaded
judge whether the page has been loaded by page index
(Overrides BaseDocumentIsPageLoaded(Int32).)
Public methodStatic memberIsXLSDocument
Determine whether the stream is an excel 2003 document.
Public methodMergeDocument
merge two documents
Public methodStatic memberMergeSheetContent(Stream, Stream)
merge all xlsx documents corresponding worksheets content, and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(String, String)
merge all xlsx documents corresponding worksheets content, and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(Stream, Boolean, Stream)
merge all xlsx documents corresponding worksheets content, and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(Stream, Int32, Stream)
merge all xlsx documents of the assign worksheet content by mergeSheetIndex to the first. and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(String, Boolean, String)
merge all xlsx documents corresponding worksheets content, and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(String, Int32, String)
merge all xlsx documents of the assign worksheet content by mergeSheetIndex to the first. and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(Stream, Int32, Boolean, Stream)
merge all xlsx documents of the assign worksheet content by mergeSheetIndex, row or column to the first. and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(Stream, Int32, Boolean, Stream)
merge all xlsx documents of the assign worksheet content by corresponding mergeSheetIndex, row or column to the first. and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(String, Int32, Boolean, String)
merge all xlsx documents of the assign worksheet content by mergeSheetIndex, row or column to the first. and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberMergeSheetContent(String, Int32, Boolean, String)
merge all xlsx documents of the assign worksheet content by corresponding mergeSheetIndex, row or column to the first. and output the merged document base on the first document. if other documents sheet count bigger than the first, the first create new,and put other content to it.
Public methodStatic memberOpen(Stream)
open xls document by the stream
Public methodStatic memberOpen(String)
open xls document by the fixed file path
Public methodRenderPageToImage(Int32, BaseContext)
Public methodRenderPageToImage(Int32, BaseContext, RectangleF)
render page to Context
Public methodRenderPageToImage(Int32, BaseContext, Int32)
Public methodRenderPageToImage(Int32, BaseContext, Rectangle, Size)
Public methodRenderPageToImage(Int32, BaseContext, Int32, Boolean)
Public methodSave(Stream)
Save to xlsx file with assign stream. Attention: the result is XLSX document
Public methodSave(String)
Save to xlsx file with fixed file path. Attention: the result is XLSX document
(Overrides BaseDocumentSave(String).)
Public methodSaveToBytes
Unimplemented method
(Overrides BaseDocumentSaveToBytes.)
Public methodSaveToStream
Save to xlsx file with assign stream. Attention: the result is XLSX document
(Overrides BaseDocumentSaveToStream(Stream).)
Public methodSetOutline (Overrides BaseDocumentSetOutline(REOutline).)
Public methodSetViewGridlinesList(Boolean)
decide the excel document(all sheets) show view gridlines or not
Public methodSetViewGridlinesList(Int32, Boolean)
decide the sheets(by the sheet/page index) show gridlines or not
Public methodSetViewHeadingsList(Boolean)
decide the excel document(all sheets) show view headings(A-Z...and 1-N...) or not
Public methodSetViewHeadingsList(Int32, Boolean)
decide the sheets(by the sheet/page index) show view headings(A-Z...and 1-N...) or not
Public methodSortPage (Overrides BaseDocumentSortPage(Int32).)
Public methodStatic memberStart
Public methodSwapTwoPages (Overrides BaseDocumentSwapTwoPages(Int32, Int32).)
Public methodUpdatePage
update docx page by page index
(Overrides BaseDocumentUpdatePage(BasePage, Int32).)
Top
Events
See Also