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);
}
