Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / TextCellType Class / Serialize Method
XmlTextWriter to which to write (save) the object
Example


In This Topic
    Serialize Method (TextCellType)
    In This Topic
    Saves the object to XML.
    Syntax
    'Declaration
     
    Public Overrides Function Serialize( _
       ByVal w As XmlTextWriter _
    ) As Boolean
    'Usage
     
    Dim instance As TextCellType
    Dim w As XmlTextWriter
    Dim value As Boolean
     
    value = instance.Serialize(w)
    public override bool Serialize( 
       XmlTextWriter w
    )

    Parameters

    w
    XmlTextWriter to which to write (save) the object

    Return Value

    Boolean: true if successful; false otherwise
    Example

    This example shows the use of this method for a currency cell but the use is similar for any cell type.

    FarPoint.Win.Spread.CellType.CurrencyCellType curr = new FarPoint.Win.Spread.CellType.CurrencyCellType();
    curr.DecimalSeparator = ",";
    curr.DecimalPlaces = 3;
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = curr;
    fpSpread1.ActiveSheet.Cells[0, 0].Value = 443.0908;
    string fileName; 
    fileName = "..\\files\\mycurr.xml"; 
    System.IO.Stream stream;  
    stream = System.IO.File.Open(fileName, System.IO.FileMode.Create); 
    System.Xml.XmlTextWriter writer = new System.Xml.XmlTextWriter(stream, System.Text.Encoding.UTF8); 
    writer.Formatting = System.Xml.Formatting.Indented; writer.Indentation = 2; 
    writer.WriteStartDocument(); 
    writer.WriteStartElement("Currency"); 
    curr.Serialize(writer); 
    writer.WriteEndElement(); 
    writer.WriteEndDocument(); 
    writer.Close();
    Dim curr As New FarPoint.Win.Spread.CellType.CurrencyCellType()
    curr.DecimalSeparator = ","
    curr.DecimalPlaces = 3
    fpSpread1.ActiveSheet.Cells(0, 0).CellType = curr
    fpSpread1.ActiveSheet.Cells(0, 0).Value = 443.9098
    Dim fileName As String
    fileName = "..\files\mycurr.xml"
    Dim stream As System.IO.Stream
    stream = System.IO.File.Open(fileName, System.IO.FileMode.Create)
    Dim writer As New System.Xml.XmlTextWriter(stream, System.Text.Encoding.UTF8)
    writer.Formatting = System.Xml.Formatting.Indented
    writer.Indentation = 2
    writer.WriteStartDocument()
    writer.WriteStartElement("Currency")
    curr.Serialize(writer)
    writer.WriteEndElement()
    writer.WriteEndDocument()
    writer.Close()
    See Also