The DataExportHelper type exposes the following members.
Back to Top
Back to Top
Back to Top
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | DataExportHelper |
Default constructor.
|
 | DataExportHelper(DataSet) |
Constructor initializing data source.
|
Methods
| Name | Description | |
|---|---|---|
 | CreateColumnName |
Creates column name from column number ("1" -> "A")
|
| CreateColumnReference |
Creates column reference from column and row numbers.
|
|  Equals | (Inherited from Object.) |
| ExportData(DataExportFormatEnum, Stream) |
Exports data stored in DataSource property, writes it to given stream.
|
| ExportData(DataExportFormatEnum, HttpResponse) |
Exports data stored in DataSource property, writes it to given response.
|
| ExportToCSV(DataSet, Int32, Stream) |
Exports specified table of given DataSet to CSV format.
|
| ExportToCSV(DataSet, Int32, Stream, Boolean) |
Exports specified table of given DataSet to CSV format.
|
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetColumnCaptionText |
Gets a caption for given column name.
|
| GetColumnIndex |
Gets index of a column corresponding to columns actually selected to export.
|
| GetColumnName |
Returns name of column from given cell reference (ex. "B4" -> "B")
|
| GetColumnNumber |
Gets number of given column name ("A" -> "1")
|
| GetDataExportFormatContentType |
Returns content type for given format.
|
| GetDataExportFormatEnum |
Returns DataExportFormat enum.
|
| GetDataExportFormatString |
Returns DataExportFormat string.
|
| GetExportedColumns |
Gets columns that should be exported.
|
| GetExportedData |
Gets the DataSet with the formatted exported data
|
| GetExportedValue |
Gets the exported value for the given
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetRowNumber |
Returns number of a row from given cell reference (ex. "B4" -> "4")
|
| GetType | Gets the (Inherited from Type of the current instance.Object.) |
| GetXMLElementName |
Normalizes header text to be usable as element name.
|
| MemberwiseClone | Creates a shallow copy of the current (Inherited from Object.Object.) |
| RaiseError |
Raises error event.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Extension Methods
| Name | Description | |
|---|---|---|
 | AsValue |
Converts object to a query value which can be used as a query parameter
(Defined by QueryExtensions.) |
| GetAPIString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| GetString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| ToBoolean |
Returns the boolean representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDateTime |
Returns the DateTime representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDouble |
Returns the double representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToGuid |
Returns the Guid representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToInteger |
Returns the integer representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToString |
Returns the string representation of an object or default value if not.
(Defined by CoreExtensions.) |
Fields
| Name | Description | |
|---|---|---|
 | DEFAULT_COLUMN_NAME |
Name of element representing column used when there is no other name available.
|
| DEFAULT_TEMPLATE_NAME |
Default name of Excel export template.
|
| MAX_EXCEL_CELL_SIZE |
Maximum size of Excel cell.
|
| mDataExportTemplatePath |
Holds path leading to Excel export template.
|
| mDataSource |
Source of data.
|
| mExportedColumns |
Holds actually exported columns.
|
| mFileName |
File of name to export (without extension).
|
| mFileNameWithExtension |
File of name to export with extension.
|
| mMacroResolver |
Holds macro resolver.
|
| mUseSharedStringStorage |
Indicates whether to use shared string table during Excel export.
|
Properties
| Name | Description | |
|---|---|---|
 | AllowExportEmptyDataSource |
Determines whether to allow export empty data source or raise an error
|
| CSVDelimiter |
Defines delimiter for CSV format.
|
| DataExportTemplateFolder |
Gets a startup path for template lookup.
|
| DataExportTemplatePath |
Gets a relative path leading to template.
|
| DataSource |
Gets or sets the source of data to export.
|
| FileName |
Name of exported file (without extension).
|
| FileNameWithExtension |
Name of exported file with extension.
|
| GenerateHeader |
Indicates whether to generate also a header row.
|
| MacroResolver |
Gets or sets macro resolver.
|
| TopN |
Top N rows to export.
|
| UseSharedStringStorage |
Defines whether to use shared string table for storing text values.
When value is false text is being stored as inline string.
Applies only to Excel export.
|
| UseTemplate |
Indicates whether to use XLSX template.
|
Events
| Name | Description | |
|---|---|---|
 | Error |
Error handler.
|
 | ExternalDataBound |
External data bound handler.
|
See Also