Excel |
Static helper methods to read and write CSV values and load DataTables from Excel or CSV files, available in Razor scripts
Inheritance HierarchyNamespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 10.0.1.0+a44cd3a7f03c2bf3cdbd971a878c679e40bed08a
SyntaxC#
public class ExcelHelper
The ExcelHelper type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | ExcelHelper | Initializes a new instance of the ExcelHelper class |
Methods| Name | Description | |
|---|---|---|
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
 | FromCsv | Returns a CSV value with its enclosing double quotes and escaping removed |
| GetExcelPackage | Load an Excel Package |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| GetUniqueColumnName | Returns a column name not already present in the table, appending a number if necessary |
| InitCSVVBParser | Create and configure a Microsoft VB TextFieldParser to parse a CSV file |
| IsRowEmpty | Returns true if all cells of the worksheet row are empty in the given column range |
| LoadDataTableFromCSV | Load a DataTable from a CSV file. If no separator is specified, ',' or ';' is detected from the first line. If noHeader is true, column names are automatic. |
| LoadDataTableFromCSVVBParser(TextFieldParser) | Load a DataTable from an initialized Microsoft VB Parser (the first row is used as the header) |
| LoadDataTableFromCSVVBParser(String, NullableChar, Encoding) | Load a DataTable from a CSV file using the Microsoft VB Parser |
| LoadDataTableFromExcel | Load a DataTable from an Excel file. A start and end row, and/or colum can be specified. If hasHeader is false, column names are automatic. |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| ToCsv | Returns a value quoted and escaped for a CSV file, followed by the separator |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
See Also