public static CT_Rst Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
CT_Rst ctObj = new CT_Rst();
ctObj.r = new List <CT_RElt>();
ctObj.rPh = new List <CT_PhoneticRun>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "phoneticPr")
{
ctObj.phoneticPr = CT_PhoneticPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "r")
{
ctObj.r.Add(CT_RElt.Parse(childNode, namespaceManager));
}
else if (childNode.LocalName == "rPh")
{
ctObj.rPh.Add(CT_PhoneticRun.Parse(childNode, namespaceManager));
}
else if (childNode.LocalName == "t")
{
ctObj.t = childNode.InnerText.Replace("\r", "");
}
}
return(ctObj);
}
public static SstDocument Parse(XmlDocument xml, XmlNamespaceManager namespaceManager)
{
try
{
SstDocument sstDoc = new SstDocument();
sstDoc.AddNewSst();
CT_Sst sst = sstDoc.GetSst();
sst.count = XmlHelper.ReadInt(xml.DocumentElement.Attributes["count"]);
sst.uniqueCount = XmlHelper.ReadInt(xml.DocumentElement.Attributes["uniqueCount"]);
XmlNodeList nl = xml.SelectNodes("//d:sst/d:si", namespaceManager);
if (nl != null)
{
foreach (XmlNode node in nl)
{
CT_Rst rst = CT_Rst.Parse(node, namespaceManager);
sstDoc.sst.si.Add(rst);
}
}
return(sstDoc);
}
catch (XmlException e)
{
throw new IOException(e.Message);
}
}
private CT_PhoneticPr phoneticPrField = null; // optional field
public void Set(CT_Rst o)
{
this.tField = o.tField;
this.rField = o.rField;
this.rPhField = o.rPhField;
this.phoneticPrField = o.phoneticPrField;
}
private CT_PhoneticPr phoneticPrField = null; // optional field
public void Set(CT_Rst o)
{
this.tField = o.tField;
this.rField = o.rField;
this.rPhField = o.rPhField;
this.phoneticPrField = o.phoneticPrField;
}
//public CT_Cell()
//{
// this.extLstField = new CT_ExtensionList();
// //this.isField = new CT_Rst();
// //this.fField = new CT_CellFormula();
// this.sField = (uint)(0);
// this.tField = ST_CellType.n;
// this.cmField = ((uint)(0));
// this.vmField = ((uint)(0));
// this.phField = false;
//}
public void Set(CT_Cell cell)
{
fField = cell.fField;
vField = cell.vField;
isField = cell.isField;
extLstField = cell.extLstField;
rField = cell.rField;
sField = cell.sField;
tField = cell.tField;
cmField = cell.cmField;
vmField = cell.vmField;
phField = cell.phField;
}
//public CT_Cell()
//{
// this.extLstField = new CT_ExtensionList();
// //this.isField = new CT_Rst();
// //this.fField = new CT_CellFormula();
// this.sField = (uint)(0);
// this.tField = ST_CellType.n;
// this.cmField = ((uint)(0));
// this.vmField = ((uint)(0));
// this.phField = false;
//}
public void Set(CT_Cell cell)
{
fField = cell.fField;
vField = cell.vField;
isField = cell.isField;
extLstField = cell.extLstField;
rField = cell.rField;
sField = cell.sField;
tField = cell.tField;
cmField = cell.cmField;
vmField = cell.vmField;
phField = cell.phField;
}
public static SstDocument Parse(XmlDocument xml, XmlNamespaceManager namespaceManager)
{
try
{
SstDocument sstDoc=new SstDocument();
sstDoc.AddNewSst();
XmlNodeList nl = xml.SelectNodes("//d:sst/d:si", namespaceManager);
if (nl != null)
{
foreach (XmlNode node in nl)
{
XmlNode n = node.SelectSingleNode("d:t", namespaceManager);
CT_Rst rst = new CT_Rst();
rst.XmlText = node.InnerXml;
if (n != null)
{
rst.t = n.InnerText;
}
else
{
XmlNodeList tNodes = node.SelectNodes(".//d:t", namespaceManager);
if (tNodes != null)
{
rst.r = new System.Collections.Generic.List<CT_RElt>();
foreach (XmlNode tNode in tNodes)
{
CT_RElt relt = new CT_RElt();
relt.t = tNode.InnerText;
rst.r.Add(relt);
}
}
}
sstDoc.sst.si.Add(rst);
}
}
return sstDoc;
}
catch (XmlException e)
{
throw new IOException(e.Message);
}
} /// <summary>
public static CommentsDocument Parse(XmlDocument xmlDoc, XmlNamespaceManager NameSpaceManager)
{
CommentsDocument commentsDoc = new CommentsDocument();
commentsDoc.comments = new CT_Comments();
foreach (XmlElement node in xmlDoc.SelectNodes("//d:authors/d:author", NameSpaceManager))
{
commentsDoc.comments.authors.AddAuthor(node.InnerText);
}
foreach (XmlElement node in xmlDoc.SelectNodes("//d:commentList/d:comment", NameSpaceManager))
{
CT_Comment comment = commentsDoc.comments.commentList.AddNewComment();
comment.authorId = uint.Parse(node.GetAttribute("authorId"));
comment.@ref = node.GetAttribute("ref");
comment.text = CT_Rst.Parse(node.ChildNodes[0], NameSpaceManager);
}
return(commentsDoc);
}
public static SstDocument Parse(XmlDocument xml, XmlNamespaceManager namespaceManager)
{
try
{
SstDocument sstDoc = new SstDocument();
sstDoc.AddNewSst();
XmlNodeList nl = xml.SelectNodes("//d:sst/d:si", namespaceManager);
if (nl != null)
{
foreach (XmlNode node in nl)
{
XmlNode n = node.SelectSingleNode("d:t", namespaceManager);
CT_Rst rst = new CT_Rst();
rst.XmlText = node.InnerXml;
if (n != null)
{
rst.t = n.InnerText;
}
else
{
XmlNodeList tNodes = node.SelectNodes(".//d:t", namespaceManager);
if (tNodes != null)
{
rst.r = new System.Collections.Generic.List <CT_RElt>();
foreach (XmlNode tNode in tNodes)
{
CT_RElt relt = new CT_RElt();
relt.t = tNode.InnerText;
rst.r.Add(relt);
}
}
}
sstDoc.sst.si.Add(rst);
}
}
return(sstDoc);
}
catch (XmlException e)
{
throw new IOException(e.Message);
}
} /// <summary>
public static CT_Cell Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_Cell ctObj = new CT_Cell();
ctObj.r = XmlHelper.ReadString(node.Attributes["r"]);
ctObj.s = XmlHelper.ReadUInt(node.Attributes["s"]);
if (node.Attributes["t"] != null)
{
ctObj.t = (ST_CellType)Enum.Parse(typeof(ST_CellType), node.Attributes["t"].Value);
}
ctObj.cm = XmlHelper.ReadUInt(node.Attributes["cm"]);
ctObj.vm = XmlHelper.ReadUInt(node.Attributes["vm"]);
ctObj.ph = XmlHelper.ReadBool(node.Attributes["ph"]);
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "f")
{
ctObj.f = CT_CellFormula.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "v")
{
ctObj.v = childNode.InnerText;
}
else if (childNode.LocalName == "is")
{
ctObj.@is = CT_Rst.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "extLst")
{
ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager);
}
}
return(ctObj);
}
private string guidField = null; // optional attribute
//public CT_Comment()
//{
// this.textField = new CT_Rst();
//}
public static CT_Comment Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_Comment ctObj = new CT_Comment();
ctObj.@ref = XmlHelper.ReadString(node.Attributes["ref"]);
if (node.Attributes["authorId"] != null)
{
ctObj.authorId = XmlHelper.ReadUInt(node.Attributes["authorId"]);
}
ctObj.guid = XmlHelper.ReadString(node.Attributes["guid"]);
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "text")
{
ctObj.text = CT_Rst.Parse(childNode, namespaceManager);
}
}
return(ctObj);
}
public void GetCellComment()
{
CommentsTable sheetComments = new CommentsTable();
CT_Comments comments = sheetComments.GetCTComments();
CT_CommentList commentList = comments.commentList;
// Create 2 comments for A1 and A" cells
CT_Comment comment0 = commentList.InsertNewComment(0);
comment0.@ref = "A1";
CT_Rst ctrst0 = new CT_Rst();
ctrst0.t = (TEST_A1_TEXT);
comment0.text = (ctrst0);
CT_Comment comment1 = commentList.InsertNewComment(0);
comment1.@ref = ("A2");
CT_Rst ctrst1 = new CT_Rst();
ctrst1.t = (TEST_A2_TEXT);
comment1.text = (ctrst1);
// Test Finding the right comment for a cell
Assert.AreSame(comment0, sheetComments.GetCTComment("A1"));
Assert.AreSame(comment1, sheetComments.GetCTComment("A2"));
Assert.IsNull(sheetComments.GetCTComment("A3"));
}
/**
* Create a rich text string
*/
public XSSFRichTextString(String str)
{
st = new CT_Rst();
st.t = str;
PreserveSpaces(st.t);
}
public void TestUtfDecode()
{
CT_Rst st = new CT_Rst();
st.t = ("abc_x000D_2ef_x000D_");
XSSFRichTextString rt = new XSSFRichTextString(st);
//_x000D_ is Converted into carriage return
Assert.AreEqual("abc\r2ef\r", rt.String);
}
public void unsetIs()
{
this.isField = null;
}
public void TestCreateNew()
{
SharedStringsTable sst = new SharedStringsTable();
CT_Rst st;
int idx;
// Check defaults
Assert.IsNotNull(sst.Items);
Assert.AreEqual(0, sst.Items.Count);
Assert.AreEqual(0, sst.Count);
Assert.AreEqual(0, sst.UniqueCount);
st = new CT_Rst();
st.t = ("Hello, World!");
idx = sst.AddEntry(st);
Assert.AreEqual(0, idx);
Assert.AreEqual(1, sst.Count);
Assert.AreEqual(1, sst.UniqueCount);
//add the same entry again
idx = sst.AddEntry(st);
Assert.AreEqual(0, idx);
Assert.AreEqual(2, sst.Count);
Assert.AreEqual(1, sst.UniqueCount);
//and again
idx = sst.AddEntry(st);
Assert.AreEqual(0, idx);
Assert.AreEqual(3, sst.Count);
Assert.AreEqual(1, sst.UniqueCount);
st = new CT_Rst();
st.t = ("Second string");
idx = sst.AddEntry(st);
Assert.AreEqual(1, idx);
Assert.AreEqual(4, sst.Count);
Assert.AreEqual(2, sst.UniqueCount);
//add the same entry again
idx = sst.AddEntry(st);
Assert.AreEqual(1, idx);
Assert.AreEqual(5, sst.Count);
Assert.AreEqual(2, sst.UniqueCount);
st = new CT_Rst();
CT_RElt r = st.AddNewR();
CT_RPrElt pr = r.AddNewRPr();
pr.AddNewColor().SetRgb(new byte[] { (byte)0xFF, 0, 0 }); //red
pr.AddNewI().val = (true); //bold
pr.AddNewB().val = (true); //italic
r.t = ("Second string");
idx = sst.AddEntry(st);
Assert.AreEqual(2, idx);
Assert.AreEqual(6, sst.Count);
Assert.AreEqual(3, sst.UniqueCount);
idx = sst.AddEntry(st);
Assert.AreEqual(2, idx);
Assert.AreEqual(7, sst.Count);
Assert.AreEqual(3, sst.UniqueCount);
//OK. the sst table is Filled, check the contents
Assert.AreEqual(3, sst.Items.Count);
Assert.AreEqual("Hello, World!", new XSSFRichTextString(sst.GetEntryAt(0)).ToString());
Assert.AreEqual("Second string", new XSSFRichTextString(sst.GetEntryAt(1)).ToString());
Assert.AreEqual("Second string", new XSSFRichTextString(sst.GetEntryAt(2)).ToString());
}
public static CT_Rst Parse(XmlNode xmlNode, XmlNamespaceManager namespaceManager)
{
CT_Rst rst = new CT_Rst();
rst.r = new List<CT_RElt>();
var rNodes = xmlNode.SelectNodes("d:r", namespaceManager);
foreach (XmlNode rNode in rNodes)
{
CT_RElt relt = rst.AddNewR();
var rPrNode = rNode.SelectSingleNode("d:rPr", namespaceManager);
if (rPrNode != null)
{
CT_RPrElt rprelt = relt.AddNewRPr();
foreach (XmlNode childNode in rPrNode.ChildNodes)
{
switch (childNode.Name)
{
case "b":
CT_BooleanProperty bprop= rprelt.AddNewB();
bprop.val = true;
break;
case "i":
CT_BooleanProperty iprop = rprelt.AddNewI();
iprop.val = true;
break;
case "u":
CT_UnderlineProperty uProp = rprelt.AddNewU();
uProp.val = (ST_UnderlineValues)Enum.Parse(typeof(ST_UnderlineValues), childNode.Attributes["val"].Value);
break;
case "color":
CT_Color color = rprelt.AddNewColor();
if(childNode.Attributes["theme"]!=null)
color.theme = uint.Parse(childNode.Attributes["theme"].Value);
if(childNode.Attributes["auto"]!=null)
color.auto = childNode.Attributes["auto"].Value=="1"?true:false;
if(childNode.Attributes["indexed"]!=null)
color.indexed = uint.Parse(childNode.Attributes["indexed"].Value);
if(childNode.Attributes["tint"]!=null)
color.tint = Double.Parse(childNode.Attributes["tint"].Value);
break;
case "rFont":
CT_FontName fontname = rprelt.AddNewRFont();
fontname.val = childNode.Attributes["val"].Value;
break;
case "family":
CT_IntProperty familyProp = rprelt.AddNewFamily();
familyProp.val = Int32.Parse(childNode.Attributes["val"].Value);
break;
case "charset":
CT_IntProperty charsetProp = rprelt.AddNewCharset();
charsetProp.val = Int32.Parse(childNode.Attributes["val"].Value);
break;
case "scheme":
CT_FontScheme schemeProp = rprelt.AddNewScheme();
schemeProp.val = (ST_FontScheme)Enum.Parse(typeof(ST_FontScheme), childNode.Attributes["val"].Value);
break;
case "sz":
CT_FontSize szProp = rprelt.AddNewSz();
szProp.val = Int32.Parse(childNode.Attributes["val"].Value);
break;
case "vertAlign":
CT_VerticalAlignFontProperty vertAlignProp = rprelt.AddNewVertAlign();
vertAlignProp.val = (ST_VerticalAlignRun)Enum.Parse(typeof(ST_VerticalAlignRun), childNode.Attributes["val"].Value);
break;
}
}
}
var tNode = rNode.SelectSingleNode("d:t", namespaceManager);
relt.t = tNode.InnerText.Replace("\r","");
}
return rst;
}
public static CT_Rst Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
CT_Rst ctObj = new CT_Rst();
ctObj.r = new List<CT_RElt>();
ctObj.rPh = new List<CT_PhoneticRun>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "phoneticPr")
ctObj.phoneticPr = CT_PhoneticPr.Parse(childNode, namespaceManager);
else if (childNode.LocalName == "r")
ctObj.r.Add(CT_RElt.Parse(childNode, namespaceManager));
else if (childNode.LocalName == "rPh")
ctObj.rPh.Add(CT_PhoneticRun.Parse(childNode, namespaceManager));
else if (childNode.LocalName == "t")
ctObj.t = childNode.InnerText.Replace("\r", "");
}
return ctObj;
}
/**
* Create empty rich text string and Initialize it with empty string
*/
public XSSFRichTextString()
{
st = new CT_Rst();
}
public void unsetIs()
{
this.isField = null;
}
/**
* Create a rich text string from the supplied XML bean
*/
public XSSFRichTextString(CT_Rst st)
{
this.st = st;
}
internal SortedDictionary<int, CT_RPrElt> GetFormatMap(CT_Rst entry)
{
int length = 0;
SortedDictionary<int, CT_RPrElt> formats = new SortedDictionary<int, CT_RPrElt>();
foreach (CT_RElt r in entry.r)
{
String txt = r.t;
CT_RPrElt fmt = r.rPr;
length += txt.Length;
formats[length] = fmt;
}
return formats;
}
CT_Rst buildCTRst(String text, SortedDictionary<int, CT_RPrElt> formats)
{
if (text.Length != GetLastKey(formats.Keys))
{
throw new ArgumentException("Text length was " + text.Length +
" but the last format index was " + GetLastKey(formats.Keys));
}
CT_Rst st = new CT_Rst();
int runStartIdx = 0;
for (SortedDictionary<int, CT_RPrElt>.KeyCollection.Enumerator it = formats.Keys.GetEnumerator(); it.MoveNext(); )
{
int runEndIdx = it.Current;
CT_RElt run = st.AddNewR();
String fragment = text.Substring(runStartIdx, runEndIdx - runStartIdx);
run.t = (fragment);
PreserveSpaces(run.t);
CT_RPrElt fmt = formats[runEndIdx];
if (fmt != null)
run.rPr = (fmt);
runStartIdx = runEndIdx;
}
return st;
}
