XlsExport Class

Provides Excel Export functionality for ActiveReports for .NET.

Inheritance

object

MarshalByRefObject

Component

XlsExport

Implements

IComponent

IDisposable

IDocumentExport

Namespace: GrapeCity.ActiveReports.Export.Excel.Section

Assembly: MESCIUS.ActiveReports.Export.Excel.dll

Syntax

public sealed class XlsExport : Component, IComponent, IDisposable, IDocumentExport

Remarks

Any public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe. For example changing a property value in one thread while an Export method is running in a separate thread could yield unexpected results.

Optimizing your report for exporting to Excel:
Since Excel is basically a table of rows and columns, and ActiveReports is a free form type output it may be necessary to “optimize?your ActiveReport for Excel exporting. When you want two controls to be in the same column when outputted to excel it is imperative that the two controls have *exactly* the same left value. And it may also help to ensure that the font of the two controls is the same. Attempting to make the height of the two controls similar will often times lead to a cleaner looking output in excel. Similarly if you want two controls to be in the same row when outputted to Excel, you should make sure the two controls have exactly the same Top value, that their font is the same, and that their width is similar if not the same. Using RichText controls on your ActiveReports will often will not have good output in Excel. Using the Page object's drawing methods to draw anything in the margin areas of the export will cause pagination problems. If you draw items on the page, do not draw them in the margin area to keep the pagination accurate when printing excel exported output.

Constructors

Name	Description
XlsExport()	Initializes a new instance of the ExcelExport class.

Properties

Name	Description
AutoRowHeight	True if excel should set the height of the row based on the contents of that row. Otherwise the XlsExport will calculate the height of the rows. In some cases this may make the output look better inside excel. However, a value of true may adversely effect pagination when printing from excel, as it will often cause excel to stretch the height of the page.
DisplayGridLines	Sets or returns whether grid lines in workbook are displayed.
FileFormat	Sets or returns which file format version the outputted file should support.
MinColumnWidth	Sets or returns the minimum width (in inches) of an empty column that will be permitted in the output.
MinRowHeight	Sets or returns the minimum height (in inches) of an empty row that will be permitted in the output.
MultiSheet	Sets or returns whether each page is to be exported to it's own sheet or not. True indicates that each page in the ActiveReport Document will be exported to a separate sheet.
OpenXmlStandard	Gets or sets the level of Open XML document conformance on exporting with Xlsx file format.
PageSettings	Returns a XlsPageSettings object for initializing Excel file print setting.
Pagination	Gets or sets the value indicates should pagination be used for resulted xls document or not
RemoveVerticalSpace	Sets or returns a value that indicates whether completely empty vertical spacing will be removed from the output.
Security	Returns a XlsSecurity object for initializing document security.
SheetName	Sets or returns a value indicating the name of sheet. Sheet is default.
UseCellMerging	Sets or returns whether cells should be merged together where applicable.
UseCompression	Gets or sets the value indicating should compression be used on exporting with Xlsx file format.
UseDefaultPalette	Sets or returns whether export document with Excel default palette.

Methods

Name	Description
Export(SectionDocument, IOutputHtml, string)	Exports the specified document.
Export(SectionDocument, Stream)	Exports the specified document to Excel.
Export(SectionDocument, Stream, string)	Exports the specified document to Excel.
Export(SectionDocument, string)	Exports the specified document to a .xls file.
Export(SectionDocument, string, string)	Exports the specified document to Excel.