Serialize Method (DateTimeCellType)

Visual Basic
C#

'Declaration
 
Public Overrides Function Serialize( _
   ByVal w As XmlTextWriter _
) As Boolean

'Usage
 
Dim instance As DateTimeCellType
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

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

C#

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();

Visual Basic

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()

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

DateTimeCellType Class
DateTimeCellType Members