private static void FillPropertiesData(XElement Material, IList <Models.ExportPropertyGeneral> properties)
{
XElement Properties = new XElement("Propertes");
foreach (var item in properties)
{
XElement Property = new XElement("Property");
XElement Name = new XElement("Name");
Name.Value = item.Name;
Property.Add(Name);
XElement Temperature = new XElement("Temperature");
Temperature.Value = item.Temperature == 999 ? "-" : item.Temperature.ToString();
Property.Add(Temperature);
XElement Value = new XElement("Value");
if (item.Values != null && item.Values.Count > 0)
{
string val = "";
foreach (var item1 in item.Values)
{
val = val + item1.X.Trim() + ", " + item1.Y.ToString().Trim() + "; ";
}
Value.Value = val;
}
else
{
Value.Value = item.Value;
}
Property.Add(Value);
XElement Unit = new XElement("Unit");
Unit.Value = item.Unit == null ? "" : item.Unit;
Property.Add(Unit);
XElement Comment = new XElement("Note");
Comment.Value = item.Note == null ? "" : HtmlRemoval.StripTagsRegex(item.Note);
Property.Add(Comment);
Properties.Add(Property);
}
Material.Add(Properties);
}
public static System.IO.MemoryStream FillKTMXLS(IList <Models.ExportPropertyGeneral> properties)
{
System.IO.MemoryStream memoryStreamKTMXls = new System.IO.MemoryStream();
ExcelApplication excel = new ExcelApplication();
Workbook book;
book = excel.Create(ExcelApplication.FileFormat.Xls);
Worksheet sheet = book.Worksheets[0];
//property
ColumnProperties colProps0 = sheet.GetColumnProperties(0);
colProps0.Width = 180;
//temperature
ColumnProperties colProps1 = sheet.GetColumnProperties(1);
colProps1.Width = 60;
//value
ColumnProperties colProps2 = sheet.GetColumnProperties(2);
colProps2.Width = 150;
//unit
ColumnProperties colProps3 = sheet.GetColumnProperties(3);
colProps3.Width = 50;
//note
ColumnProperties colProps4 = sheet.GetColumnProperties(4);
colProps4.Width = 350;
sheet.Name = "export";
Palette pal = book.Palette;
Color clrYellow = pal.GetClosestColor(255, 255, 0);
sheet[0, 0].Value = "Property";
sheet[0, 0].Style.BackgroundColor = clrYellow;
sheet[0, 1].Value = "T (°C)";
sheet[0, 1].Style.BackgroundColor = clrYellow;
sheet[0, 2].Value = "Value";
sheet[0, 2].Style.BackgroundColor = clrYellow;
sheet[0, 3].Value = "Unit";
sheet[0, 3].Style.BackgroundColor = clrYellow;
sheet[0, 4].Value = "Note";
sheet[0, 4].Style.BackgroundColor = clrYellow;
int count = 0;
for (int i = 0; i < properties.Count; i++)
{
count = count + 1;
sheet[count, 0].Value = properties[i].Name;
sheet[count, 0].Style.WrapText = true;
if (properties[i].Temperature == 999)
{
sheet[count, 1].Value = "-";
}
else
{
sheet[count, 1].Value = properties[i].Temperature;
}
if (properties[i].Values != null && properties[i].Values.Count > 0)
{
string val = "";
foreach (var item in properties[i].Values)
{
val = val + item.X.Trim() + ", " + item.Y.ToString().Trim() + "; ";
}
sheet[count, 2].Value = val;
}
else
{
sheet[count, 2].Value = properties[i].Value;
}
sheet[count, 2].Style.WrapText = true;
sheet[count, 3].Value = properties[i].Unit;
if (properties[i].Note != null)
{
sheet[count, 4].Value = HtmlRemoval.StripTagsRegex(properties[i].Note);
sheet[count, 4].Style.WrapText = true;
}
}
excel.Save(book, memoryStreamKTMXls);
return(memoryStreamKTMXls);
}