Workbook RemoveExternalLinks

Aspose.Cells Product Family
1

Hi
I am using RemoveExternalLinks.
1. Is there a way to iterate the External Links list?
2. What does the meaning of Excel WorkBook->External Links?

THANKS
2

Hi Oren,


Thank you for contacting Aspose support.

You can iterate over the list of external links using the following snippet.

C#

var book = new Workbook(dir + “sample-links.xls”);
for (int index = 0; index < book.Worksheets.ExternalLinks.Count; index++)
{
var link = book.Worksheets.ExternalLinks[index];
Console.WriteLine(link.DataSource);
}

Regarding the other part of your inquiry, I am afraid, I didn't get the question. Could you please provide the context of the mentioned statement or where have to read it? Please note, ExternalLinkCollection object is accessible from WorksheetCollection object therefore it is not directly associated with the Workbook.
3

Hi
I am using this code in order to remove external links. The function is a method of Workbook. I need to iterate external links of Workbook object.

workbook.RemoveExternalLinks();
Please explain.

4

Hi,


Thanks for your posting and using Aspose.Cells.

Please use the Workbook.Worksheets.ExternalLinks property to iterate all the external links. It should fit your needs. Let us know your feedback.