Excel connection issue

Question

How to use expression in excel connection manager？Why i cant edit the string,i can only change the file path when click the connection string

Answer 1

Hi @Jefferson-2765 ,

Not really sure about your issue, do you mean the situation like shown below?

When you click more, you could only choose the path.

If you want to use expression in excel connection, you may roll down the manager connection.

If I misunderstand your issue, please incorrect me.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Jefferson-2765 ,

Excel file connection is controlled via ExcelFilePath property in the Expressions.
It should be a fully qualified file path.
Please see below.

Answer 3

Thanks all for your support!!!