SpreadsheetGear.Data Namespace : SetDataFlags Enumeration |
Specifies options for the CopyFromDataTable method.
Member | Description |
---|---|
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. |
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)
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.