how to export clickable urls in excel from SSIS

• cascador84

  Valued Member

  Points: 62

  More actions

  May 9, 2025 at 8:53 am

  #4589326

  I'm using ssis to copy excel file from a template, and update some cells on each copied files. problem is that after generating the Excel filen when opening it, the cell that is supposed to contains the clickable url is still

  

  I have to select the cell, then click on the formula bar and then press Enter key to have the proper result:

  

  I'm using a Execute SQL Task Component (it's not a standard file with first row with header...) to proceed.

  INSERT INTO [Sheet1$B3:B3] VALUES (?)

  Is there a way to force the excel (maybe by updating the template one) to force the validation/keypress for this particular cell ?

  I've tried to add CHR(10) to the query

  INSERT INTO [Sheet1$B3:B3] VALUES (? + CHR(10))

  but it's not working (the carriage return is present on the formula, after hyperlink function, but still need to click on formula bar and press enter to have the clickable link...

  thanks in advance

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 10, 2025 at 9:10 am

  #4589653

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• kaj

  SSCommitted

  Points: 1616

  More actions

  May 12, 2025 at 12:56 pm

  #4590183

  I don't have an answer, but could you please clarify if you are using the ACE driver from Microsoft or some alternative third-party driver (like for example the CDATA ADO.NET Provider for Excel 2016)?

  Are you opening the xlsx file in MS Office or some other product capable of opening those files (like for example LibreOffice)?