/// <summary>
/// Extract the data from :
/// - Excel table
/// and create a csv file
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDynamicExtract_Click(object sender, RibbonControlEventArgs e)
{
var excelHandle = AddInUtils.GetExcelWindowHandle();
//userInputOption = GetUserInputOption(excelHandle);
bool secondWindowResult = false;
// ask for data input type
using (var frmDESelectInput = new frmDESelectInput())
{
do
{
if (frmDESelectInput.ShowDialog(excelHandle) == DialogResult.Cancel)
{
frmDESelectInput.Close();
return;
}
//frmDESelectInput.Hide();
// get what the user selected from the frmDESelectInput
// 1 = Tabular Form radio button
userInputOption = frmDESelectInput.UserSelection;
// user didn't press "Cancel" on the data input type form
if (userInputOption > 0)
{
switch (userInputOption)
{
// user selected the Tabular Form radio button
case 1:
// the user chose "Yes"
processTabularFormInput(excelHandle, frmDESelectInput);
break;
// user selected option 2 radio button
case 2:
processOption2Input(excelHandle, frmDESelectInput);
break;
}
}
}while (_secondWindowClosed == true);
frmDESelectInput.Close();
}
}