private string GetSettingsFromValue(ExportExcelSettings s)
{
var result = "";
if (s != null)
{
if (s != null)
{
var doc = new XmlDocument();
var root = doc.CreateElement("settings");
doc.AppendChild(root);
var q = doc.CreateElement("setting");
var attr = doc.CreateAttribute("name");
var txt = doc.CreateTextNode("FileName");
attr.AppendChild(txt);
q.Attributes.Append(attr);
attr = doc.CreateAttribute("value");
txt = doc.CreateTextNode(s.FileName ?? "");
attr.AppendChild(txt);
q.Attributes.Append(attr);
root.AppendChild(q);
foreach (var sheet in s.Sheets)
{
q = doc.CreateElement("sheet");
attr = doc.CreateAttribute("name");
txt = doc.CreateTextNode(sheet.Name);
attr.AppendChild(txt);
q.Attributes.Append(attr);
attr = doc.CreateAttribute("items");
txt = doc.CreateTextNode(string.Join(",", (from a in sheet.SelectedItems select a.GetType().ToString()).ToArray()));
attr.AppendChild(txt);
q.Attributes.Append(attr);
root.AppendChild(q);
}
var sb = new StringBuilder();
var tr = new System.IO.StringWriter(sb);
var wr = new XmlTextWriter(tr);
wr.Formatting = Formatting.None;
doc.Save(wr);
wr.Close();
result = sb.ToString();
}
}
return(result);
}
private ExportExcelSettings GetSettingsFromValue(string v)
{
var result = new ExportExcelSettings();
if (!string.IsNullOrEmpty(v))
{
try
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(v);
XmlNodeList nl = doc.SelectNodes("/settings/setting");
foreach (XmlNode n in nl)
{
switch (n.Attributes["name"].Value)
{
case "FileName":
result.FileName = n.Attributes["value"].Value;
break;
}
}
nl = doc.SelectNodes("/settings/sheet");
foreach (XmlNode n in nl)
{
var sheet = new Excel.Sheet();
sheet.Name = n.Attributes["name"].Value;
var parts = n.Attributes["items"].Value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var p in parts)
{
var pi = (from a in Excel.PropertyItem.PropertyItems where a.GetType().ToString() == p select a).FirstOrDefault();
if (pi != null)
{
sheet.SelectedItems.Add(pi);
}
}
result.Sheets.Add(sheet);
}
}
catch
{
result = null;
}
}
return(result);
}
