Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: .NET
Expertise: Advanced
May 5, 2017

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);
   }
 }
Srinath M S
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date