'Usage Dim instance As ListBoxCellType Dim w As XmlTextWriter Dim value As Boolean value = instance.Serialize(w)
Parameters
- w
- XmlTextWriter to which to write (save) the object
Return Value
Boolean: true if successful; false otherwise
'Usage Dim instance As ListBoxCellType 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()