public static void SaveToFile(string filePath, ExcelModel excel)
{
XmlSerializer serializer = new XmlSerializer(excel.GetType());
using (TextWriter tw = new StreamWriter(filePath, false, Encoding.UTF8))
{
serializer.Serialize(tw, excel);
}
}
ExcelModel CreateExcelModel(string[] keys, string[] values)
{
ExcelModel person = new ExcelModel();
var len = keys.Length;
for (int i = 0; i < len; i++)
{
person.GetType().GetField(keys[i]).SetValue(person, values[i]);
}
return(person);
}
public static ExcelModel FromFile(string filePath)
{
ExcelModel excel = new ExcelModel();
XmlSerializer serializer = new XmlSerializer(excel.GetType());
using (TextReader tr = new StreamReader(filePath, Encoding.UTF8))
{
excel = (ExcelModel)serializer.Deserialize(tr);
}
return(excel);
}
