SpreadsheetGear 2010
SetDataFlags Enumeration
See Also  Send Feedback
SpreadsheetGear.Data Namespace : SetDataFlags Enumeration

Specifies options for the SpreadsheetGear.IRange.CopyFromDataTable method.

Syntax

Visual Basic (Declaration) 
<FlagsAttribute()>
Public Enum SetDataFlags 
   Inherits System.Enum
C# 
[FlagsAttribute()]
public enum SetDataFlags : System.Enum

Members

MemberDescription
AllText All values are stored and formatted as text, including numeric and boolean types which are converted to text.
InsertCells Specifies that cells should be inserted to make room for the DataTable.
NoColumnHeaders Specifies that a row with column headers will not be created from the DataTable's column names.
None Specifies default behaviour: automatically determine the best cell type and formatting; first row does receive column headers; do not insert cells to open space for the DataTable.
WrapNoColumnHeaders Specifies that a row with column headers will not be created from the DataTable's column names when data wraps to a new worksheet.
WrapToNewWorksheetSpecifies that data will wrap to a new worksheet if it does not fit on the current worksheet; column headers will be placed at the top of this new worksheet unless SetDataFlags.WrapNoColumnHeaders is specified.
WrapToNewWorksheet64KSpecifies that data will wrap to a new worksheet if it does not fit in the first 65536 rows of the current worksheet; column headers will be placed at the top of this new worksheet unless SetDataFlags.WrapNoColumnHeaders is specified.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         SpreadsheetGear.Data.SetDataFlags

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.