private SimpleEntity CheckNodes(XmlTextReader xml) { if (xml.NodeType == XmlNodeType.Element && xml.IsStartElement()) { Flags.LastNode = xml.LocalName; } if (xml.NodeType == XmlNodeType.Text) { var v = new SimpleEntity() { Property = Flags.LastNode, Value = xml.Value }; return(v); } return(null); }
private void WriteExcel(SimpleEntity entity) { Application xlApp = new Application(); if (xlApp == null) { Log("Excel is not properly installed!!"); return; } xlApp.DisplayAlerts = false; Workbook xlWorkBook; Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; var currentDir = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location); var completeFilename = currentDir + "\\sample2.xls"; if (IsBeginOfFile()) { xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Worksheet)xlWorkBook.Worksheets[1]; if (File.Exists(completeFilename)) { File.Delete(completeFilename); } } else { if (File.Exists(completeFilename)) { xlWorkBook = xlApp.Workbooks.Open(completeFilename); xlWorkSheet = xlWorkBook.Worksheets[1]; } else { xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Worksheet)xlWorkBook.Worksheets[1]; } } if (entity.Property.ToLower() == xlWorkSheet.Cells[1, 1].Text.ToLower()) { Flags.rowCount++; Flags.columnCount = 1; } xlWorkSheet.Cells[1, Flags.columnCount] = entity.Property; xlWorkSheet.Cells[Flags.rowCount, Flags.columnCount] = entity.Value; Flags.columnCount++; xlWorkBook.SaveAs(completeFilename); xlWorkBook.Close(true); xlApp.Quit(); Marshal.ReleaseComObject(xlWorkSheet); Marshal.ReleaseComObject(xlWorkBook); Marshal.ReleaseComObject(xlApp); Log("Excel file created , you can find the file sample2.xls"); }