Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }