public class XmlImport 
    {
         ///<summary>
         ///Build the report with ExcelTemplate
         ///</summary>
        public void GenerateReport()
                {
                        // These are the names of the values in WeatherData arrayarray 
                        string[] colNames = { "Date", "Temp", "Humidity", "Wind" };

                        // Read the XML document into an object arrayarray 
                        object[][] weatherData = ParseXml();

                        // Create an instance of SoftArtisans ExcelTemplateExcelTemplate 
                        ExcelTemplate xlt = new ExcelTemplate();

                        // Open the template workbookworkbook 
                        string templatePath = @"..\..\templatesExcelTemplateFiles\XMLImportTemplate.xlsx";
                        xlt.Open(templatePath);

                        // Bind the WeatherData array to the template
                        // %%=Weather.Date, %%=Weather.Temp
                        // %%=Weather.Humidity, %%=Weather.Wind
                                   
            DataBindingProperties bindingProperties = xlt.CreateDataBindingProperties();
                        bindingProperties.MaxRows = ExcelTemplate.ALL_ROWS;
                        bindingProperties.Transpose = true;
                        xlt.BindData(weatherData, colNames, "Weather", bindingProperties);

                        // Process the template to populate it with the Data Source datadata 
                        xlt.Process();

                        // Save the reportreport 
                        xlt.Save(@"..\..\OutputExcelOutputFiles\XmlWeatherReport_output.xlsx");
                }

                /// <summary> Load the XML weather report data into a 2-D
                 /// Object array.
                 /// </summary>
                /// <returns> <returns> Parsed XML data to be used with ExcelTemplate
                /// < </returns>
        
        private object[][] ParseXml()
                {
                        // Create an array with an element for each day of weather
                        // reported in the XML document
                        // There will be four elements in the first dimension
                        // to hold "Date", "Temp", "Humidity", and "Wind" data
                        // and one element in the second dimension for every day
                        // reported in the XML document
                                   

            XmlDocument doc = new XmlDocument();
                        doc.Load(@"..\..\DataExcelData\XMLWeatherData.xml");
                                   
            int NodeCount = doc.DocumentElement.ChildNodes.Count;

              string          string[][] WeatherData = new string[4][];
                                   
            for (int i = 0; i < WeatherData.Length; i++)
                                WeatherData[i] = new string[NodeCount];

                        // Loop through the days of weatherweather 

                        for (int i = 0; i < NodeCount; i++)
                        {
                                XmlNode DayNode = doc.DocumentElement.ChildNodes[i];

                                   //             
                //Read the weather values from the XML document into the array
                                if (DayNode.Name == "today")
                                        WeatherData[0][i] = DateTime.Now.ToString("d");
                                else
                                        WeatherData[0][i] = DateTime.Now.AddDays(i).ToString("d");
                               
                WeatherData[1][i] = DayNode.SelectSingleNode("temparature").InnerText;    
                                         WeatherData[2][i] = (Convert.ToDouble(DayNode.SelectSingleNode("humidity").InnerText) / 100).ToString();
                                        WeatherData[3][i] = DayNode.SelectSingleNode("wind").InnerText;        
                        }
                        return WeatherData;
         }         }
    }