private void OkBtn_Click(object sender, EventArgs e)
{
XLDocument.Header header = new XLDocument.Header();
string office = (string)OfficeDDL.SelectedValue;
string footer = (string)DeptDDL.SelectedValue;
header = XLDocument.MapHeaderFooter(office, footer);
if (header != null)
{
XLDocument.DeployHeader(header);
XLDocument.UpdateParameter("HeaderDeployed", "true");
}
this.Close();
}