Post reply

how to export clickable urls in excel from SSIS

  • 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

    hyp1

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

    hyp2

    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

  • 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.

  • 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)?

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply