/// <summary>
/// This is used to handle the change in value (selected index) for the worksheet dropdown combo.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void WorksheetCombo_Changed(object sender, EventArgs e)
{
if (ExcelSheetChangeClicked != null)
{
ExcelSheetChangeClicked.Invoke(Filename, worksheetCombo.SelectedValue);
}
}
/// <summary>
/// This is used to handle the change in value (selected index) for the worksheet dropdown combo.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void WorkSheetNameControl_SelectedIndexChanged(object sender, EventArgs e)
{
if (PopulatingDropDownData == false)
{
ComboBox cb = (ComboBox)sender;
ExcelSheetChangeClicked.Invoke(FileNameControl.Text, cb.SelectedValue.ToString());
if (tabControl1.SelectedTab.TabIndex == -1)
{
tabControl1.SelectedIndex = 0;
}
}
}
/// <summary>
/// This is used to handle the change in value (selected index) for the worksheet dropdown combo.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void WorksheetCombo_Changed(object sender, EventArgs e)
{
try
{
if (ExcelSheetChangeClicked != null)
{
ExcelSheetChangeClicked.Invoke(Filename, worksheetCombo.SelectedValue);
}
notebook1.CurrentPage = 0;
}
catch (Exception err)
{
ShowError(err);
}
}
