.net - Serialize Deserialize to/from xlsx -


given following assemblage of classes (contrived):

public class school {   [primarykey]   public string name {get; set;}   [set]   public ilist<teacher> teachers {get; set;}  public class teacher {   [primarykey]   public string name {get; set;} 

i'd have object hierarchy serialized single sheet of xlsx file, like

school.name            teacher.name waldorf college        ms. briggs waldorf college        mr. smith starfleet academy      mr. spock starfleet academy      mr. sulu starfleet academy      mr. kirk 

i'd deserialize (sensible) modifications xlsx file, creating new copy of school, , associated teachers.

does know of similar doesn't require touching openxml libraries much?

thanks.

you can use ado.net , linq.

using ado.net create , alter excel file... <= first link found helps.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -