I want to convert my program to Spire.xls
However, I can't find linkSources() in Spire.xls
wb = ex.Workbooks.Open(trendPath);
object vntLink = (object)wb.LinkSources(); <-- I can't find
System.Array variantArray = (Array)vntLink;
for (int i = 1; i <= variantArray.Length; i++)
{
var j = variantArray.GetValue(i).ToString();
Debug.WriteLine(String.Format("j:{0}", j));
//delete yyyymmdd
var k = System.IO.Path.GetFileName(j);
var m = k.Substring(8);
Debug.WriteLine(String.Format("m:{0}", m));
foreach (var f in files)
{
Debug.WriteLine(String.Format("f:{0}", f));
if (f.ToString().EndsWith(m))
{
Debug.WriteLine(String.Format("{0}->{1}", j, f));
Console.WriteLine(String.Format("{0}->{1}", j, f));
wb.ChangeLink(j, f, Excel.XlLinkType.xlLinkTypeExcelLinks);
break;
}
}
}