FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > DateTimeCellType Class : Serialize Method |
'Usage Dim instance As DateTimeCellType Dim w As XmlTextWriter Dim value As Boolean value = instance.Serialize(w)
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()
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8