See Also

SpreadsheetGear.Data Namespace  | CopyFromDataTable Method  | GetDataTable Method  | GetDataFlags Enumeration

Requirements

Namespace: SpreadsheetGear.Data

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

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

Language

Visual Basic

C#

C++

C++/CLI

Show All

See AlsoLanguages Requirements SpreadsheetGear The Performance Spreadsheet Component Company 

SetDataFlags Enumeration

SpreadsheetGear.Data Namespace : SetDataFlags Enumeration

Specifies options for the CopyFromDataTable method.

Members

MemberDescription
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.
AllText All values are stored and formatted as text, including numeric and boolean types which are converted to text.
NoColumnHeaders Specifies that a row with column headers will not be created from the DataTable's column names.
InsertCells Specifies that cells should be inserted to make room 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.
WrapToNewWorksheet Specifies 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.

Requirements

Namespace: SpreadsheetGear.Data

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

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also

SpreadsheetGear.Data Namespace  | CopyFromDataTable Method  | GetDataTable Method  | GetDataFlags Enumeration

 

 


See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.