public static void ImportFromExcel(string filepath) { FileStream stream; Loop: try { stream = File.Open(filepath, FileMode.Open, FileAccess.Read); } catch { MessageBoxResult result = MessageBox.Show("Error. Please close the excel document. Retry?", "Error", MessageBoxButton.OKCancel); if (result == MessageBoxResult.OK) { goto Loop; } else { return; } } _model = new railml(); _coordtable = CreateCoordTable(); IExcelDataReader excelreader = ExcelReaderFactory.CreateOpenXmlReader(stream); excelreader.IsFirstRowAsColumnNames = true; _dataset = excelreader.AsDataSet(); _maintable = _dataset.Tables[0]; _maintable = GetParentLines(_maintable); GetTracks(_maintable); DataContainer.model = _model; }
public static railml ImportFile(string filename) { railml railmlmodel = new railml(); using (FileStream xmlStream = new FileStream(filename, FileMode.Open)) { using (XmlReader xmlReader = XmlReader.Create(xmlStream)) { railmlmodel = (railml)serializer.Deserialize(xmlReader); } } return(railmlmodel); }