BExcel
Linea B-Arts classica: questa scheda descrive
BStandardFramework(.NET Standard 2.0). Non usare firme o namespace come se appartenessero alBFrameworkmoderno .NET 10.
Identità
Assembly/progetto:
BStandardFramework.Target:
.NET Standard 2.0.Namespace CLR:
BArts.BOffice.Nome completo:
BArts.BOffice.BExcel.Tipo:
class.Ambito:
runtime/interfaccia pubblica.
Ruolo
Generatore di documenti Excel basato sul modello B-Arts della linea classica.
Dichiarazione
Public Class BExcelCostruttori
| Nome | Dichiarazione |
|---|---|
New |
Public Sub New() |
New |
Public Sub New(cmd As String, db As IBConnection, Optional isMultiResulset As Boolean = False _ , Optional tipo As CommandType = CommandType.StoredProcedure, Optional TblName As String() = Nothing) |
New |
Public Sub New(Ds As DataSet, Optional isMultiResulset As Boolean = False, Optional TblName As String() = Nothing) |
Proprietà
| Nome | Dichiarazione |
|---|---|
Cnn |
Public Property Cnn As IBConnection = Nothing |
Query |
Public Property Query As String = "" |
DataSet |
Public Property DataSet As DataSet = Nothing |
ModeDisconneted |
Public Property ModeDisconneted As Boolean = False |
TipoComando |
Public Property TipoComando As CommandType = CommandType.Text |
MultiResulset |
Public Property MultiResulset As Boolean = False |
ExceptionList |
Public Property ExceptionList As New List(Of Exception) |
Columns |
Public Property Columns As New List(Of BExcelDataColumn) |
TablesName |
Public Property TablesName As List(Of String) |
Styles |
Public Property Styles As New List(Of BExcelStyle) |
Headers |
Public Property Headers As New List(Of BExcelHeader) |
RowHeight |
Public Property RowHeight As Integer = 15 |
RowHeightHeader |
Public Property RowHeightHeader As Integer = 15 |
Sheets |
Public Property Sheets As List(Of BExcelSheet) |
Metodi
| Nome | Dichiarazione |
|---|---|
SaveFile |
Public Function SaveFile(PathFullName As String) As Boolean |
GetByteArray |
Public Function GetByteArray() As Byte() |
GetBFile |
Public Function GetBFile(Optional NomeFile As String = "BExcel.Xlsx") As BFile |
GetXmlExcel |
Public Function GetXmlExcel() As String |
Sorgenti verificati
Office\BExcel.vb