public void Export(string fileName) { if (chkLst_Spell_list.CheckedItems != null) { DataTable dt = Spell.GenerateNewTable(); foreach (CheckBoxItems selectedItem in chkLst_Spell_list.CheckedItems) { string xmlPath = selectedItem.path; Controllers.SpellController sController = new Controllers.SpellController(xmlPath); Spell spell = sController.GetSpell(selectedItem.display); DataRow dr = dt.NewRow(); spell.PopulateDataRow(ref dr); dt.Rows.Add(dr); } DataSet ds = new DataSet(); ds.Tables.Add(dt); DND.Controllers.ExcelController excel = new Controllers.ExcelController(); excel.ExportDataSetToExcel(ds, fileName); } }
public void Export(string fileName) { if (chkLst_Bestiary_Selected.CheckedItems != null) { DataTable dt = Creature.GenerateNewTable(); foreach (CheckBoxItems selectedItem in chkLst_Bestiary_Selected.CheckedItems) { string xmlPath = selectedItem.path; Controllers.CreatureController sController = new Controllers.CreatureController(xmlPath); Creature creature = sController.GetCreature(selectedItem.display); DataRow dr = dt.NewRow(); creature.PopulateDataRow(ref dr); dt.Rows.Add(dr); } DataSet ds = new DataSet(); ds.Tables.Add(dt); DND.Controllers.ExcelController excel = new Controllers.ExcelController(); excel.ExportDataSetToExcel(ds, fileName); } }