devxlogo

Break the Data Links in an Excel Workbook

Break the Data Links in an Excel Workbook

Use this function to break the data links in an Excel workbook. It shows a message asking the user to confirm to break.

private void BreakDataLinks(Excel._Workbook wb){   if (DialogResult.Yes == MessageBox.Show(this,"Do you want to break the links to Data Sources ?", "Links",         MessageBoxButtons.YesNo))   {           Array links = (Array)wb.LinkSources(Excel.XlLink.xlExcelLinks);           if (links != null) {   for (int i = 1; i     {        wb.BreakLink((string)links.GetValue(i),        Excel.XlLinkType.xlLinkTypeExcelLinks);   } }

devx-admin

Share the Post: