private void button4_Click(object sender, EventArgs e)
{
using (var selectFileDialog = new OpenFileDialog())
{
selectFileDialog.Multiselect = true;
if (selectFileDialog.ShowDialog() == DialogResult.OK)
{
if (selectFileDialog.FileNames.Count() != 2)
{
return;
}
var tbl1 = _variableService.Compare(comboBox1.Text, selectFileDialog.FileNames[0]);
var tbl2 = _variableService.Compare(comboBox1.Text, selectFileDialog.FileNames[1]);
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "Excel|*.xlsx";
saveFileDialog1.Title = "Save file";
saveFileDialog1.ShowDialog();
// If the file name is not an empty string open it for saving.
if (saveFileDialog1.FileName != "" && Path.GetExtension(saveFileDialog1.FileName) == ".xlsx")
{
_variableService.ExportCompareTwoExcelFile(saveFileDialog1.FileName, comboBox1.Text, tbl1, tbl2);
}
}
}
}
