ExportToExcel Class

Exports Text (tab or semicolon separated), Image, DataTable, GridEX, NChartControl or McWindow into Excel. Input is a title, Input2 is an object.

Inheritance Hierarchy

Namespace: MediaCy.Commands.Export
Assembly: MediaCy.Commands (in MediaCy.Commands.dll) Version: 3.1.0.0

Syntax

Public Class ExportToExcel
	Inherits BaseExportCommand

The ExportToExcel type exposes the following members.

Constructors

	Name	Description
	ExportToExcel	Initializes a new instance of the ExportToExcel class
	ExportToExcel(String)	Initializes a new instance of the ExportToExcel class
	ExportToExcel(McCommand)	Initializes a new instance of the ExportToExcel class

Properties

	Name	Description
	AbsolutePosition	Defines absolute position (starting cell). If AbsolutePosition.X >= 1 and AbsolutePosition.Y >= 1 then Position and Offset parameters will be ignored and the data will be exported at selected cell.
	Borders	Draw table borders or not.
	ColumnHeaders	Export 1st table column headers or not.
	ColumnHeaders2	Export 2nd, etc table column headers or not.
	Direction	Defines direction if more than one object exported.
	ExpandedRowsOnly	Export only expanded rows when true.
	FileFilter	Returns file filters in format NAME\|*.EXT for selected object.
	IsInstalled	Returns True if Excel installed on this computer.
	Offset	Defines offset between 2 blocks of data.
	Options	Export options: NewWorksheet, AppendToBottom, AppendToRight.
	Position	Defines starting position on the new worksheet.
	RowHeaders	Export 1st table row headers or not.
	RowHeaders2	Export 2nd, etc table row headers or not.
	SpecialGroupFormating	Format grouping rows as splitting the data into multiple columns.
	Style	Export style (font and colors) or not. This is a slow method.
	Worksheet	Name of the destination worksheet.

Methods

	Name	Description
	FormatGroupCaption
	FormatGroupCaptionCell

Remarks