New to Telerik UI for ASP.NET AJAX? Start a free 30-day trial

GridExcelSettings

Class

Class holding settings associated with the RadGrid exporting to Excel functionality.

Definition

Namespace:Telerik.Web.UI

Assembly:Telerik.Web.UI.dll

Syntax:

[TypeConverter(typeof(ExpandableObjectConverter))]
public class GridExcelSettings : ObjectWithState

Inheritance: objectObjectWithStateGridExcelSettings

Inherited Members object.ToString()object.Equals(object)object.Equals(object, object)object.ReferenceEquals(object, object)object.GetHashCode()object.GetType()object.MemberwiseClone()...

Constructors

GridExcelSettings(StateBag)

public GridExcelSettings(StateBag OwnerStateBag)

Parameters:OwnerStateBagStateBag

Properties

AutoFitColumnWidth

ExportAutoFitWidthMode

Determines whether RadGrid will auto-fit the columns' width based on the length of the content. False by default. XLSX format only.

public ExportAutoFitWidthMode AutoFitColumnWidth { get; set; }

AutoFitImages

bool

Determines whether RadGrid will fit the image within the boundaries of its parent cell (true) or will leave it with the default dimensions (false). False by default. BIFF only.

public bool AutoFitImages { get; set; }

DefaultCellAlignment

HorizontalAlign

Determines the default header cell alignment when exporting to Excel. Default value is 'NotSet'.

public HorizontalAlign DefaultCellAlignment { get; set; }

FileExtension

string

Gets or sets the file extension for RadGrid Excel export.

public string FileExtension { get; set; }

Property Value:

The file extension for RadGrid Excel export.

Format

GridExcelExportFormat

Gets or sets in which format the Excel data will be exported.

public GridExcelExportFormat Format { get; set; }

Property Value:

The Excel format type.

WorksheetName

string

A string specifying the name of the worksheet that will be created. If none is set, the ExportSettings.FileName will be used for a Worksheet name. Not applicable for ExcelFormat.Html.

public string WorksheetName { get; set; }