private void Button_Click_1(object sender, RoutedEventArgs e)
{
List <string> list = new List <string>();
Excel.Application appExcel = new Excel.Application();
Excel.Workbooks workBooks = appExcel.Workbooks;
Excel.Workbook excelSheet = workBooks.Open(@path, false, ReadOnly: true);
foreach (Excel.Worksheet worksheet1 in excelSheet.Worksheets)
{
Excel.Hyperlinks hyperLinks = worksheet1.Hyperlinks;
foreach (Excel.Hyperlink lin in hyperLinks)
{
list.Add(lin.Address);
}
}
@path2 += @"\res.xlsx";
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
for (int i = 1; i < list.Count() + 1; i++)
{
string el = "A" + i.ToString();
Aspose.Cells.Cell cell = worksheet.Cells[el];
int index = worksheet.Hyperlinks.Add(el, 1, 1, list[i - 1]);
worksheet.Hyperlinks[index].TextToDisplay = list[i - 1];
worksheet.Hyperlinks[index].ScreenTip = list[i - 1];
}
workbook.Save(@path2);
MessageBox.Show("Succesfull");
}
private ICollection <FileInfo> GetHyperLinksWorkSheet(Excel.Worksheet worksheet)
{
List <FileInfo> attachments = new List <FileInfo>();
Excel.Hyperlinks links = worksheet.Hyperlinks;
foreach (Excel.Hyperlink link in links)
{
if (link.Address != null)
{
String archivo = link.Address;
if (archivo != null && isFile(archivo))
{
attachments.Add(this.GetLinkFile(archivo));
}
}
}
return(attachments);
}
