.NET xPorter for Microsoft® Excel
Introducing .NET xPorter for Microsoft® Excel
End-User License Agreement
Installation, Distributing and Licensing for .NET xPorter for Microsoft® Excel
What's new in the .NET xPorter for Microsoft® Excel
Release Notes
Reference
Class Library
VM.xPort Namespace
ColWidth Class
ColWidth Members
ColWidth Constructor
ColWidth Constructor (String, String, Integer, Integer)
ColWidth Constructor (String, String, Integer, Integer, Integer)
Properties
Name Property
Range Property
TableName Property
Width Property
ColWidthCollection Class
ColWidthCollection Members
ColWidthCollection Constructor ()
ColWidthCollection Properties
ColWidthCollection.Exists (String) Property
Item Property
ColWidthCollection.Item (Int32) Property
ColWidthCollection.Item (String) Property
ColWidthCollection Methods
ColWidthCollection.Add (ColWidth) Method
ColWidthCollection.Remove (Int32) Method
DS2XL Class
DS2XL Members
DS2XL Constructor
DS2XL Constructor ()
Properties
AddCSVQuotes Property
BinaryFormat Property
ChunkSize Property
ColWidths Property
CSVDelimiter Property
Encoding Property
OptimizeForSize Property
RowHeights Property
SplitIntoChunks Property
Styles Property
Methods
Export Method
Export Method (DataSet, String, xpOutputFormat, Boolean, Boolean)
Export Method (DataSet, ExportTable(), String, xpOutputFormat, Boolean, Boolean)
Export Method (DataSet, String(), String, xpOutputFormat, Boolean, Boolean)
Export Method (DataTable, String, xpOutputFormat, Boolean, Boolean)
Export Method (DataTable, String(), String, xpOutputFormat, Boolean, Boolean)
Export Method (DataView, String, xpOutputFormat, Boolean, Boolean)
Export Method (DataView, String(), String, xpOutputFormat, Boolean, Boolean)
ExportToStream Method
ExportToStream Method (DataSet, xpOutputFormat, Boolean)
ExportToStream Method (DataSet, ExportTable(), xpOutputFormat, Boolean)
ExportToStream Method (DataSet, String(), xpOutputFormat, Boolean)
ExportToStream Method (DataTable, xpOutputFormat, Boolean)
ExportToStream Method (DataTable, String(), xpOutputFormat, Boolean)
ExportToStream Method (DataView, xpOutputFormat, Boolean)
ExportToStream Method (DataView, String(), xpOutputFormat, Boolean)
Events
ExportComplete Event (Object, Int32)
ExportProgress Event (Object, Int32)
Exceptions
ColumnOutOfRangeException Class
FileAlreadyExistsException Class
InvalidColumnListException Class
InvalidColumnNameException Class
InvalidDataSourceException Class
InvalidFileFormatException Class
InvalidTableNameException Class
NotSupportedFileFormatException Class
RowOutOfRangeException Class
TableOutOfRangeException Class
xPortApplicationException Class
Enumerations
xpBinaryFormat Enumeration
xpOutputFormat Enumeration
ExportTable Class
ExportTable Members
ExportTable Constructor
ExportTable Constructor ()
Properties
Name Property
Columns Property
RowHeight Class
RowHeight Members
RowHeight Constructor
RowHeight Constructor (String, String, Integer, Integer)
RowHeight Constructor (String, String, Integer, Integer, Integer)
Properties
Name Property
Range Property
TableName Property
Height Property
RowHeightCollection Class
RowHeightCollection Members
RowHeightCollection Constructor ()
RowHeight Collection Properties
Exists (String) Property
Item Property
Item (Int32) Property
Item (String) Property
RowHeight Collection Methods
Add (RowHeight) Method
Remove (Int32) Method
Structures
Range Structure
Range Members
Properties
EndCol Property
EndRow Property
StartCol Property
StartRow Property
Style Class
Style Members
Style Constructor
Style Constructor ()
Style Constructor (String, String, Integer, Integer, Integer, Integer)
Properties
BackgroundColor Property
BottomBorderColor Property
BottomBorderLine Property
Font Property
ForeColor Property
Format Property
FormatIndex Property
HorizontalAlignment Property
Indent Property
IsFormula Property
LeftBorderColor Property
LeftBorderLine Property
Name Property
Range Property
ReadingDirection Property
RightBorderColor Property
RightBorderLine Property
Rotation Property
SuperscriptSubscript Property
TableName Property
TopBorderColor Property
TopBorderLine Property
UnderlineStyle Property
VerticalAlignment Property
WrapText Property
Methods
Clone Method (String, String, Integer, Integer, Integer, Integer)
Enumerations
xpBorderLineStyle Enumeration
xpFormat Enumeration
xpHAlignment Enumeration
xpReadingDirection Enumeration
xpSuperscript Enumeration
xpUnderlineStyle Enumeration
xpVAlignment Enumeration
StyleCollection Class
StyleCollection Members
StyleCollection Constructor ()
StyleCollection Properties
Exists (String) Property
Item Property
Item (Int32) Property
Item (String) Property
StyleCollection Methods
Add (Style) Method
Remove (Int32) Method
.NET xlReader for Microsoft® Excel
Introducing .NET xlReader for Microsoft® Excel
End-User License Agreement
Installation, Distributing and Licensing for .NET xlReader for Microsoft® Excel
What's new in the .NET xlReader for Microsoft® Excel
Release Notes
Reference
Class Library
VM.xPort.ExcelClient Namespace
ExcelCommand Class
ExcelCommand Members
ExcelCommand Constructor
ExcelCommand Constructor ()
ExcelCommand Constructor (String)
ExcelCommand Constructor (String, ExcelConnection)
Properties
CommandText Property
CommandTimeout Property
CommandType Property
Connection Property
Methods
ExecuteReader Method
ExecuteReader Method ()
ExecuteReader Method (CommandBehavior)
ExecutePicker Method
ExecutePicker Method ()
ExecutePicker Method (CommandBehavior)
ExcelConnection Class
ExcelConnection Members
ExcelConnection Constructor
ExcelConnection Constructor ()
ExcelConnection Constructor (String)
ExcelConnection Constructor (Stream, String)
ExcelConnection Properties
ConnectionString Property
ConnectionTimeout Property
Database Property
DataSource Property
State Property
ExcelConnection Methods
Close Method
CreateCommand Method
GetExcelSchemaTable Method
Open Method
Enumerations
ExcelClientSchemaType Enumeration
ExcelDataAdapter Class
ExcelDataAdapter Members
ExcelDataAdapter Constructor
ExcelDataAdapter Constructor ()
ExcelDataAdapter Constructor (ExcelCommand)
ExcelDataAdapter Constructor (String, ExcelConnection)
ExcelDataAdapter Constructor (String, String)
ExcelDataAdapter Properties
SelectCommand Property
ExcelDataAdapter Methods
Fill Method
Fill Method (DataSet)
Fill Method (DataTable)
ExcelDataPicker Class
ExcelDataPicker Members
ExcelDataPicker Properties
IsClosed Property
ExcelDataPicker Methods
Close Method
GetBoolean Method
GetBoolean Method (Int32, Int32)
GetBoolean Method (String)
GetByte Method
GetByte Method (Int32, Int32)
GetByte Method (String)
GetCellType Method
GetCellType Method (Int32, Int32)
GetCellType Method (String)
GetChar Method
GetChar Method (Int32, Int32)
GetChar Method (String)
GetDataTypeName Method
GetDataTypeName Method (Int32, Int32)
GetDataTypeName Method (String)
GetDateTime Method
GetDateTime Method (Int32, Int32)
GetDateTime Method (String)
GetDecimal Method
GetDecimal Method (Int32, Int32)
GetDecimal Method (String)
GetDouble Method
GetDouble Method (Int32, Int32)
GetDouble Method (String)
GetFloat Method
GetFloat Method (Int32, Int32)
GetFloat Method (String)
GetGuid Method
GetGuid Method (Int32, Int32)
GetGuid Method (String)
GetInt16 Method
GetInt16 Method (Int32, Int32)
GetInt16 Method (String)
GetInt32 Method
GetInt32 Method (Int32, Int32)
GetInt32 Method (String)
GetInt64 Method
GetInt64 Method (Int32, Int32)
GetInt64 Method (String)
GetString Method
GetString Method (Int32, Int32)
GetString Method (String)
GetValue Method
GetValue Method (Int32, Int32)
GetValue Method (String)
IsDBNull Method
IsDBNull Method (Int32, Int32)
IsDBNull Method (String)
ExcelDataReader Class
ExcelDataReader Members
ExcelDataReader Properties
Depth Property
FieldCount Property
HasRows Property
IsClosed Property
Item Property
Item Property (Int32)
Item Property (String)
RecordsAffected Property
ExcelDataReader Methods
Close Method
GetBoolean Method
GetByte Method
GetChar Method
GetDataTypeName Method
GetDateTime Method
GetDecimal Method
GetDouble Method
GetFieldType Method
GetFloat Method
GetGuid Method
GetInt16 Method
GetInt32 Method
GetInt64 Method
GetName Method
GetOrdinal Method
GetString Method
GetValue Method
GetValues Method
IsDBNull Method
NextResult Method
Read Method
ExcelException Class
ExcelNullValueException Class
.NET txtReader for Text Files
Introducing .NET txtReader for Text Files
End-User License Agreement
Installation, Distributing and Licensing for .NET txtReader for Text Files
Release Notes
Reference
Class Library
xPortTools.TxtClient Namespace
TxtCommand Class
TxtCommand Members
TxtCommand Constructor
TxtCommand Constructor ()
TxtCommand Constructor (String)
TxtCommand Constructor (String, TxtConnection)
Properties
CommandText Property
CommandTimeout Property
CommandType Property
Connection Property
Methods
ExecuteReader Method
ExecuteReader Method ()
ExecuteReader Method (CommandBehavior)
TxtConnection Class
TxtConnection Members
TxtConnection Constructor
TxtConnection Constructor ()
TxtConnection Constructor (String)
TxtConnection Properties
ConnectionString Property
ConnectionTimeout Property
Database Property
State Property
TxtConnection Methods
Close Method
CreateCommand Method
Open Method
TxtDataAdapter Class
TxtDataAdapter Members
TxtDataAdapter Constructor
TxtDataAdapter Constructor ()
TxtDataAdapter Constructor (TxtCommand)
TxtDataAdapter Constructor (String, TxtConnection)
TxtDataAdapter Constructor (String, String)
TxtDataAdapter Properties
SelectCommand Property
TxtDataAdapter Methods
Fill Method
Fill Method (DataSet)
Fill Method (DataTable)
TxtDataReader Class
TxtDataReader Members
TxtDataReader Properties
Depth Property
FieldCount Property
IsClosed Property
Item Property
Item Property (Int32)
Item Property (String)
RecordsAffected Property
TxtDataReader Methods
Close Method
GetBoolean Method
GetByte Method
GetChar Method
GetDataTypeName Method
GetDateTime Method
GetDecimal Method
GetDouble Method
GetFieldType Method
GetFloat Method
GetGuid Method
GetInt16 Method
GetInt32 Method
GetInt64 Method
GetName Method
GetOrdinal Method
GetString Method
GetValue Method
GetValues Method
IsDBNull Method
NextResult Method
Read Method
TxtException Class
TxtNullValueException Class
.NET odsReader for OpenDocument Spreadsheet
Introducing .NET odsReader for OpenDocument Spreadsheet
End-User License Agreement
Installation, Distributing and Licensing for .NET odsReader for OpenDocument Spreadsheet
Release Notes
Reference
Class Library
xPortTools.OdsClient Namespace
OdsCommand Class
OdsCommand Members
OdsCommand Constructor
OdsCommand Constructor ()
OdsCommand Constructor (String)
OdsCommand Constructor (String, OdsConnection)
Properties
CommandText Property
CommandTimeout Property
CommandType Property
Connection Property
Methods
ExecuteReader Method
ExecuteReader Method ()
ExecuteReader Method (CommandBehavior)
OdsConnection Class
OdsConnection Members
OdsConnection Constructor
OdsConnection Constructor ()
OdsConnection Constructor (String)
OdsConnection Constructor (Stream, String)
OdsConnection Properties
ConnectionString Property
ConnectionTimeout Property
Database Property
DataSource Property
State Property
OdsConnection Methods
Close Method
CreateCommand Method
GetSchemaTable Method
Open Method
Enumerations
OdsClientSchemaType Enumeration
OdsDataAdapter Class
OdsDataAdapter Members
OdsDataAdapter Constructor
OdsDataAdapter Constructor ()
OdsDataAdapter Constructor (OdsCommand)
OdsDataAdapter Constructor (String, OdsConnection)
OdsDataAdapter Constructor (String, String)
OdsDataAdapter Properties
SelectCommand Property
OdsDataAdapter Methods
Fill Method
Fill Method (DataSet)
Fill Method (DataTable)
OdsDataReader Class
OdsDataReader Members
OdsDataReader Properties
Depth Property
FieldCount Property
HasRows Property
IsClosed Property
Item Property
Item Property (Int32)
Item Property (String)
RecordsAffected Property
OdsDataReader Methods
Close Method
GetBoolean Method
GetByte Method
GetChar Method
GetDataTypeName Method
GetDateTime Method
GetDecimal Method
GetDouble Method
GetFieldType Method
GetFloat Method
GetGuid Method
GetInt16 Method
GetInt32 Method
GetInt64 Method
GetName Method
GetOrdinal Method
GetString Method
GetValue Method
GetValues Method
IsDBNull Method
NextResult Method
Read Method
OdsException Class
OdsNullValueException Class