SpreadsheetGear 2023
SetDataFlags Enumeration


SpreadsheetGear.Data Namespace : SetDataFlags Enumeration
Specifies options for the SpreadsheetGear.IRange.CopyFromDataTable method.
Syntax
'Declaration
 
<System.FlagsAttribute()>
Public Enum SetDataFlags 
   Inherits System.Enum
'Usage
 
Dim instance As SetDataFlags
[System.Flags()]
public enum SetDataFlags : System.Enum 
Members
MemberDescription
AllTextAll values are stored and formatted as text, including numeric and boolean types which are converted to text.
InsertCellsSpecifies that cells should be inserted to make room for the DataTable.
NoColumnHeadersSpecifies that a row with column headers will not be created from the DataTable's column names.
NoneSpecifies 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.
WrapNoColumnHeadersSpecifies 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

SpreadsheetGear.Data Namespace
CopyFromDataTable Method
GetDataTable Method
GetDataFlags Enumeration