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 Type of the current instance. (Inherited from Object.) | |
GetXMLElementName |
Normalizes header text to be usable as element name.
| |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
RaiseError |
Raises error event.
| |
ToString | Returns a string that represents the current object. (Inherited from Object.) |
Extension Methods
Name | Description | |
---|---|---|
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