FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread.CellType 名前空間 > GeneralCellType クラス : Serialize メソッド |
'使用法 Dim instance As GeneralCellType Dim w As XmlTextWriter Dim value As Boolean value = instance.Serialize(w)
次のサンプルコードは、通貨型セルでのこのメソッドの使用方法を示していますが、他のセル型でも同じように使用できます。
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()