I am using below line to create link in excel but down load file is not happening when I click on it
IHyperLink hyperlink = sheet.HyperLinks.Add(sheet.Range[row, col + 1]);
hyperlink.Type = ExcelHyperLinkType.Url;
hyperlink.TextToDisplay = "Link";
hyperlink.Address = dr[columnNames[col]].ToString();