private void BTN_Convert_Click(object sender, EventArgs e)
{
if (TXBX_OutputFileName.Text != "")
{
try
{
saveFileDialog1.DefaultExt = "."+CB_Formats.SelectedItem.ToString().ToLower();
saveFileDialog1.FileName = TXBX_OutputFileName.Text;
DialogResult result= saveFileDialog1.ShowDialog();
if (result == DialogResult.OK)
{
Workbook workbook = new Workbook(openFileDialog1.FileName);
switch (CB_Formats.SelectedItem.ToString())
{
case "CSV":
workbook.Save(saveFileDialog1.FileName, SaveFormat.CSV);
break;
case "PDF":
workbook.Save(saveFileDialog1.FileName, SaveFormat.Pdf);
break;
case "MHTML":
//Specify the HTML Saving Options
HtmlSaveOptions sv = new HtmlSaveOptions(SaveFormat.MHtml);
workbook.Save(saveFileDialog1.FileName, sv);
break;
default:
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}