private void loadToolStripMenuItem_Click(object sender, EventArgs e)
{
//options for filetypes in the open file window
openFileDialog1.Filter = "All files (*.*)|*.*|xml files (*.xml)|*.xml";
openFileDialog1.FilterIndex = 2;
//checks if the user selected a file
if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{ // loading from the xml file
using (XMLInterface loadFile = new XMLInterface(openFileDialog1.OpenFile()))
if (loadFile != null) //if the path isnt null
{
try
{
sheet = loadFile.XMLLoad();
sheet.CellPropertyChanged += Sheet_CellPropertyChanged; //subscribes to the sheets event handler
selectedCell = sheet.GetCell(0, 49) as SpreadsheetCell; //sets a default selected cell to prevent crashes
ForceSheetUpdate();
}
catch (Exception except)
{
Console.WriteLine(except.Message);
}
}
}
}
private void listoxml_Click(object sender, EventArgs e)
{
if (formating.SelectedIndex < 0)
{
return;
}
if (ListOfAnimal.Count == 0)
{
return;
}
XMLInterface f = ListOfFormating[formating.SelectedIndex];
f.Bind(new List <Object>(ListOfAnimal));
f.ShowDialog();
}
private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
//options for filetypes in the save file window
saveFileDialog1.Filter = "All files (*.*)|*.*|xml files (*.xml)|*.xml";
saveFileDialog1.FilterIndex = 2;
if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
//using cleans up after itself by calling Dispose once its done.
using (XMLInterface saveFile = new XMLInterface(saveFileDialog1.OpenFile())) //opens the save file window and makes an XMLInterface with the path
if (saveFile != null) //if the path isnt null
{
saveFile.XMLSave(sheet.GetUsedCells());
} //write to the file
}
}
