Class Excel2007Export
Excel 2007 export class
Implements
Inherited Members
Namespace: FastReport.Export.OoXML
Assembly: FastReport.dll
Syntax
public class Excel2007Export : OOExportBase, IDisposable, IFRSerializableConstructors
Excel2007Export()
Initializes a new instance of the class.
Declaration
public Excel2007Export()Properties
CurrencyToAccounting
Gets or sets a value indicating that currency should be converted to accounting format.
Declaration
public bool CurrencyToAccounting { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
DataOnly
Gets or sets a value that determines whether to export the databand rows only.
Declaration
public bool DataOnly { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
FontScale
Gets or sets the font scale value.
Declaration
public float FontScale { get; set; }Property Value
| Type | Description |
|---|---|
| System.Single |
GeneralToText
Gets or sets a value indicating that general should be converted to text format.
Declaration
public bool GeneralToText { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
GroupName
Name of the selected group.
Declaration
public string GroupName { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
GroupOnSeparateSheet
Each group is placed on a new Excel page.
Declaration
public bool GroupOnSeparateSheet { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
MergePagesIntoSingleSheet
Specifies whether to merge all report pages into a single sheet when exporting to Excel. If set to true, all pages will be exported onto a single Excel sheet. By default, this property is disabled (false).
Declaration
public bool MergePagesIntoSingleSheet { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
PageBreaks
Gets or sets a value that determines whether to insert page breaks in the output file or not.
Declaration
public bool PageBreaks { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
PictureProperties
Gets or sets a value that determines whether to export the databand rows only.
Declaration
public Excel2007Export.ePictureProperties PictureProperties { get; set; }Property Value
| Type | Description |
|---|---|
| Excel2007Export.ePictureProperties |
PinX
Gets or sets the pinned cells in X ordinate.
Declaration
public int PinX { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
PinY
Gets or sets the pinned cells in Y ordinate.
Declaration
public int PinY { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
PrintFit
Gets or sets the Print Fit Mode.
Declaration
public Excel2007Export.PrintFitMode PrintFit { get; set; }Property Value
| Type | Description |
|---|---|
| Excel2007Export.PrintFitMode |
PrintOptimized
Enable or disable a resolution optimization.
Declaration
public bool PrintOptimized { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
PrintScale
Gets or sets the print scaling (value from 10 to 400).
Declaration
public int PrintScale { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Seamless
Enable or disable export of page footers and next page headers without table breaks.
Declaration
public bool Seamless { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShowGridlines
Enable or disable show gridlines.
Declaration
public bool ShowGridlines { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShrinkToFit
Determines whether to enable the srink to fit property for some text objects when exporting to excel.
Declaration
public bool ShrinkToFit { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
SplitPages
Each report page is placed on a new Excel page.
Declaration
public bool SplitPages { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
UngroupSheets
Grouping or ungrouping sheets. Grouping is enabled by default.
Declaration
public bool UngroupSheets { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
UseCustomFormat
Gets or sets a value indicating whether custom formats should be used for export instead of the default general format.
Declaration
public bool UseCustomFormat { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
UseFileStream
Gets or sets a value indicating that FileStream should be used instead of MomoryStream during export.
Declaration
public bool UseFileStream { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Remarks
Enabling this option will reduce memory consumption, but increase the time of export.
UseLocaleFormating
Gets or sets a value that determines whether the using locale data formatting.
Declaration
public bool UseLocaleFormating { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
UsePresetScale
Sets or gets the flag using the preset print scale.
Declaration
public bool UsePresetScale { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Wysiwyg
Gets or sets a value that determines whether the wysiwyg mode should be used for better results.
Declaration
public bool Wysiwyg { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Remarks
Default value is true. In wysiwyg mode, the resulting Excel file will look as close as possible to the prepared report. On the other side, it may have a lot of small rows/columns, which will make it less editable. If you set this property to false, the number of rows/columns in the resulting file will be decreased. You will get less wysiwyg, but more editable file.
Methods
ExportBand(BandBase)
This method is called for each band on exported page.
Declaration
protected override void ExportBand(BandBase band)Parameters
| Type | Name | Description |
|---|---|---|
| BandBase | band | Band, dispose after method compite. |
Overrides
ExportPageBegin(ReportPage)
This method is called at the start of exports of each page.
Declaration
protected override void ExportPageBegin(ReportPage page)Parameters
| Type | Name | Description |
|---|---|---|
| ReportPage | page | Page for export may be empty in this method. |
Overrides
ExportPageEnd(ReportPage)
This method is called at the end of exports of each page.
Declaration
protected override void ExportPageEnd(ReportPage page)Parameters
| Type | Name | Description |
|---|---|---|
| ReportPage | page | Page for export may be empty in this method. |
Overrides
Finish()
This method is called when the export is finished.
Declaration
protected override void Finish()Overrides
GetFileFilter()
Returns a file filter for a save dialog.
Declaration
protected override string GetFileFilter()Returns
| Type | Description |
|---|---|
| System.String | String that contains a file filter, for example: "Bitmap image (.bmp)|.bmp" |
Overrides
GetFileName()
Gets the file name to export to.
Declaration
public string GetFileName()Returns
| Type | Description |
|---|---|
| System.String | The full file name to export to. |
Serialize(FRWriter)
Serializes the object.
Declaration
public override void Serialize(FRWriter writer)Parameters
| Type | Name | Description |
|---|---|---|
| FRWriter | writer | Writer object. |
Overrides
Remarks
Do not call this method directly. You should override it if you are developing a new component for FastReport.
This method is called when the object needs to save the state. It may happen when:
- saving the report to the file or stream;
- saving the report to the designer's undo buffer;
- assigning the object to another object using the Assign(Base) or AssignAll methods;
- saving the object to the designer's clipboard;
- saving the object to the preview (when run a report).
ShowDialog()
Displays a dialog with export options.
Declaration
public override bool ShowDialog()Returns
| Type | Description |
|---|---|
| System.Boolean | true if dialog was closed with OK button. |
Overrides
Remarks
Before calling this method, set the report.
Start()
This method is called when the export starts.
Declaration
protected override void Start()