skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • AI Coding Assistants
    • Embedded Reporting
    • Document Processing Libraries
    • SSO Account Sign-in

    Web

    Kendo UI UI for Angular UI for Vue UI for jQuery KendoReact UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Telerik JustMock

    CMS

    Sitefinity

    AI Productivity Tools

    AI Coding Assistants

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    KendoReact Free VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
    • What's New
    • Roadmap
    • Release History
  • Support and Learning

    • Support and Learning Hub
    • First Steps
    • Docs
    • Demos
    • Virtual Classroom
    • Forums
    • Videos
    • Blogs
    • Accessibility
    • Submit a Ticket

    Productivity and Design Tools

    • Visual Studio Extensions
    • Visual Studio Templates
    • Embedded Reporting
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

Class DataTableFormatProviderExportSettings

Provides the export settings for the DataTableFormatProvider.

Inheritance
System.Object
DataTableFormatProviderExportSettings
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.FormatProviders
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class DataTableFormatProviderExportSettings

Constructors

DataTableFormatProviderExportSettings()

Initializes an instance of the DataTableFormatProviderExportSettings class.

Declaration
public DataTableFormatProviderExportSettings()

Properties

DataTableCulture

Get or sets the DataTable culture. By default the culture of the workbook is used.

Declaration
public CultureInfo DataTableCulture { get; set; }
Property Value
System.Globalization.CultureInfo

HasHeaderRow

Get or sets whether the header row of the worksheet should be exported.

Declaration
public bool HasHeaderRow { get; set; }
Property Value
System.Boolean

RangeToExport

Get or sets the cell range for which the data will be exported.

Declaration
public CellRange RangeToExport { get; set; }
Property Value
CellRange

ShouldSetDataTypes

Get or sets whether the exporter should try to parse the data types from the spreadsheet. If false only objects will be exported.

Declaration
public bool ShouldSetDataTypes { get; set; }
Property Value
System.Boolean

Methods

OnColumnExporting(DataColumn, Int32)

This method triggers the ColumnExporting event.

Declaration
protected virtual void OnColumnExporting(DataColumn dataColumn, int columnIndex)
Parameters
System.Data.DataColumn dataColumn

The currently exported DataColumn

System.Int32 columnIndex

The index of the column in the DataTable that the event occurs for.

Events

ColumnExporting

This event is fired for each column and allows you to change its properties.

Declaration
public event EventHandler<ColumnExportingEventArgs> ColumnExporting
Event Type
System.EventHandler<ColumnExportingEventArgs>

Extension Methods

SvgExtentions.Traverse<T>(T, Func<T, IEnumerable<T>>)
SvgExtentions.TraverseDepthFirst<T>(T, Func<T, IEnumerable<T>>)
Getting Started
  • Install Now
  • Demos
  • Step-by-Step Tutorial
  • Sample Applications
  • SDK Samples
  • Visual Studio Extensions
Support Resources
  • Code Library
  • Knowledge Base
  • Videos
Community
  • Forums
  • Blogs
  • Feedback Portal
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.